$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']);
