Exemple #1
0
 $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", '');
Exemple #2
0
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;
}