<?php
/* ******************************
* WSDL aJax actions
* ******************************
*/
set_time_limit(0);
include '../../includes/classes/core.php';
include '../../includes/classes/wsdl.class.php';
include '../../includes/classes/logger.class.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$properties = GetCompanyProperties();
$wsdl = new wsdl('http://services.rs.ge/WayBillService/WayBillService.asmx?WSDL', 'mplus:406137014', '123456');
$_log = Logger::instance('../../log/wsdl/wsdl/', Logger::OFF);
switch ($action) {
case 'sync':
$array = array("create_date_s" => $_REQUEST['create_date_s'], "create_date_e" => $_REQUEST['create_date_e'], "waybill_number" => $_REQUEST['waybill_number'], "seller_tin" => $_REQUEST['seller_tin']);
$array = array_diff($array, array(''));
if (empty($array)) {
$error = 'შეავსეთ სინქრონიზაციისათვის აუცილებელი ველი(ები)!';
} else {
$params = arrayToObject($array);
$arr = $wsdl->get_buyer_waybills($params);
for ($i = 0; $i < count($arr); $i++) {
$wsdl->set_waybill_id($arr[$i]);
$wsdl->get_waybill(1);
}
$arr = $wsdl->get_waybills($params);
for ($i = 0; $i < count($arr); $i++) {
function AddReserve($overhead_id, $object)
{
$req = mysql_query("SELECT \t`OD`.`id` AS detail_id,\n\t\t\t\t\t\t\t\t\t`OD`.`goods_id` AS production_id,\n\t\t\t\t\t\t\t\t\t`OD`.`quantity`,\n\t\t\t\t\t\t\t\t\t`OD`.`price`,\n\t\t\t\t\t\t\t\t\t`O`.`activate_date`\n\t\t\t\t\t\tFROM \t\t`overhead_detail` AS `OD` \n\t\t\t\t\t\tLEFT JOIN \t`overhead` AS `O` ON `OD`.`overhead_id` = `O`.id\n\t\t\t\t\t\tWHERE \t\t`OD`.`overhead_id` = {$overhead_id}");
while ($res = mysql_fetch_assoc($req)) {
$c_data = date('Y-m-d H:i:s');
$user_id = $_COOKIE['USERID'];
$detail_id = $res['detail_id'];
$price = $res['price'];
$quantity = $res['quantity'];
$production_id = $res['production_id'];
$vat = 0;
$prop = GetCompanyProperties();
$pay = mysql_fetch_assoc(mysql_query("SELECT \t`partners`.`vat_payer` as `vat`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM \t\t`overhead`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN \t`partners` ON `overhead`.`seller_tin` = `partners`.`rs_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE \t\t`overhead`.`id` = {$overhead_id}"));
//vat calculation
if ($pay['vat'] == 1 && $prop['payer'] == 1) {
$vat = $price - $price / 1.18;
$price = $price / 1.18;
}
//get current price and quantity
$prod = mysql_query("SELECT\t\t`price`,\n\t\t\t\t\t\t\t\t\t\tSUM(quantity - sold) AS `quantity`\n\t\t\t\t\t\t\tFROM\t\t`reserve`\n\t\t\t\t\t\t\tWHERE\t\t`production_id` = {$production_id}\n\t\t\t\t\t\t\tGROUP BY \t`production_id`");
//calculate result self price
$res_info = mysql_fetch_assoc($prod);
$result_price = ($res_info[price] * $res_info[quantity] + $price * $quantity) / ($res_info[quantity] + $quantity);
//insert production in reserve
mysql_query("INSERT INTO `reserve`\n\t\t\t\t\t\t(user_id, `object_id`, `overhead_id`, `production_id`, `quantity`, `price`, `real_price`, `vat`, `create_date`)\n\t\t\t\t\t VALUES\n\t\t\t\t\t\t({$user_id}, {$object}, {$overhead_id}, {$production_id}, {$res['quantity']}, {$price}, {$res['price']}, {$vat}, '{$res['confirmation_date']}')");
//if production already exist set self price and save in history
if (mysql_num_rows($prod) != 0) {
mysql_query("UPDATE `reserve`\n\t\t\t\t\t\tSET\t\t`price` = {$result_price}\n\t\t\t\t\t\tWHERE\t`production_id` = {$production_id}");
//insert in history
mysql_query("INSERT INTO self_cost_history\n\t\t\t\t\t\t\t(user_id, date, overhead_id, overhead_detail_id, production_id, current_quantity, current_cost, income_quantity, income_cost, result_quantity, result_cost)\n\t\t\t\t\t\t VALUES\n\t\t\t\t\t\t\t({$user_id}, '{$c_data}', {$overhead_id}, {$detail_id}, {$production_id}, {$res_info['quantity']}, {$res_info['price']}, {$res['quantity']}, {$price}, {$res_info['quantity']} + {$res['quantity']}, {$result_price})");
} else {
//insert in history first time
mysql_query("INSERT INTO self_cost_history\n\t\t\t\t\t\t\t(user_id, date, overhead_id, overhead_detail_id, production_id, current_quantity, current_cost, income_quantity, income_cost, result_quantity, result_cost)\n\t\t\t\t\t\t VALUES\n\t\t\t\t\t\t\t({$user_id}, '{$c_data}', {$overhead_id}, {$detail_id}, {$production_id}, 0, 0, {$res['quantity']}, {$price}, {$res['quantity']}, {$price})");
}
}
}
function GetRelationsSection($res = '', $type, $stream)
{
$prop = GetCompanyProperties();
if ($stream == 0) {
$data = '
<fieldset>
<legend>გამყიდველი (გამგზავნი)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 200px;"><label for="seller_i_number">საიდენტ. ნომერი</label></td>
<td style="width: 300px;"><label for="seller_name">დასახელება / სახელი, გვარი</label></td>
<td style="width: 350px;"><label for="seller_addree">ტრანსპორტირების დაწყების ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<input type="text" id="seller_i_number" class="idle" disabled="disabled" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $prop['tin'] . '" />
</td>
<td>
<input type="text" id="seller_name" class="idle address" disabled="disabled" onblur="this.className=\'idle address\'" onfocus="this.className=\'activeField address\'" value="' . $prop['name'] . '" />
</td>
<td>
<input type="text" id="seller_addree" class="idle large" disabled="disabled" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $prop['address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
} else {
$data = '
<fieldset>
<legend>გამყიდველი (გამგზავნი)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 200px;"><label for="seller_i_number">საიდენტ. ნომერი</label></td>
<td style="width: 300px;"><label for="seller_name">დასახელება / სახელი, გვარი</label></td>
<td style="width: 350px;"><label for="seller_addree">ტრანსპორტირების დაწყების ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<input type="text" id="seller_i_number" class="idle" disabled="disabled" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['seller_tin'] . '" />
</td>
<td>
<input type="text" id="seller_name" class="idle address" disabled="disabled" onblur="this.className=\'idle address\'" onfocus="this.className=\'activeField address\'" value="' . $res['seller_name'] . '" />
</td>
<td>
<input type="text" id="seller_addree" class="idle large" disabled="disabled" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $res['start_address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
}
if ($type != 1 && $type != 4) {
//1 is Domestic Traffic, 4 is Distribution
$data .= '
<fieldset>
<legend>მყიდველი (მიმღები)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 200px;"><label for="buyer_i_number">საიდენტ. ნომერი</label></td>
<td style="width: 300px;"><label for="buyer_name">დასახელება / სახელი, გვარი</label></td>
<td style="width: 350px;"><label for="buyer_addree">ტრანსპორტირების დაწყების ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<input type="text" id="buyer_i_number" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['buyer_tin'] . '" />
</td>
<td>
<div class="seoy-row" id="buyer_name_seoy">
<input type="text" id="buyer_name" class="idle seoy-address" onblur="this.className=\'idle seoy-address\'" onfocus="this.className=\'activeField seoy-address\'" value="' . $res['buyer_name'] . '" />
<button id="buyer_name_btn" class="combobox">buyer_name</button>
</div>
</td>
<td>
<input type="text" id="buyer_addree" class="idle large" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $res['end_address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
}
return $data;
}
function GetRelationsSection($res = '', $type, $stream)
{
if ($type == 3) {
$disable = "display: none;";
}
$prop = GetCompanyProperties();
if ($stream == 0) {
$data = '
<fieldset>
<legend>გამყიდველი (გამგზავნი)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 480px;"><label for="seller_i_number">საიდენტ. ნომერი</label></td>
<td style="width: 300px;"><label for="seller_name">დასახელება / სახელი, გვარი</label></td>
<td style="width: 350px;"><label for="seller_addree">ტრანსპორტირების დაწყების ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<input type="text" id="seller_i_number" class="idle" disabled="disabled" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $prop['tin'] . '" />
</td>
<td>
<input type="text" id="seller_name" class="idle address" disabled="disabled" onblur="this.className=\'idle address\'" onfocus="this.className=\'activeField address\'" value="' . $prop['name'] . '" />
</td>
<td>
<input type="text" id="seller_addree" class="idle large" disabled="disabled" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $prop['address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
} else {
$data = '
<fieldset>
<legend>გამყიდველი (გამგზავნი)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 200px;"><label for="seller_i_number">საიდენტ. ნომერი</label></td>
<td style="width: 300px;"><label for="seller_name">დასახელება / სახელი, გვარი</label></td>
<td style="width: 350px;"><label for="seller_addree">ტრანსპორტირების დაწყების ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<input type="text" id="seller_i_number" class="idle" disabled="disabled" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['seller_tin'] . '" />
</td>
<td>
<input type="text" id="seller_name" class="idle address" disabled="disabled" onblur="this.className=\'idle address\'" onfocus="this.className=\'activeField address\'" value="' . $res['seller_name'] . '" />
</td>
<td>
<input type="text" id="seller_addree" class="idle large" disabled="disabled" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $res['start_address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
}
if ($type != 1 && $type != 4) {
//1 is Domestic Traffic, 4 is Distribution
$data .= '
<fieldset>
<legend>მყიდველი (მიმღები)</legend>
<table width="95%" class="dialog-form-table">
<tr>
<td style="width: 200px;"><label for="buyer_i_number">საიდენტ. ნომერი(დასახელება / სახელი, გვარი)</label></td>
<td style="width: 300px; ' . $disable . '"><label for="buyer_addree">ტრანსპორტირების დასრულები ადგილი (მისამართი)</label></td>
</tr>
<tr>
<td>
<select data-adress="" style="width:400px !important" id="buyer_i_number">' . GetBuyer_opt($res['buyer_tin']) . ' </select>
</td>
<td style="' . $disable . '">
<input type="text" id="buyer_addree" class="idle large" onblur="this.className=\'idle large\'" onfocus="this.className=\'activeField large\'" value="' . $res['end_address'] . '" />
</td>
</tr>
</table>
</fieldset>
';
}
return $data;
}
