$res = NetworkBoxType_SELECT('', '', $config['LinesPerPage'], ($page - 1) * $config['LinesPerPage']); $pages = genPages('NetworkBoxType.php?', ceil($res['allPages'] / $config['LinesPerPage']), $page); $rows = $res['rows']; $i = -1; $boxType_arr = array(); while (++$i < $res['count']) { $boxType_arr[] = $rows[$i]['id']; $boxType_arr[] = '<a href="NetworkBoxType.php?mode=charac&boxtypeid=' . $rows[$i]['id'] . '">' . $rows[$i]['marking'] . '</a>'; $boxType_arr[] = $rows[$i]['manufacturer']; $boxType_arr[] = $rows[$i]['units']; $boxType_arr[] = $rows[$i]['width']; $boxType_arr[] = $rows[$i]['height']; $boxType_arr[] = $rows[$i]['length']; $boxType_arr[] = $rows[$i]['diameter']; $wr['NetworkBoxType'] = $rows[$i]['id']; $res2 = NetworkBox_SELECT('', $wr); if ($res2['count'] > 0) { $boxType_arr[] = '<a href="NetworkBox.php?boxtypeid=' . $rows[$i]['id'] . '">' . $res2['count'] . '</a>'; } else { $boxType_arr[] = $res2['count']; } $boxType_arr[] = '<a href="NetworkBoxType.php?mode=change&boxtypeid=' . $rows[$i]['id'] . '">Изменить</a>'; if ($res2['count'] == 0) { $boxType_arr[] = '<a href="NetworkBoxType.php?mode=delete&boxtypeid=' . $rows[$i]['id'] . '">Удалить</a>'; } else { $boxType_arr[] = ''; } } $smarty->assign("data", $boxType_arr); $smarty->assign("pages", $pages); $smarty->assign("mode", '');
function getNetworkBoxInfo($networkBoxId) { $wr['id'] = $networkBoxId; $res = NetworkBox_SELECT(0, $wr); $result['NetworkBox'] = $res; unset($wr); $wr['id'] = $res['rows'][0]['NetworkBoxType']; $res2 = NetworkBoxType_SELECT('', $wr); $result['NetworkBox']['rows'][0]['NetworkBoxType'] = $res2['rows'][0]; unset($wr); $wr['NetworkBox'] = $networkBoxId; $res3 = NetworkNode_SELECT('', '', $wr); $result['NetworkBox']['rows'][0]['NetworkNode'] = $res3['rows'][0]; return $result; }