1berry/opencart
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
opencart/docs/api/source-catalog.model.cms.topic.html
Daniel Kerr be98c25d24 more api work
2024-03-04 23:29:14 +08:00

146 lines
15 KiB
HTML
Raw Permalink Blame History

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>File catalog\model\cms\topic.php | OpenCart API API</title>
<link rel="stylesheet" href="http://localhost\opencart-master/docs/api/assets/main.css">
<script src="http://localhost\opencart-master/docs/api/assets/main.js" defer></script>
</head>
<body class="layout">
<div class="layout-aside">
<div class="menu">
<div class="menu-section">
<h3>Namespaces</h3>
<ul>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.html">Opencart</a>
<ul>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.html">Admin</a>
</li>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.html">Catalog</a>
<ul>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Controller.html">Controller</a>
</li>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.html">Model</a>
<ul>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Account.html">Account</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Catalog.html">Catalog</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Checkout.html">Checkout</a>
</li>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Cms.html">Cms</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Design.html">Design</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Extension.html">Extension</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Localisation.html">Localisation</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Marketing.html">Marketing</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Report.html">Report</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Setting.html">Setting</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Tool.html">Tool</a>
</li>
</ul>
</li>
</ul>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.System.html">System</a>
</li>
</ul>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-none.html">none</a>
</li>
</ul>
</div>
<div class="menu-section">
<h3>Classes</h3>
<ul>
<li>
<a href="http://localhost\opencart-master/docs/api/Opencart.Catalog.Model.Cms.Antispam.html">
Antispam
</a>
</li>
<li>
<a href="http://localhost\opencart-master/docs/api/Opencart.Catalog.Model.Cms.Article.html">
Article
</a>
</li>
<li class="active">
<a href="http://localhost\opencart-master/docs/api/Opencart.Catalog.Model.Cms.Topic.html">
Topic
</a>
</li>
</ul>
</div>
</div>
</div>
<div class="layout-main">
<div class="layout-navbar">
<nav class="navbar">
<div class="navbar-left">
<ul class="navbar-links">
<li>
<a href="http://localhost\opencart-master/docs/api/index.html">Overview</a>
</li>
<li>
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.Model.Cms.html">Namespace</a>
</li>
<li class="active"><a href="http://localhost\opencart-master/docs/api/Opencart.Catalog.Model.Cms.Topic.html">Class</a></li> <li>
<a href="http://localhost\opencart-master/docs/api/tree.html">Tree</a>
</li>
</ul>
</div>
<div class="navbar-right">
<div class="search" data-elements="http://localhost\opencart-master/docs/api/assets/elements.js">
<input class="search-input" placeholder="Search class, function or namespace" autofocus>
<ul class="search-results"></ul>
</div>
</div>
</nav>
</div>
<div class="layout-content">
<table class="source"><tr id="1" class="source-line"><td><a class="source-lineNum" href="#1"> 1: </a></td><td><span class="php-tag">&lt;?php
</span></td></tr><tr id="2" class="source-line"><td><a class="source-lineNum" href="#2"> 2: </a></td><td><span class="php-tag"></span><span class="php-kw">namespace</span> Opencart\Catalog\Model\Cms;
</td></tr><tr id="3" class="source-line"><td><a class="source-lineNum" href="#3"> 3: </a></td><td><span class="php-comment">/**
</span></td></tr><tr id="4" class="source-line"><td><a class="source-lineNum" href="#4"> 4: </a></td><td><span class="php-comment"> * Class Topic
</span></td></tr><tr id="5" class="source-line"><td><a class="source-lineNum" href="#5"> 5: </a></td><td><span class="php-comment"> *
</span></td></tr><tr id="6" class="source-line"><td><a class="source-lineNum" href="#6"> 6: </a></td><td><span class="php-comment"> * @package Opencart\Catalog\Model\Cms
</span></td></tr><tr id="7" class="source-line"><td><a class="source-lineNum" href="#7"> 7: </a></td><td><span class="php-comment"> */</span>
</td></tr><tr id="8" class="source-line"><td><a class="source-lineNum" href="#8"> 8: </a></td><td><span class="php-kw">class</span> Topic <span class="php-kw">extends</span> \Opencart\System\Engine\Model {
</td></tr><tr id="9" class="source-line"><td><a class="source-lineNum" href="#9"> 9: </a></td><td> <span class="php-comment">/**
</span></td></tr><tr id="10" class="source-line"><td><a class="source-lineNum" href="#10">10: </a></td><td><span class="php-comment"> * Get Topic
</span></td></tr><tr id="11" class="source-line"><td><a class="source-lineNum" href="#11">11: </a></td><td><span class="php-comment"> *
</span></td></tr><tr id="12" class="source-line"><td><a class="source-lineNum" href="#12">12: </a></td><td><span class="php-comment"> * @param int $topic_id
</span></td></tr><tr id="13" class="source-line"><td><a class="source-lineNum" href="#13">13: </a></td><td><span class="php-comment"> *
</span></td></tr><tr id="14" class="source-line"><td><a class="source-lineNum" href="#14">14: </a></td><td><span class="php-comment"> * @return array&lt;int, array&lt;string, mixed&gt;&gt;
</span></td></tr><tr id="15" class="source-line"><td><a class="source-lineNum" href="#15">15: </a></td><td><span class="php-comment"> */</span>
</td></tr><tr id="16" class="source-line"><td><a class="source-lineNum" href="#16">16: </a></td><td> <span class="php-kw">public</span> <span class="php-kw">function</span> getTopic(int <span class="php-var">$topic_id</span>): <span class="php-kw">array</span> {
</td></tr><tr id="17" class="source-line"><td><a class="source-lineNum" href="#17">17: </a></td><td> <span class="php-var">$sql</span> = <span class="php-str">&quot;SELECT DISTINCT * FROM `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic` `t` LEFT JOIN `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic_description` `td` ON (`t`.`topic_id` = `td`.`topic_id`) LEFT JOIN `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic_to_store` `t2s` ON (`t`.`topic_id` = `t2s`.`topic_id`) WHERE `t`.`topic_id` = &#039;&quot;</span> . (int)<span class="php-var">$topic_id</span> . <span class="php-str">&quot;&#039; AND `td`.`language_id` = &#039;&quot;</span> . (int)<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_language_id&#039;</span>) . <span class="php-str">&quot;&#039; AND `t2s`.`store_id` = &#039;&quot;</span> . (int)<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_store_id&#039;</span>) . <span class="php-str">&quot;&#039; AND `t`.`status` = &#039;1&#039;&quot;</span>;
</td></tr><tr id="18" class="source-line"><td><a class="source-lineNum" href="#18">18: </a></td><td>
</td></tr><tr id="19" class="source-line"><td><a class="source-lineNum" href="#19">19: </a></td><td> <span class="php-var">$topic_data</span> = <span class="php-var">$this</span>-&gt;cache-&gt;get(<span class="php-str">&#039;topic.&#039;</span> . md5(<span class="php-var">$sql</span>));
</td></tr><tr id="20" class="source-line"><td><a class="source-lineNum" href="#20">20: </a></td><td>
</td></tr><tr id="21" class="source-line"><td><a class="source-lineNum" href="#21">21: </a></td><td> <span class="php-kw">if</span> (!<span class="php-var">$topic_data</span>) {
</td></tr><tr id="22" class="source-line"><td><a class="source-lineNum" href="#22">22: </a></td><td> <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-var">$sql</span>);
</td></tr><tr id="23" class="source-line"><td><a class="source-lineNum" href="#23">23: </a></td><td>
</td></tr><tr id="24" class="source-line"><td><a class="source-lineNum" href="#24">24: </a></td><td> <span class="php-var">$topic_data</span> = <span class="php-var">$query</span>-&gt;row;
</td></tr><tr id="25" class="source-line"><td><a class="source-lineNum" href="#25">25: </a></td><td>
</td></tr><tr id="26" class="source-line"><td><a class="source-lineNum" href="#26">26: </a></td><td> <span class="php-var">$this</span>-&gt;cache-&gt;set(<span class="php-str">&#039;topic.&#039;</span> . md5(<span class="php-var">$sql</span>), <span class="php-var">$topic_data</span>);
</td></tr><tr id="27" class="source-line"><td><a class="source-lineNum" href="#27">27: </a></td><td> }
</td></tr><tr id="28" class="source-line"><td><a class="source-lineNum" href="#28">28: </a></td><td>
</td></tr><tr id="29" class="source-line"><td><a class="source-lineNum" href="#29">29: </a></td><td> <span class="php-kw">return</span> <span class="php-var">$topic_data</span>;
</td></tr><tr id="30" class="source-line"><td><a class="source-lineNum" href="#30">30: </a></td><td> }
</td></tr><tr id="31" class="source-line"><td><a class="source-lineNum" href="#31">31: </a></td><td>
</td></tr><tr id="32" class="source-line"><td><a class="source-lineNum" href="#32">32: </a></td><td> <span class="php-comment">/**
</span></td></tr><tr id="33" class="source-line"><td><a class="source-lineNum" href="#33">33: </a></td><td><span class="php-comment"> * Get Topics
</span></td></tr><tr id="34" class="source-line"><td><a class="source-lineNum" href="#34">34: </a></td><td><span class="php-comment"> *
</span></td></tr><tr id="35" class="source-line"><td><a class="source-lineNum" href="#35">35: </a></td><td><span class="php-comment"> * @return array&lt;int, array&lt;string, mixed&gt;&gt;
</span></td></tr><tr id="36" class="source-line"><td><a class="source-lineNum" href="#36">36: </a></td><td><span class="php-comment"> */</span>
</td></tr><tr id="37" class="source-line"><td><a class="source-lineNum" href="#37">37: </a></td><td> <span class="php-kw">public</span> <span class="php-kw">function</span> getTopics(): <span class="php-kw">array</span> {
</td></tr><tr id="38" class="source-line"><td><a class="source-lineNum" href="#38">38: </a></td><td> <span class="php-var">$sql</span> = <span class="php-str">&quot;SELECT * FROM `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic` `t` LEFT JOIN `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic_description` `td` ON (`t`.`topic_id` = `td`.`topic_id`) LEFT JOIN `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;topic_to_store` `t2s` ON (`t`.`topic_id` = `t2s`.`topic_id`) WHERE `td`.`language_id` = &#039;&quot;</span> . (int)<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_language_id&#039;</span>) . <span class="php-str">&quot;&#039; AND `t2s`.`store_id` = &#039;&quot;</span> . (int)<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_store_id&#039;</span>) . <span class="php-str">&quot;&#039; AND `t`.`status` = &#039;1&#039; ORDER BY `t`.`sort_order` DESC&quot;</span>;
</td></tr><tr id="39" class="source-line"><td><a class="source-lineNum" href="#39">39: </a></td><td>
</td></tr><tr id="40" class="source-line"><td><a class="source-lineNum" href="#40">40: </a></td><td> <span class="php-var">$key</span> = md5(<span class="php-var">$sql</span>);
</td></tr><tr id="41" class="source-line"><td><a class="source-lineNum" href="#41">41: </a></td><td>
</td></tr><tr id="42" class="source-line"><td><a class="source-lineNum" href="#42">42: </a></td><td> <span class="php-var">$topic_data</span> = <span class="php-var">$this</span>-&gt;cache-&gt;get(<span class="php-str">&#039;topic.&#039;</span> . <span class="php-var">$key</span>);
</td></tr><tr id="43" class="source-line"><td><a class="source-lineNum" href="#43">43: </a></td><td>
</td></tr><tr id="44" class="source-line"><td><a class="source-lineNum" href="#44">44: </a></td><td> <span class="php-kw">if</span> (!<span class="php-var">$topic_data</span>) {
</td></tr><tr id="45" class="source-line"><td><a class="source-lineNum" href="#45">45: </a></td><td> <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-var">$sql</span>);
</td></tr><tr id="46" class="source-line"><td><a class="source-lineNum" href="#46">46: </a></td><td>
</td></tr><tr id="47" class="source-line"><td><a class="source-lineNum" href="#47">47: </a></td><td> <span class="php-var">$topic_data</span> = <span class="php-var">$query</span>-&gt;rows;
</td></tr><tr id="48" class="source-line"><td><a class="source-lineNum" href="#48">48: </a></td><td>
</td></tr><tr id="49" class="source-line"><td><a class="source-lineNum" href="#49">49: </a></td><td> <span class="php-var">$this</span>-&gt;cache-&gt;set(<span class="php-str">&#039;topic.&#039;</span> . <span class="php-var">$key</span>, <span class="php-var">$topic_data</span>);
</td></tr><tr id="50" class="source-line"><td><a class="source-lineNum" href="#50">50: </a></td><td> }
</td></tr><tr id="51" class="source-line"><td><a class="source-lineNum" href="#51">51: </a></td><td>
</td></tr><tr id="52" class="source-line"><td><a class="source-lineNum" href="#52">52: </a></td><td> <span class="php-kw">return</span> <span class="php-var">$topic_data</span>;
</td></tr><tr id="53" class="source-line"><td><a class="source-lineNum" href="#53">53: </a></td><td> }
</td></tr><tr id="54" class="source-line"><td><a class="source-lineNum" href="#54">54: </a></td><td>}
</td></tr><tr id="55" class="source-line"><td><a class="source-lineNum" href="#55">55: </a></td><td></td></tr></table>
</div>
<div class="layout-footer">
OpenCart API API documentation generated by <a href="https://www.apigen.org">ApiGen dev-master</a>
</div>
</div>
<div class="layout-rest">
<div class="navbar"></div>
</div>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink