public function getData($all = false, $order = '', $find = '', $idstr = '')
{
$ret = parent::getData($all, $order, $find, $idstr);
$sql = "SELECT * \n FROM moneyfororder " . (!empty($find) ? "WHERE (`customer` LIKE '%{$find}%' OR `order` LIKE '%{$find}%' ) " : "") . "GROUP BY `customer`, `order`,`mater`,`trud` " . (!empty($order) ? "ORDER BY {$order} " : "ORDER BY customer DESC ") . ($all ? "LIMIT 500" : "LIMIT 20");
$ret = sql::fetchAll($sql);
return $ret;
}
public function getData($all = false, $order = '', $find = '', $idstr = '')
{
$ret = parent::getData($all, $order, $find, $idstr);
extract($_SESSION[Auth::$lss]);
if (!empty($customer_id)) {
if (empty($order_id)) {
$sql = "SELECT *,IF(instr(file_link,'МПП')>0, 'МПП', IF(instr(file_link,'Блок')>0,'ДПП(Блок)','ДПП')) AS type,\n tz.id as tzid,tz.id\n FROM `tz`\n JOIN (orders, customers, users,filelinks)\n ON ( tz.order_id = orders.id AND orders.customer_id = customers.id\n AND tz.user_id = users.id AND filelinks.id=tz.file_link_id)\n WHERE customer_id='{$customer_id}'" . (!empty($find) ? "WHERE (number LIKE '%{$find}%')" : "") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY tz.id DESC ") . ($all ? "LIMIT 50" : "LIMIT 20");
} else {
$orderid = $order_id;
$sql = "SELECT *,IF(instr(file_link,'МПП')>0, 'МПП', IF(instr(file_link,'Блок')>0,'ДПП(Блок)','ДПП')) AS type,\n tz.id as tzid,tz.id FROM `tz`\n JOIN (orders, customers, users,filelinks)\n ON ( tz.order_id = orders.id AND orders.customer_id = customers.id\n AND tz.user_id = users.id AND filelinks.id=tz.file_link_id) " . (!empty($find) ? "WHERE (number LIKE '%{$find}%') AND order_id='{$orderid}' " : " WHERE order_id='{$orderid}' ") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY tz.id DESC ") . ($all ? "" : "LIMIT 20");
}
} else {
$sql = "SELECT *,IF(instr(file_link,'МПП')>0, 'МПП', IF(instr(file_link,'Блок')>0,'ДПП(Блок)','ДПП')) AS type,\n tz.id as tzid,tz.id\n FROM `tz`\n JOIN (orders, customers, users,filelinks)\n ON ( tz.order_id = orders.id AND orders.customer_id = customers.id\n AND tz.user_id = users.id AND filelinks.id=tz.file_link_id) " . (!empty($find) ? "WHERE (number LIKE '%{$find}%' OR tz.id LIKE '%{$find}%')" : "") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY tz.id DESC ") . ($all ? "LIMIT 50" : "LIMIT 20");
}
$ret = sql::fetchAll($sql);
if ($all) {
$_SESSION[Auth::$lss][tz_id] = '';
}
return $ret;
}
public function getData($all = false, $order = '', $find = '', $idstr = '')
{
$ret = parent::getData($all, $order, $find, $idstr);
// list($customer_id,$order_id,$tz_id,$posintzid) = explode(':',$idstr);
extract($_SESSION[Auth::$lss]);
if (!empty($tz_id)) {
$tzid = $tz_id;
$sql = "SELECT *,posintz.id as posid,posintz.id\n FROM `posintz`\n JOIN (blocks)\n ON ( posintz.block_id = blocks.id ) " . (!empty($find) ? "WHERE (blocks.blockname LIKE '%{$find}%') AND tz_id='{$tzid}' " : " WHERE tz_id='{$tzid}' ") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY posintz.id DESC ") . ($all ? "" : "LIMIT 20");
} else {
if (!empty($customer_id)) {
if (empty($order_id)) {
$sql = "SELECT *,tz.id AS tzid,posintz.id as posid,posintz.id\n FROM `posintz`\n JOIN (blocks,customers,orders,tz)\n ON ( posintz.block_id = blocks.id\n AND posintz.tz_id = tz.id\n AND orders.id = tz.order_id\n AND customers.id = orders.customer_id\n ) " . (!empty($find) ? "WHERE (blocks.blockname LIKE '%{$find}%') AND orders.customer_id='{$customer_id}' " : " WHERE orders.customer_id='{$customer_id}' ") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY posintz.id DESC ") . ($all ? "" : "LIMIT 20");
} else {
$sql = "SELECT *,tz.id AS tzid,posintz.id as posid,posintz.id\n FROM `posintz`\n JOIN (blocks,customers,orders,tz)\n ON ( posintz.block_id = blocks.id\n AND posintz.tz_id = tz.id\n AND orders.id = tz.order_id\n AND customers.id = orders.customer_id\n ) " . (!empty($find) ? "WHERE (blocks.blockname LIKE '%{$find}%') AND orders.id='{$order_id}' " : " WHERE orders.id='{$order_id}' ") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY posintz.id DESC ") . ($all ? "" : "LIMIT 20");
}
} else {
$sql = "SELECT *,tz.id AS tzid,posintz.id as posid,posintz.id\n FROM `posintz`\n JOIN (blocks,customers,orders,tz)\n ON ( posintz.block_id = blocks.id\n AND posintz.tz_id = tz.id\n AND orders.id = tz.order_id\n AND customers.id = orders.customer_id\n ) " . (!empty($find) ? "WHERE (blocks.blockname LIKE '%{$find}%') " : " ") . (!empty($order) ? " ORDER BY {$order} " : " ORDER BY posintz.id DESC ") . ($all ? "" : "LIMIT 20");
}
}
$ret = sql::fetchAll($sql);
return $ret;
}
public function getData($all = false, $order = '', $find = '', $idstr = '')
{
$ret = parent::getData($all, $order, $find, $idstr);
$order = strstr($order, 'files') ? '' : $order;
// не удается отсортировать по файлам
extract($_SESSION[Auth::$lss]);
if (empty($customer_id)) {
$sql = "SELECT *, orders.id AS oid,\n orders.id\n FROM orders\n JOIN customers\n ON customers.id=customer_id " . (!empty($find) ? "WHERE (number LIKE '%{$find}%' OR orderdate LIKE '%{$find}%' ) " : "") . (!empty($order) ? "ORDER BY {$order} " : "ORDER BY orders.orderdate DESC ") . ($all ? "LIMIT 50" : "LIMIT 20");
} else {
// sql
$sql = "SELECT *, orders.id AS oid, orders.id\n FROM orders\n JOIN customers ON customers.id=customer_id " . (!empty($find) ? "WHERE (number LIKE '%{$find}%' OR orderdate LIKE '%{$find}%' ) AND customer_id='{$customer_id}' " : "WHERE customer_id='{$customer_id}' ") . (!empty($order) ? "ORDER BY {$order} " : "ORDER BY orders.orderdate DESC ") . ($all ? "LIMIT 50" : "LIMIT 20");
}
$ret = sql::fetchAll($sql);
foreach ($ret as &$value) {
$files = $this->getFilesForId('orders', $value[id]);
$value[files] = $files[link];
}
if ($all) {
$_SESSION[Auth::$lss][order_id] = '';
$_SESSION[Auth::$lss][tz_id] = '';
}
return $ret;
}
