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 {