-
Notifications
You must be signed in to change notification settings - Fork 12
/
stock.php
118 lines (105 loc) · 3.01 KB
/
stock.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
<?php
require_once('configs/config.php');
require_once('configs/functions.php');
$page_name = "stock";
$smarty->assign("page_name", $page_name);
if(isset($_SESSION['login']))
{
//For bestseller and instock or outstock
$stock = Check::getValue("stock");
$s = Check::getValue("s");
//For category
$cid = Check::getValue("cid");
//For pages
$page = Check::getValue("page");
//For add or sale products
$tax = $db->query('SELECT * FROM tax');
$seller = $db->query('SELECT * FROM seller');
$bank = $db->query('SELECT * FROM bank WHERE bank_active <> 0');
$customers = $db->query('SELECT * FROM customer');
$invoiceadj = $db->query('SELECT * FROM invoiceadj');
//Connect category db
$categories = $db->query("SELECT * FROM category main WHERE category_sub = 0", PDO::FETCH_ASSOC);
$cats = array();
foreach($categories as $c)
{
$cats[] = $c;
}
$acategories = $db->query("SELECT * FROM category main WHERE category_sub <> 0", PDO::FETCH_ASSOC);
$getir = array();
foreach ($acategories as $ac)
{
$getir[] = $ac;
}
//Pages
if($page)
{
$start = ($page-1)*12;
}
else
{
$start = 0;
}
$pages = "LIMIT ".$start.", 12";
//Checks
if(!$s)
{
$s = 0;
}
else if($s == "bestseller")
{
$s = 10;
}
if(!$cid)
{
$cid = "";
}
else
{
$cid = "AND stock_category_id = ".$cid;
}
if(!$stock)
{
$stock = "";
}
else
{
if($stock == "outstock")
{
$stock = "AND stock_amount = 0";
}
if($stock == "instock")
{
$stock = "AND stock_amount <> 0";
}
}
$stocklist = $db->query('SELECT *, (SELECT COALESCE(SUM(ip_id), 0) FROM invoicedproducts WHERE ip_stock_id = stock_id) AS total FROM stock
LEFT JOIN seller ON stock_seller_id = seller_id
LEFT JOIN tax ON stock_tax_id = tax_id
LEFT JOIN category ON stock_category_id = category_id
LEFT JOIN images ON images_stock_id = stock_id
WHERE (SELECT COALESCE(SUM(ip_id), 0) FROM invoicedproducts WHERE ip_stock_id = stock_id) >= '.$s.' '.$stock.' '.$cid.' '.$pages.' ');
$stocklist2 = $db->query('SELECT *, (SELECT COALESCE(SUM(ip_id), 0) FROM invoicedproducts WHERE ip_stock_id = stock_id) AS total FROM stock
LEFT JOIN seller ON stock_seller_id = seller_id
LEFT JOIN tax ON stock_tax_id = tax_id
LEFT JOIN category ON stock_category_id = category_id
LEFT JOIN images ON images_stock_id = stock_id
WHERE (SELECT COALESCE(SUM(ip_id), 0) FROM invoicedproducts WHERE ip_stock_id = stock_id) >= '.$s.' '.$stock.' '.$cid.' ');
$spages = $stocklist2->rowCount();
$pagetotal = ceil($spages/12);
$smarty->assign(array(
"categories" => $cats,
"acategories" => $getir,
"stocklist" => $stocklist,
"pagetotal" => $pagetotal,
"tax" => $tax,
"seller" => $seller,
"bank" => $bank,
"customers" => $customers,
"invoiceadj" => $invoiceadj,
));
$smarty->display(theme_base.'stock.html');
}//login
else{
$smarty->display(theme_base.'login.html');
}