$kntid = GetDef('kntid'); $sql = "SELECT * FROM knt WHERE id = '{$kntid}' AND active = 1"; $result = $sqlcn->ExecuteSQL($sql) or die('Не могу выбрать список контрагентов!' . mysql_error()); $dogcount = 0; while ($row = mysqli_fetch_array($result)) { if ($row['dog'] == '1') { echo '<div class="alert alert-success">Контрагент:'; $nm = $row['name']; echo "{$nm}<br>"; $sql = "SELECT * FROM contract WHERE kntid = '{$kntid}' AND work = 1 AND datestart <= CURDATE() AND dateend >= CURDATE() AND active = 1"; $result2 = $sqlcn->ExecuteSQL($sql) or die('Не могу выбрать список договоров! ' . mysqli_error($sqlcn->idsqlconnection)); while ($row2 = mysqli_fetch_array($result2)) { $dogcount++; echo '<div class="well"><span class="label label-info">Активный договор:</span><br>'; $dt1 = MySQLDateToDate($row2['datestart']); $dt2 = MySQLDateToDate($row2['dateend']); $num = $row2['num']; $nm = $row2['name']; echo "Номер: {$num}, {$nm}</br>"; echo "Срок действия с {$dt1} по {$dt2}<br>"; echo "Файлы: "; $rid = $row2['id']; $sql = "SELECT * FROM files_contract WHERE idcontract = {$rid}"; $result3 = $sqlcn->ExecuteSQL($sql) or die('Не могу выбрать список файлов! ' . mysqli_error($sqlcn->idsqlconnection)); while ($row3 = mysqli_fetch_array($result3)) { $fn1 = $row3['filename']; $fn2 = $row3['userfreandlyfilename']; echo "<a target=\"_blank\" href=\"files/{$fn1}\">{$fn2}</a>; "; } echo '<br>'; echo '</div>';
ON rp2.kntid = knt.id {$where} ORDER BY {$sidx} {$sord} LIMIT {$start}, {$limit} TXT; $result = $sqlcn->ExecuteSQL($sql) or die('Не могу выбрать список контрагентов! ' . mysqli_error($sqlcn->idsqlconnection)); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; while ($row = mysqli_fetch_array($result)) { $dtz = $row['dt']; $responce->rows[$i]['id'] = $row['rpid']; $rstatus = $row['rstatus'] == '1' ? 'Ремонт' : 'Сделано'; $responce->rows[$i]['cell'] = array($row['rpid'], $row['namekont'], $row['namenome'], MySQLDateToDate($row['dt']), MySQLDateToDate($row['dtend']), $row['cost'], $row['comment'], $rstatus); $i++; } jsonExit($responce); } if ($step == 'edit') { if ($oper == 'edit') { $dt = DateToMySQLDateTime2(PostDef('dt') . ' 00:00:00'); $dtend = DateToMySQLDateTime2(PostDef('dtend') . ' 00:00:00'); $cost = PostDef('cost'); $comment = PostDef('comment'); $rstatus = PostDef('rstatus'); $sql = "UPDATE repair SET dt='{$dt}',dtend='{$dtend}',cost='{$cost}',comment='{$comment}',status='{$rstatus}' WHERE id='{$eqid}'"; $sqlcn->ExecuteSQL($sql) or die('Не смог обновить статус ремонта! ' . mysqli_error($sqlcn->idsqlconnection)); ReUpdateRepairEq(); exit;
$i = 0; while ($row = mysqli_fetch_array($result)) { $responce->rows[$i]['id'] = $row['eqid']; if ($row['eqactive'] == '1') { $active = '<img src="controller/client/themes/' . $cfg->theme . '/ico/accept.png">'; } else { $active = '<img src="controller/client/themes/' . $cfg->theme . '/ico/cancel.png">'; } if ($row['eqrepair'] == '1') { $active = $active . '<img src="controller/client/themes/' . $cfg->theme . '/ico/error.png">'; } $os = $row['os'] == 0 ? 'No' : 'Yes'; $eqmode = $row['eqmode'] == 0 ? 'No' : 'Yes'; $eqmapyet = $row['eqmapyet'] == 0 ? 'No' : 'Yes'; $dtpost = MySQLDateTimeToDateTime($row['datepost']); $dtendgar = MySQLDateToDate($row['dtendgar']); $row['tmcgo'] = $row['tmcgo'] == 0 ? 'No' : 'Yes'; $responce->rows[$i]['cell'] = array($active, $row['eqid'], $row['placesname'], $row['nomename'], $row['grnome'], $row['tmcgo'], $row['vname'], $row['buhname'], $row['sernum'], $row['invnum'], $row['shtrihkod'], $row['orgname'], $row['fio'], $dtpost, $row['cost'], $row['currentcost'], $os, $eqmode, $row['eqmapyet'], $row['eqcomment'], $row['eqrepair'], $dtendgar, $row['kntname']); $i++; } echo json_encode($responce); } if ($oper == 'edit') { $os = $os == 'Yes' ? 1 : 0; $tmcgo = $tmcgo == 'Yes' ? 1 : 0; $mode = $mode == 'Yes' ? 1 : 0; $mapyet = $mapyet == 'Yes' ? 1 : 0; $buhname = mysqli_real_escape_string($sqlcn->idsqlconnection, $buhname); $SQL = "UPDATE equipment SET buhname='{$buhname}',sernum='{$sernum}'," . " invnum='{$invnum}',shtrihkod='{$shtrihkod}',cost='{$cost}'," . " currentcost='{$currentcost}',os='{$os}',mode='{$mode}'," . " mapyet='{$mapyet}',comment='{$comment}',tmcgo='{$tmcgo}' WHERE id='{$id}'"; $sqlcn->ExecuteSQL($SQL) or die('Не смог обновить оргтехнику!' . mysqli_error($sqlcn->idsqlconnection)); }
INNER JOIN knt ON knt.id = repair.kntid {$where} ORDER BY {$sidx} {$sord} LIMIT {$start}, {$limit} TXT; $result = $sqlcn->ExecuteSQL($sql) or die('Не могу выбрать список ремонтов!' . mysqli_error($sqlcn->idsqlconnection)); $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; while ($row = mysqli_fetch_array($result)) { $responce->rows[$i]['id'] = $row['id']; $dt = MySQLDateToDate($row['dt']); $dtend = MySQLDateToDate($row['dtend']); if ($row['status'] == '1') { $st = 'В сервисе'; } if ($row['status'] == '0') { $st = "Работает"; } if ($row["status"] == '2') { $st = 'Есть заявка'; } if ($row['status'] == '3') { $st = 'Списать'; } $zz = new Tusers(); if ($row['userto'] != '-1') { $zz->GetById($row['userto']);