* Overhead Out aJax actions
* ******************************
*/
include '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$user_id = $_COOKIE['USERID'];
switch ($action) {
// case 'get_add_page':
// $page = GetPage();
// $data = array('page' => $page);
// break;
case 'get_edit_page':
$overhead_id = $_REQUEST['id'];
$page = GetPage_salar($overhead_id);
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$start = $_REQUEST['start'];
$end = $_REQUEST['end'];
$rResult = mysql_query("SELECT sale_transaction.id AS `id`,\n\t\t\t\t\t\t\t\t\t sale_transaction.end_date AS `date`,\n\t\t\t\t\t\t\t\t\t ROUND(sale_transaction.sum_cost, 2) AS `sum_cost`,\n\t\t\t\t\t\t\t\t\t ROUND(sale_transaction.payed_money, 2) AS `payed_money`,\n\t\t\t\t\t\t\t\t\t ROUND(sale_transaction.payed_money - sale_transaction.sum_cost, 2) AS `coin`,\n\t\t\t\t\t\t\t\t\t persons.`name` AS `person`\n\t\t\t\t\t\t\t\tFROM `sale_transaction`\n\t\t\t\t\t\t\t\tLEFT JOIN users ON sale_transaction.user_id = users.id\n\t\t\t\t\t\t\t\tLEFT JOIN persons ON users.person_id = persons.id\n\t\t\t\t\t\t\t\tWHERE (sale_transaction.`status` = 0) AND (DATE(sale_transaction.end_date) BETWEEN '{$start}' AND '{$end}')");
$data = array("aaData" => array());
if (!$rResult) {
$error = 'Invalid query: ' . mysql_error();
} else {
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
*/
include '../../includes/classes/core.php';
include '../../includes/classes/logger.class.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$user_id = $_COOKIE['USERID'];
$_log = Logger::instance('../../log/documents/overhead/', Logger::OFF);
switch ($action) {
case 'get_add_page':
$o_type = $_REQUEST['ot'];
$page = GetPage('', $o_type);
$data = array('page' => $page);
break;
case 'get_add_page_salar':
$page = GetPage_salar();
$data = array('page' => $page);
break;
case 'get_edit_page':
$overhead_id = $_REQUEST['id'];
$page = GetPage(GetOverhead($overhead_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$type = $_REQUEST['type'];
$confirm = $_REQUEST['confirm'];
//Out
if ($type == 0 && $confirm == 0) {
$rResult = mysql_query("SELECT `O`.`id` AS `id`,\n \t `O`.`waybill_number`,\n \t `OT`.`name` AS `type`,\n \t IFNULL(CONCAT('(',`O`.`buyer_tin`,') ', `O`.`buyer_name`),'()') AS `partner`,\n \t `O`.`full_amount`,\n \t `O`.`activate_date`\n \t FROM `overhead` AS `O` LEFT JOIN `overhead_types` AS `OT`\n \t ON `O`.`type` = `OT`.`id`\n \t WHERE `O`.`stream` = {$type} AND rs_id=0");
