$pos_menu_category = $_REQUEST['cat'];
$unit = $_REQUEST['un'];
$image = $_REQUEST['img'];
$rec_id = $_REQUEST['rec_id'];
/*if(CheckRecipieExist($id)){
AddRecipie($id, $user_id, $code, $name, $pos_menu_category, $unit, $image);
} else {
SaveRecipie($id, $user_id, $code, $name, $pos_menu_category, $unit);
}
*/
if ($rec_id == '') {
if (!CheckRecipieExist($name)) {
if (!CheckRecipieCode($code)) {
AddRecipie($id, $user_id, $code, $name, $pos_menu_category, $unit, $image);
global $log;
$log->setInsertLog('production');
} else {
$error = 'პროდუქტი ასეთი კოდით უკვე არის სიაში!';
}
} else {
$error = '"' . $name . '" უკვე არის სიაში!';
}
} else {
SaveRecipie($id, $user_id, $code, $name, $pos_menu_category, $unit, $image);
}
break;
case 'disable':
$rec_id = $_REQUEST['id'];
DeleteRecipie($rec_id);
break;
case 'check_prod_list':
if (empty($persons_id)) {
if ($CheckUser) {
AddWorker($user_id, $name, $tin, $position, $address, $image, $password, $home_number, $mobile_number, $comment, $user, $userpassword, $group_permission);
} else {
$error = "მომხმარებელი ასეთი სახელით უკვე არსებობს\nაირჩიეთ სხვა მომხმარებლის სახელი";
}
} else {
SaveWorker($persons_id, $user_id, $name, $tin, $position, $address, $image, $password, $home_number, $mobile_number, $comment, $user, $userpassword, $group_permission);
}
break;
case 'save_group':
$group_name = $_REQUEST['nam'];
$group_pages = json_decode(stripslashes($_REQUEST['pag']));
$data = array('inserted_value' => SaveGroup($group_name, $group_pages), 'inserted_name' => $group_name);
global $log;
$log->setInsertLog('group');
break;
case 'get_add_group_page':
$page = GetGroupPage();
$data = array('page' => $page);
break;
case 'disable':
$per_id = $_REQUEST['id'];
DisableWorker($per_id);
break;
case 'delete_image':
$pers_id = $_REQUEST['id'];
DeleteImage($pers_id);
break;
case 'clear':
$file_list = $_REQUEST['file'];
$data1 = '';
while ($increm_row = mysql_fetch_assoc($increm)) {
$data1 .= '<tr style="border-bottom: 1px solid #85b1de;">
<td style="width:110px; display:block;word-wrap:break-word;">' . $increm_row[name] . '</td>
<td ><button type="button" value="media/uploads/file/' . $increm_row[rand_name] . '" style="cursor:pointer; border:none; margin-top:25%; display:block; height:16px; width:16px; background:none;background-image:url(\'media/images/get.png\');" id="download" ></button><input type="text" style="display:none;" id="download_name" value="' . $increm_row[rand_name] . '"> </td>
<td ><button type="button" value="' . $increm_row[id] . '" style="cursor:pointer; border:none; margin-top:25%; display:block; height:16px; width:16px; background:none; background-image:url(\'media/images/x.png\');" id="delete"></button></td>
</tr>';
}
$data = array('page' => $data1);
break;
case 'up_now':
$user = $_SESSION['USERID'];
if ($rand_file != '') {
mysql_query("INSERT INTO \t`file`\n\t\t\t\t\t\t\t\t\t( \t`user_id`,\n\t\t\t\t\t\t\t\t\t\t`task_id`,\n\t\t\t\t\t\t\t\t\t\t`name`,\n\t\t\t\t\t\t\t\t\t\t`rand_name`\n\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t\t\t(\t'{$user}',\n\t\t\t\t\t\t\t\t\t\t'{$edit_id}',\n\t\t\t\t\t\t\t\t\t\t'{$file}',\n\t\t\t\t\t\t\t\t\t\t'{$rand_file}'\n\t\t\t\t\t\t\t\t\t);");
global $log;
$log->setInsertLog('file');
}
$increm = mysql_query("\tSELECT `name`,\n\t\t\t\t\t\t\t\t\t\t`rand_name`,\n\t\t\t\t\t\t\t\t\t\t`id`\n\t\t\t\t\t\t\t\tFROM \t`file`\n\t\t\t\t\t\t\t\tWHERE `task_id` = {$edit_id}\n\t\t\t\t\t\t\t ");
$data1 = '';
while ($increm_row = mysql_fetch_assoc($increm)) {
$data1 .= '<tr style="border-bottom: 1px solid #85b1de;">
<td style="width:110px; display:block;word-wrap:break-word;">' . $increm_row[name] . '</td>
<td ><button type="button" value="media/uploads/file/' . $increm_row[rand_name] . '" style="cursor:pointer; border:none; margin-top:25%; display:block; height:16px; width:16px; background:none;background-image:url(\'media/images/get.png\');" id="download" ></button><input type="text" style="display:none;" id="download_name" value="' . $increm_row[rand_name] . '"> </td>
<td ><button type="button" value="' . $increm_row[id] . '" style="cursor:pointer; border:none; margin-top:25%; display:block; height:16px; width:16px; background:none; background-image:url(\'media/images/x.png\');" id="delete"></button></td>
</tr>';
}
$data = array('page' => $data1);
break;
case 'sub_category':
$cat_id = $_REQUEST['cat_id'];
$data = array('cat' => Getcategory1($cat_id));
$data = array('self_price' => $self_price, 'last_price' => $last_price);
break;
case 'save_prod':
$price_id = $_REQUEST['id'];
$prod_name = $_REQUEST['n'];
$sp_price = $_REQUEST['sp'];
$sb_price = $_REQUEST['sb'];
if (empty($sb_price)) {
$sb_price = 0;
}
$prod_id = GetProductID($prod_name);
if ($prod_name != '' && $price_id == '') {
if (!CheckProductExist($prod_id)) {
AddProduct($user_id, $prod_id, $sp_price, $sb_price);
global $log;
$log->setInsertLog('pricelist');
} else {
$error = $prod_name . ' უკვე არის სიაში!';
}
} else {
SaveProduct($user_id, $price_id, $prod_id, $sp_price, $sb_price);
}
break;
case 'disable':
$prod_id = $_REQUEST['id'];
DisableProduct($prod_id);
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
break;
case 'save_prod':
$comp_id = $_REQUEST['id'];
$local_id = $_REQUEST['l_id'];
$amount = $_REQUEST['am'];
$quantity = $_REQUEST['qn'];
$price = $_REQUEST['pr'];
$ing_name = $_REQUEST['rn'];
$checked = $_REQUEST['ch'];
$user_id = $_COOKIE['USERID'];
$ingredient_id = GetProductID($ing_name);
if ($comp_id == '') {
if (!CheckProductionExist($local_id, $ingredient_id)) {
AddProduction($local_id, $user_id, $ingredient_id, $amount, $quantity, $price, $checked);
global $log;
$log->setInsertLog('recipie');
} else {
$error = ' უკვე არის სიაში!';
}
} else {
SaveProduction($comp_id, $user_id, $ingredient_id, $amount, $quantity, $price, $checked);
}
break;
case 'disable':
$ingr_id = $_REQUEST['id'];
DeleteProduction($ingr_id);
break;
default:
$error = 'Action is Null';
}
$data['error'] = $error;
$row[] = '<input type="checkbox" name="check_' . $aRow[$hidden] . '" class="check" value="' . $aRow[$hidden] . '" />';
}
}
$data['aaData'][] = $row;
}
break;
case 'save_category':
$cat_id = $_REQUEST['id'];
$image = $_REQUEST['img'];
$checked = $_REQUEST['ch'];
$cat_name = htmlspecialchars($_REQUEST['cat'], ENT_QUOTES);
if ($cat_name != '' && $cat_id == '') {
if (!CheckCategoryExist($cat_name, $cat_id)) {
AddCategory($cat_name, $image, $checked);
global $log;
$log->setInsertLog('production_category');
} else {
$error = '"' . $cat_name . '" უკვე არის სიაში!';
}
} else {
SaveCategory($cat_id, $cat_name, $image, $checked);
}
break;
case 'disable':
$cat_id = $_REQUEST['id'];
DisableCategory($cat_id);
break;
case 'delete_image':
$cat_id = $_REQUEST['id'];
DeleteImage($cat_id);
break;
}
$row['4'] = getContactT($row['0']);
$row['5'] = getContactN($row['0']);
$data['aaData'][] = $row;
}
break;
case 'save_part':
$part_id = $_REQUEST['id'];
$p_identity_id = $_REQUEST['pid'];
$arr = array('p_status' => $_REQUEST['ps'], 'p_name' => $_REQUEST['pn'], 'p_Iaddress' => $_REQUEST['pia'], 'p_Paddress' => $_REQUEST['ppa'], 'pay_method' => $_REQUEST['pm'], 'payer' => $_REQUEST['py'], 'p_data' => $_REQUEST['pd'], 'p_s_number' => $_REQUEST['psn']);
if ($p_identity_id != '' && $part_id == '') {
if (!CheckPartnerUserExist($p_identity_id)) {
$in_id = AddPartner($user_id, $p_identity_id, $arr);
$data = array('in_id' => $in_id);
global $log;
$log->setInsertLog('partners');
} else {
$error = '"' . p_identity_id . '" უკვე არის სიაში!';
}
} else {
SavePartner($user_id, $part_id, $p_identity_id, $arr);
}
break;
case 'get_local_id':
$local_id = GetLocalID();
$data = array('local_id' => $local_id);
break;
case 'disable':
$part_id = $_REQUEST['id'];
Disable($part_id);
break;
case 'save_object_id':
$c_person = $_REQUEST['c_person'];
$comp_id = $_REQUEST['id'];
$c_person = $_REQUEST['c_person'];
$phone = $_REQUEST['phone'];
$user_id = $_SESSION['USERID'];
global $log;
$log->setUpdateLogAfter('bank_object', $c_person);
if ($comp_id == '') {
$comp_id = $_REQUEST['bank_local_id'];
}
$trans_obj = $_REQUEST['trans_obj'];
$trans_address = $_REQUEST['trans_address'];
if ($c_person != '') {
mysql_query("\tUPDATE\t\t`bank_object`\r\n\t\t\t\t\t\t\tSET\t\t\t`user_id`\t\t= `{$user_id}`,\r\n\t\t\t\t\t\t\t\t\t\t`name`\t\t\t= '{$trans_obj}',\r\n\t\t\t\t\t\t\t\t\t\t`address`\t\t= '{$trans_address}'\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t`id` \t\t\t= {$c_person}");
$log->setInsertLog('bank_object', $c_person);
} else {
mysql_query("\tINSERT INTO bank_object\r\n\t\t\t\t\t\t\t\t\t(`user_id`,bank_id, `name`, address )\r\n\t\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t\t\t\t('{$user_id}',{$comp_id},'{$trans_obj}', '{$trans_address}')\t");
$data = array('myid' => mysql_insert_id());
global $log;
$log->setInsertLog('bank_object');
}
break;
case 'get_edit_page':
$local_id = $_REQUEST['local_id'];
$c_person = $_REQUEST['id'];
$page = GetPage(Getbankobject($c_person, $local_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
}
$output['aaData'][] = $row;
}
break;
case 'save_object':
//
$object_id = $_REQUEST['id'];
$name = $_REQUEST['na'];
$type = $_REQUEST['t'];
$parent = $_REQUEST['p'];
$address = $_REQUEST['a'];
$warehouse = $_REQUEST['w'];
if ($object_id == '') {
AddObject($user_id, $name, $type, $parent, $address, $warehouse);
global $log;
$log->setInsertLog('object');
} else {
SaveObject($user_id, $object_id, $name, $type, $parent, $address, $warehouse);
}
break;
case 'disable':
$object_id = $_REQUEST['id'];
Disable($object_id);
break;
default:
$error = 'Action is Null';
}
$output['error'] = $error;
echo json_encode($output);
function GetObb($object_id)
{