Location: PHPKode > projects > WorkOrder TS > workorder-ts/include/pro/ticket_admin_overview.php
<?PHP if( $sql=="NO COMMAND" ) { $debug=1;if( isset($_GET['SSID']) ) { $SSID=mysql_real_escape_string($_GET['SSID']);} if( isset($_POST['SSID']) ) { $_jotlC=mysql_real_escape_string($_POST['SSID']);} if( empty($SSID)==TRUE AND empty($_jotlC)==FALSE ) { $SSID=$_jotlC;} require_once $inc_dir."workorder_function_getusersettings.inc.php";$aUserSettings=_L00RE($SSID,$inc_dir,$CONF);$CONF=_OFB10($inc_dir);$_IlLfj=_L00RE($SSID,$inc_dir,$CONF);$_jjJCf=$CONF["DefaultValuesStoreName".$_IlLfj[1]."Date"];$_jj6oj=$CONF["DefaultValuesStoreName".$_IlLfj[1]."TimeZone"];$_jjf66=$CONF["DefaultValuesStoreName".$_IlLfj[1]."TimeZoneSign"];$_jjfOj=$CONF["DefaultValuesStoreName".$_IlLfj[1]."DayLightSavings"];$_jt1l8=_OF18E("$_jjf66","$_jj6oj","$_jjfOj","$_jjJCf");$disp_overview_table="<div id=\"border\">&nbsp;&nbsp;Store Overview for {$CONF["StoreName$Store_id"]} on $_jt1l8";$disp_overview_table.='<p style="text-align:center;">';$_joojj=False;$sql="select * from ".$CONF['TableNameMenus']." WHERE `serv_menu_isdone` != 1 AND `menu_group_id` = 1";$_joo6f=mysql_query($sql,$conn) or die("Can't get Menus from DB<br>$sql<br>, Error: 67e53gd");  while( $_jooo6 = mysql_fetch_array($_joo6f) ) {   $sql = "SELECT COUNT(ID) as total FROM {$CONF['TableNameTicket']} WHERE `Store_id` = $Store_id AND `Status_id` = {$_jooo6['ID']}";   $_joC6l = mysql_query($sql, $conn);   $row_cnt= mysql_fetch_array($_joC6l);   if( $row_cnt['total'] > 0 ) {    $_joojj = True;    $disp_overview_table .= "Status {$_jooo6['selection_name']} has {$row_cnt['total']} Tickets <br />";   }  }  if( $_joojj == False ) { $disp_overview_table .= 'No Open Tickets Found'; }  $sql = 'NO COMMAND';  unset($_joo6f);  unset($_jooo6);  unset($_joC6l);  unset($row_cnt);  $disp_overview_table .= '</p></div>';  }  ?>
Return current item: WorkOrder TS