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

161 lines
11 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 extension\opencart\admin\model\dashboard\map.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 active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.html">Admin</a>
<ul>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Controller.html">Controller</a>
</li>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.html">Model</a>
<ul>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Catalog.html">Catalog</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Cms.html">Cms</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Customer.html">Customer</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Design.html">Design</a>
</li>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.html">Extension</a>
<ul>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.html">Opencart</a>
<ul>
<li class="menuGroup-item active">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.Dashboard.html">Dashboard</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.Fraud.html">Fraud</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.Module.html">Module</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.Other.html">Other</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Extension.Opencart.Report.html">Report</a>
</li>
</ul>
</li>
</ul>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Localisation.html">Localisation</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Marketing.html">Marketing</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Report.html">Report</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Sale.html">Sale</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Setting.html">Setting</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.Tool.html">Tool</a>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.Model.User.html">User</a>
</li>
</ul>
</li>
</ul>
</li>
<li class="menuGroup-item">
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.html">Catalog</a>
</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 class="active">
<a href="http://localhost\opencart-master/docs/api/Opencart.Admin.Model.Extension.Opencart.Dashboard.Map.html">
Map
</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.Admin.Model.Extension.Opencart.Dashboard.html">Namespace</a>
</li>
<li class="active"><a href="http://localhost\opencart-master/docs/api/Opencart.Admin.Model.Extension.Opencart.Dashboard.Map.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\Admin\Model\Extension\Opencart\Dashboard;
</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 Map
</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\Admin\Model\Extension\Opencart\Dashboard
</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> Map <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 Total Orders By Country
</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"> * @return array&lt;int, array&lt;string, mixed&gt;&gt;
</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-kw">public</span> <span class="php-kw">function</span> getTotalOrdersByCountry(): <span class="php-kw">array</span> {
</td></tr><tr id="15" class="source-line"><td><a class="source-lineNum" href="#15">15: </a></td><td> <span class="php-var">$implode</span> = [];
</td></tr><tr id="16" class="source-line"><td><a class="source-lineNum" href="#16">16: </a></td><td>
</td></tr><tr id="17" class="source-line"><td><a class="source-lineNum" href="#17">17: </a></td><td> <span class="php-kw">if</span> (is_array(<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_complete_status&#039;</span>))) {
</td></tr><tr id="18" class="source-line"><td><a class="source-lineNum" href="#18">18: </a></td><td> <span class="php-kw">foreach</span> (<span class="php-var">$this</span>-&gt;config-&gt;get(<span class="php-str">&#039;config_complete_status&#039;</span>) <span class="php-kw">as</span> <span class="php-var">$order_status_id</span>) {
</td></tr><tr id="19" class="source-line"><td><a class="source-lineNum" href="#19">19: </a></td><td> <span class="php-var">$implode</span>[] = <span class="php-str">&quot;&#039;&quot;</span> . (int)<span class="php-var">$order_status_id</span> . <span class="php-str">&quot;&#039;&quot;</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> }
</td></tr><tr id="22" class="source-line"><td><a class="source-lineNum" href="#22">22: </a></td><td>
</td></tr><tr id="23" class="source-line"><td><a class="source-lineNum" href="#23">23: </a></td><td> <span class="php-kw">if</span> (<span class="php-var">$implode</span>) {
</td></tr><tr id="24" class="source-line"><td><a class="source-lineNum" href="#24">24: </a></td><td> <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-str">&quot;SELECT COUNT(*) AS `total`, SUM(`o`.`total`) AS `amount`, c.`iso_code_2` FROM `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;order` `o` LEFT JOIN `&quot;</span> . DB_PREFIX . <span class="php-str">&quot;country` c ON (`o`.`payment_country_id` = c.`country_id`) WHERE `o`.`order_status_id` IN(&quot;</span> . implode(<span class="php-str">&#039;,&#039;</span>, <span class="php-var">$implode</span>) . <span class="php-str">&quot;) AND `o`.`payment_country_id` != &#039;0&#039; GROUP BY `o`.`payment_country_id`&quot;</span>);
</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-kw">return</span> <span class="php-var">$query</span>-&gt;rows;
</td></tr><tr id="27" class="source-line"><td><a class="source-lineNum" href="#27">27: </a></td><td> } <span class="php-kw">else</span> {
</td></tr><tr id="28" class="source-line"><td><a class="source-lineNum" href="#28">28: </a></td><td> <span class="php-kw">return</span> [];
</td></tr><tr id="29" class="source-line"><td><a class="source-lineNum" href="#29">29: </a></td><td> }
</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></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