$token = isset($_REQUEST['token']) ? $_REQUEST['token'] : ''; $value = isset($_REQUEST['value']) ? $_REQUEST['value'] : ''; $start = microtime(true); CONNECT_DB(); mysql_query("SET NAMES utf8"); $data = array('status' => 500, 'content' => 'Can not connect to db!'); $sql = 'SELECT `id_pwc`, `name_pwc` FROM `power_company` WHERE 1'; $result = mysql_query($sql) or die(json_encode($data)); $pclist = array(); while ($row = mysql_fetch_array($result)) { $tmp = array('id_pwc' => $row['id_pwc'], 'name_pwc' => $row['name_pwc']); array_push($pclist, $tmp); } $adata = array(); foreach ($pclist as $key => $value) { $tmp = getallsub($value['id_pwc']); $tmpp = array(); array_push($tmpp, $value); array_push($tmpp, $tmp); array_push($adata, $tmpp); } $object = $adata; $getmoresubinfo = getmoresubinfo(); $getallinvestor = getallinvestor(); function getallsub($ipc) { $data = array('status' => 500, 'content' => 'Can not connect to db!'); $sql = 'SELECT `id_sub`, `name_sub` FROM `substation_power` WHERE `id_pwc`=' . $ipc; $result = mysql_query($sql) or die(json_encode($data));
*/ $sql = 'SELECT `flag_change` FROM `user` WHERE `token` = "' . $token . '" AND `ID` = ' . $id; $result = mysql_query($sql) or die('0'); $rs = 0; while ($row = mysql_fetch_array($result)) { $rs = $row['flag_change']; } if ($rs == 1) { include 'menuleftupdate.php'; } /* * Check update menu */ $object = getmenuleft($token, $id); $allpc = getalltpc(); $allsub = getallsub(); $allins = getallinvestor(); function getmenuleft($token, $id) { $return = ''; $sql = 'SELECT `cacheall` FROM `user` WHERE `token` = "' . $token . '" AND `ID` = ' . $id; $result = mysql_query($sql) or die('0'); if (mysql_num_rows($result)) { $rows = mysql_num_rows($result); if ($rows == 1) { while ($rsl = mysql_fetch_array($result)) { $val = $rsl['cacheall']; } $return = $val; } else { $return = '';