$count = $_REQUEST['count'];
$rResult = mysql_query("SELECT \treport.id,\n\t\t\t\t\t\t\t\t\t\t\t\t\tDATE(report.date) AS `date`,\n\t\t\t\t\t\t\t\t\t\t\t\t\tTIME(report.date) AS `time`,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.`in`,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.`out`,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.car,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.payed_money,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.coin,\n \t \t\t\t\t\t\t\t\t\t\treport.pay_type,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.person,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.object,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.parent,\n\t\t\t\t\t\t\t\t\t\t\t\t\treport.`comment`\n\t\t\t\t\t\t\t\t\tFROM\t\t\t(SELECT \tsale_transaction.id AS `id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsale_transaction.end_date AS `date`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tROUND(sale_transaction.sum_cost, 2) AS `in`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'' AS `out`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsale_transaction.car_number AS `car`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tROUND(sale_transaction.payed_money, 2) AS `payed_money`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tROUND(sale_transaction.payed_money - sale_transaction.sum_cost, 2) AS `coin`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(sale_transaction.pay_type = 1, 'ნაღდი', 'უნაღდო') AS `pay_type`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpersons.`name` AS `person`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tobj1.`name` AS `object`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tobj2.`name` AS `parent`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'' AS `comment`\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM \t\t`sale_transaction`\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tusers ON sale_transaction.user_id = users.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tpersons ON users.person_id = persons.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tobject AS `obj1` ON sale_transaction.object_id = obj1.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tobject AS `obj2` ON obj1.parent = obj2.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE \t(sale_transaction.end_date BETWEEN '{$start}' AND '{$end}') AND (sale_transaction.`status` = 0)\n\t\t\t\t\t\t\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\t\t\t\t\t\tSELECT \t\tCONCAT('p',pos_money_action.id) AS `id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpos_money_action.date AS `date`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(pos_money_action.action = 1, pos_money_action.money, '') AS `in`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(pos_money_action.action = 2, pos_money_action.money, '') AS `out`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'' AS `car`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'' AS `payed_money`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'' AS `coin`,\n \t \t\t\t\t\t\t\t\t\t\t\t\t\t'ნაღდი' AS `pay_type`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpersons.`name` AS `person`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tobj1.`name` AS `object`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tobj2.`name` AS `parent`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpos_money_action.`comment` AS `comment`\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM \t\t`pos_money_action`\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tusers ON pos_money_action.user_id = users.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tpersons ON users.person_id = persons.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tobject AS `obj1` ON pos_money_action.pos_id = obj1.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \tobject AS `obj2` ON obj1.parent = obj2.id\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE \tpos_money_action.date BETWEEN '{$start}' AND '{$end}') AS report\n\t\t\t\t\t\t\t\t\tORDER BY \t\treport.date DESC\n\t\t\t\t\t\t\t\t\t");
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
/* General output */
$row[] = $aRow[$i];
}
$data['aaData'][] = $row;
}
break;
case 'get-info':
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$page = GetInfoPage($start_date, $end_date);
$data = array('page' => $page);
break;
default:
echo "null";
}
$data['error'] = $error;
echo json_encode($data);
function GetInfoPage($start_date, $end_date)
{
$res = mysql_query("SELECT\t ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.pay_type = 1 AND sale_transaction.`status` = 0\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.pay_type = 2 AND sale_transaction.`status` = 0\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.`status` = 0");
$sales = array();
while ($row = mysql_fetch_assoc($res)) {
$sales[] = $row['money'];
}
$res2 = mysql_query("SELECT SUM(pos_money_action.money) AS `custom_money`\n\t\t\t\t\t\t\tFROM pos_money_action\n\t\t\t\t\t\t\tWHERE\tpos_money_action.action = 1 AND pos_money_action.date >= '{$start_date}' AND pos_money_action.date <= '{$end_date}' \n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT SUM(pos_money_action.money) AS `custom_money`\n\t\t\t\t\t\t\tFROM pos_money_action\n\t\t\t\t\t\t\tWHERE pos_money_action.action = 2 AND pos_money_action.date >= '{$start_date}' AND pos_money_action.date <= '{$end_date}'");
break;
case 'get_calls':
$data = array('calls' => getCalls());
break;
case 'category_change':
$information_category_id_check = $_REQUEST['information_category_id_check'];
$data = array('cat' => Getinformation_sub_category('', $information_category_id_check));
break;
case 'set_task_type':
$cat_id = $_REQUEST['cat_id'];
$data = array('cat' => Getbank_object($cat_id));
break;
case 'get-info':
$start1 = $_REQUEST['start'];
$end1 = $_REQUEST['end'];
$page = GetInfoPage($start1, $end1);
$data = array('page' => $page);
break;
case 'get_add_info':
$pin = $_REQUEST['pin'];
$data = array('info' => get_addition_all_info($pin));
break;
case 'get_add_info1':
$personal_id = $_REQUEST['personal_id'];
$data = array('info1' => get_addition_all_info1($personal_id));
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
}
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
/* General output */
$row[] = $aRow[$i];
}
$data['aaData'][] = $row;
}
break;
case 'get-info':
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
$fillter = $_REQUEST['fillter'];
$page = GetInfoPage($start_date, $end_date, $fillter);
$data = array('page' => $page);
break;
default:
echo "null";
}
$data['error'] = $error;
echo json_encode($data);
function GetInfoPage($start_date, $end_date, $fillter)
{
$res = mysql_query("SELECT\t ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.pay_type = 1 AND sale_transaction.`status` = 0\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.pay_type = 2 AND sale_transaction.`status` = 0\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT ROUND(SUM(sale_transaction.sum_cost), 2) AS `money`\n\t\t\t\t\t\t\tFROM sale_transaction\n\t\t\t\t\t\t\tWHERE sale_transaction.end_date >= '{$start_date}' AND sale_transaction.end_date <= '{$end_date}' AND sale_transaction.`status` = 0");
$sales = array();
while ($row = mysql_fetch_assoc($res)) {
$sales[] = $row['money'];
}
$res2 = mysql_query("SELECT SUM(pos_money_action.money) AS `custom_money`\n\t\t\t\t\t\t\tFROM pos_money_action\n\t\t\t\t\t\t\tWHERE\tpos_money_action.action = 1 AND pos_money_action.date >= '{$start_date}' AND pos_money_action.date <= '{$end_date}' \n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tUNION ALL\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSELECT SUM(pos_money_action.money) AS `custom_money`\n\t\t\t\t\t\t\tFROM pos_money_action\n\t\t\t\t\t\t\tWHERE pos_money_action.action = 2 AND pos_money_action.date >= '{$start_date}' AND pos_money_action.date <= '{$end_date}'");
