function fsAdd($idPage)
{
$access = new ToBase();
if (!$access->accessYes($idPage)) {
$toJS['login'] = false;
echo json_encode($toJS);
exit;
}
$toJS['login'] = true;
$date_now = date("Y-m-d H:i:s");
$data = json_decode($_REQUEST["data"]);
// принимаем POST-данные и декодируем их
$t_id = (int) $data->t_id;
//id операции
$sl_id = (int) $data->sl_id;
//id секции
$a_id = (int) $data->a_id;
//id ордера
$m_id = (int) $data->m_id;
//id модели
$w_id = (int) $data->w_id;
// id работника
$week = (int) $data->week;
$month = (int) $data->month;
$year = (int) $data->year;
$countDid = (int) $data->countDid;
//сколько выполненно выбранной операции
$query = "SELECT `dayStop` FROM `ns_filters` WHERE `f_id`=1";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$dayStop = $row["dayStop"];
if (0 == $t_id || 0 == $sl_id || 0 == $a_id || 0 == $m_id || 0 == $w_id || 0 == $week || 0 == $month || 0 == $year || 0 == $countDid) {
$toJS['dayStop'] = $dayStop;
$toJS["status"] = 0;
echo json_encode($toJS);
exit;
}
/**
* проверка на количесвто добавленных операций
* написать запрос где считается все countDid для sl_id,m_id,o_id
**/
$query = "SELECT `o_id` FROM `ns_admin` WHERE `a_id`='{$a_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$o_id = $row["o_id"];
//$o_id=$a_id;
$query = "SELECT `count` FROM `ns_counts` WHERE `a_id`='{$a_id}' AND `m_id`='{$m_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$count = $row["count"];
$query = "SELECT SUM(countDid) AS sumCountDid FROM `ns_results` WHERE `o_id`='{$o_id}' AND `t_id`='{$t_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$sumCountDid = $row["sumCountDid"];
if ($count < $sumCountDid) {
$toJS['addYes'] = "No";
exit;
} else {
$toJS['addYes'] = "Yes";
}
//$toJS['addYes']=$count<$row["sumCountDid"];
$cMonth = date("n");
//$toJS["cMonth"]=$cMonth;
$cYear = date("Y");
$cDay = date("j");
if (!($cMonth == $month && $year == $cYear || $cMonth == 1 && $month == 12 && $year < $cYear && $dayStop > $cDay || $cMonth > 1 && $month <= $cMonth && $month >= $cMonth - 1 && $year <= $cYear && $dayStop > $cDay)) {
$toJS['test'] = "(({$cMonth}={$month} && {$year}=={$cYear} && {$dayStop}>{$cDay}) || \n\t\t({$cMonth}==1 && {$month}==12 && {$year}<{$cYear} && {$dayStop}>{$cDay}) ||\n\t\t({$cMonth}>1 && {$month}<={$cMonth} && {$month}>={$cMonth}-1 && {$year}<={$cYear} && {$dayStop}>{$cDay}))";
$toJS['dayStop'] = false;
$toJS["status"] = 0;
echo json_encode($toJS);
exit;
} else {
$toJS['dayStop'] = true;
//надо найти t_id - идентификатор по $serial и $newSection
// $query="SELECT o_id FROM ns_admin WHERE a_id='$a_id'";
// $result=$access->resQuery($query);
// $row=mysql_fetch_array($result,MYSQL_ASSOC);
// $o_id=$row['o_id'];
$query = "SELECT `ml_id` FROM `ns_models` WHERE `m_id`='{$m_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$ml_id = $row['ml_id'];
$query = "SELECT `mName` FROM `ns_model_list` WHERE `ml_id`='{$ml_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$model_name = $row['mName'];
$query = "SELECT `lSection` FROM `ns_section_list` WHERE `sl_id`='{$sl_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$section_name = $row['lSection'];
$query = "SELECT `descript`,`time`,`serial` FROM `ns_techmap` WHERE `t_id`='{$t_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$operate = $row['descript'];
$time = $row['time'];
$serial = $row['serial'];
$query = "SELECT `family`,`name`,`payment` FROM `ns_workers` WHERE `w_id`='{$w_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$payment = $row['payment'];
$family = $row['family'];
$name = $row['name'];
$query = "SELECT `order` FROM `ns_orders` WHERE `o_id`='{$o_id}'";
$result = $access->resQuery($query);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$order = $row['order'];
$arg = compact("t_id", "a_id", "o_id", "fa_id", "family", "name", "order", "m_id", "ml_id", "model_name", "sl_id", "section_name", "w_id", "serial", "payment", "descript", "time", "date_now", "week", "month", "year", "countDid");
//print_r($arg);
$res = new Result($access->getConnDB());
if ($res->getAdd($arg)) {
$toJS["status"] = 1;
} else {
$toJS["status"] = 0;
}
// $query="INSERT INTO `ns_results`(`t_id`, `a_id`,`o_id`, `m_id`, `ml_id`,`model_name`, `sl_id`,`section_name`, `w_id`,`payment`, `date`, `week`, `month`, `year`, `countDid`)
// VALUES ('$t_id','$a_id','$o_id','$m_id','$ml_id','$model_name',$sl_id','$section_name`,$w_id','$payment',$date_now','$week','$month','$year','$data->countDid')";
// //$toJS["query="]=$query;
// $result=$access->resQuery($query);
//$result=mysql_query($query)or die("Запрос не выполнен".mysql_error());
echo json_encode($toJS);
}
}
echo "<br>Будем подключаться";
$access = new ToBase();
echo "Подключились к ToBase";
// $sql="SELECT `mName` FROM `ns_model_list` WHERE `ml_id`=88";
// $res=mysql_query($sql,$access->getConnDB());
// while($row=mysql_fetch_array($res,MYSQL_ASSOC)){
// echo "<br>".$row['mName'];
// }
$year = 2015;
$month = 8;
$week = 34;
$order = '11';
$model = "Модель H258-1;";
$sl_id = 54;
$serial = 2;
$r = new Result($access->getConnDB());
echo "<br>создали Result";
$data = $r->checkOrder($value);
echo "<br>получили дату";
print_r($data);
foreach ($data["List"] as $key => $value) {
echo "<br>";
print_r($value);
// echo "<br>$key";
// echo " $value['family']";
// $value['serial'] $value['count']";
}
//print_r($data);
// $models[0]='Модель H258-1;';
// $models[1]='Модель H258-2;';
// $sl_id=56;
set_include_path('Classes/');
spl_autoload($className);
//replaces include/require
}
spl_autoload_extensions('.php');
spl_autoload_register('autoload');
include_once 'Classes/ToBase.php';
$base = new ToBase();
if (!$base->accessYes('L4')) {
$data["login"] = false;
exit;
}
include_once 'Classes/Techmap.php';
include_once 'Classes/ModelsList.php';
include_once 'Classes/SectionsList.php';
$tm = new Techmap($base->getConnDB());
//echo "<br>Загружаем файл";
if (!function_exists('mb_ucfirst')) {
function mb_ucfirst($str, $enc = 'utf-8')
{
return mb_strtoupper(mb_substr($str, 0, 1, $enc), $enc) . mb_substr($str, 1, mb_strlen($str, $enc), $enc);
}
}
//echo "<br>Загружаем файл";
function sumNotes($value)
{
$value = preg_replace('/,/', '.', $value);
$res = explode('*', $value);
if (!($res[0] == '' || $res[1] == '')) {
$multip = $res[0] * $res[1];
} else {
