| Tipo evento |
Data evento |
Descrizione evento |
Controllo NOC |
*/
$DATA_AR = array();
mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD);
mysql_select_db($LDB_DB_NAME);
$Q = mysql_query("SELECT * FROM bb_noc_assistance WHERE id_customer = '".$_GET['idc']."' ORDER BY id DESC;");
$RC = mysql_num_rows($Q);
while ($DATA = mysql_fetch_assoc($Q)) {
switch ($DATA['ticket_status']) {
case "0":
$ICON = '';
$STS = 'Aperto';
$F_COLOR = '#5CB85C';
$BTNT = '';
$CloseData = '...';
$Q1 = mysql_query("SELECT * FROM bb_noc_groups WHERE id = '".$DATA['id_noc_group']."';");
while ($DATA1 = mysql_fetch_assoc($Q1)) {
$REP = ''.$DATA1['group_name'].'';
}
$EventData = strtotime($DATA['ticket_data']);
$EventData = ''.date('d/m/Y', $EventData).'';
$TITLET = ''.$DATA['ticket_title'].'';
$Q2 = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$DATA['id']."' ORDER BY id DESC LIMIT 1;");
while ($DATA2 = mysql_fetch_assoc($Q2)) {
$LASTMSGB = ''.substr($DATA2['message'],0,35).'...';
}
break;
case "1":
$ICON = '';
$STS = 'Aperto';
$F_COLOR = '#5CB85C';
$BTNT = '';
$CloseData = '...';
$Q1 = mysql_query("SELECT * FROM bb_noc_groups WHERE id = '".$DATA['id_noc_group']."';");
while ($DATA1 = mysql_fetch_assoc($Q1)) {
$REP = ''.$DATA1['group_name'].'';
}
$EventData = strtotime($DATA['ticket_data']);
$EventData = ''.date('d/m/Y', $EventData).'';
$TITLET = ''.$DATA['ticket_title'].'';
$Q2 = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$DATA['id']."' ORDER BY id DESC LIMIT 1;");
while ($DATA2 = mysql_fetch_assoc($Q2)) {
$LASTMSGB = ''.substr($DATA2['message'],0,35).'...';
}
break;
case "2":
$ICON = '';
$STS = 'Chiuso';
$F_COLOR = 'gray';
$BTNT = '';
$CloseData = strtotime($DATA['ticket_last_update']);
$CloseData = date('d/m/Y H:i:s', $CloseData);
$Q1 = mysql_query("SELECT * FROM bb_noc_groups WHERE id = '".$DATA['id_noc_group']."';");
while ($DATA1 = mysql_fetch_assoc($Q1)) {
$REP = $DATA1['group_name'];
}
$EventData = strtotime($DATA['ticket_data']);
$EventData = date('d/m/Y', $EventData);
$TITLET = $DATA['ticket_title'];
$Q2 = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$DATA['id']."' ORDER BY id DESC LIMIT 1;");
while ($DATA2 = mysql_fetch_assoc($Q2)) {
$LASTMSGB = substr($DATA2['message'],0,35).'...';
}
break;
default:
$ICON = '';
$STS = 'N.D.';
$BTNT = '';
$Q1 = mysql_query("SELECT * FROM bb_noc_groups WHERE id = '".$DATA['id_noc_group']."';");
while ($DATA1 = mysql_fetch_assoc($Q1)) {
$REP = $DATA1['group_name'];
}
$EventData = strtotime($DATA['ticket_data']);
$EventData = date('d/m/Y', $EventData);
$F_COLOR = '#5BC0DE';
$TITLET = $DATA['ticket_title'];
$Q2 = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$DATA['id']."' ORDER BY id DESC LIMIT 1;");
while ($DATA2 = mysql_fetch_assoc($Q2)) {
$LASTMSGB = substr($DATA2['message'],0,35).'...';
}
}
$DATA_AR[] = array($ICON, ''.$REP.'', ''.$EventData.'', ''.$CloseData.'', ''.$TITLET.'', ''.$LASTMSGB.'', $STS, $BTNT);
}
mysql_close();
$RESPONSE_ARRAY = array('data' => $DATA_AR);
print json_encode($RESPONSE_ARRAY);
/* $DATA_AR[0] = array("Ciao", "sono", "antonio", "martino", "1");
$DATA_AR[1] = array("Io", "sono", "antonio", "martino", "1");
*/
?>