$c_date = date('Y-m-d H:i:s');
$person_id = $_REQUEST['pe'];
checkDEscribeExists($user_id, $describe_id, $object_id, $c_date, $person_id);
Done($describe_id, $user_id, $object_id, $c_date);
break;
case 'check_prod_list':
$describe_id = $_REQUEST['id'];
$check = CheckProdList($describe_id);
if ($check) {
$error = 'პროდუქციის სია ცარიელია!';
}
break;
case 'get_production_quantity':
$production_name = $_REQUEST['pn'];
$object_id = $_REQUEST['ob'];
$data = array('quantity' => GetQuantity($production_name, $object_id));
break;
case 'get_local_id':
$local_id = GetLocalID();
$data = array('local_id' => $local_id);
break;
case 'clear_db':
ClearDB();
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
* Transfer Functions
}
function GetQuantity($start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT IFNULL(SUM(sale_transaction_detail.product_quantity),0) AS `sum`\r\n\t\t\t\t\t\t\t\t\t\t\t FROM sale_transaction\r\n\t\t\t\t\t\t\t\t\t\t\t JOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\t\t\t\t\t\t\t\t\t WHERE DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.status=0"));
return $result['sum'];
}
function GetProductSum($name, $start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT \t\tROUND(SUM(sale_transaction_detail.product_quantity*sale_transaction_detail.cost),2) AS `sum`\r\n\t\t\tFROM sale_transaction\r\n\t\t\tJOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\tJOIN production ON production.id = sale_transaction_detail.production_id\r\n\t\t\tJOIN production_category ON production.pos_menu_category = production_category.id\r\n\t\t\tWHERE production_category.`name` = '{$name}' AND production_category.`name` IS NOT NULL AND DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.`status` =0"));
return $result['sum'];
}
function GetProductQuantity($name, $start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT SUM(sale_transaction_detail.product_quantity) AS `sum`\r\n\t\t\tFROM sale_transaction\r\n\t\t\tJOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\tJOIN production ON production.id = sale_transaction_detail.production_id\r\n\t\t\tJOIN production_category ON production.pos_menu_category = production_category.id\r\n\t\t\tWHERE production_category.`name` = '{$name}' AND production_category.`name` IS NOT NULL AND DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.`status` =0"));
return $result['sum'];
}
switch ($action) {
case 'get_category_sum':
$data = array('page' => array(GetSum($start, $end), GetQuantity($start, $end)));
break;
case 'get_products_sum':
$sum = GetProductSum($name, $start, $end);
$qnt = GetProductQuantity($name, $start, $end);
$data = array('page' => array($sum, $qnt));
break;
default:
echo "Action is null!";
break;
}
$data['error'] = $error;
echo json_encode($data);
