9 $monLibrary= dirname(__FILE__) .
"/../library";
10 $sharedLibrary= dirname(__FILE__) .
"/../../shared/library";
11 require_once(
"$monLibrary/cu_top.i");
12 require_once(
"$monLibrary/ck_hticket.i");
13 require_once(
"$sharedLibrary/cu_flagconst.i");
16 if (!CheckPerm($link, $Hu, basename($_SERVER[
'SCRIPT_NAME']), $_SERVER[
'REMOTE_ADDR'])) {
19 header(
"Location: /hcuadm/hcu_noperm.prg");
23 $dms_ok=array(
'txtSearch' =>
'array',
'selSearch'=>
'array',
'selSearch'=>
'array',
'txtSort'=>
'digits',
'nbrPrevWks'=>
'array');
27 $txtSort = isset($txtSort) ? $txtSort :
'';
33 $COL_FROM_CELL_PHONE = 2;
37 $COL_RESPONSE_ERROR = 6;
40 $COL_MAIN_ACCT_SMS = 9;
41 $COL_MAIN_ACCT_NBR = 10;
42 $COL_MAIN_ACCT_SFX = 11;
43 $COL_2ND_ACCT_SMS = 12;
44 $COL_2ND_ACCT_NBR = 13;
45 $COL_2ND_ACCT_SFX = 14;
49 $COL_CHK_NBR_SEARCH = 18;
52 $COL_CELL_PROVIDER = 21;
64 $LOGFILE =
"cellalert.log";
65 $LOGFILEDIR =
"/var/log/smslog/";
79 if (isset($_POST[
'selSearch'])) {
87 $LoadPrevWeekFileNumber = 0;
88 $EOFonLastFileToLoad =
false;
92 while (!$EOFonLastFileToLoad) {
95 while ($LoadNextFile) {
96 if ($LoadPrevWeekFileNumber <= intval($_POST[
'nbrPrevWks'])) {
98 $FileNameToLoad = $LOGFILEDIR . $LOGFILE . ($LoadPrevWeekFileNumber > 0 ?
".{$LoadPrevWeekFileNumber}" :
"");
99 if (is_readable($FileNameToLoad)) {
101 $log_hndl = fopen($FileNameToLoad,
"r");
102 $LoadNextFile =
false;
106 $EOFonLastFileToLoad =
true;
107 $LoadNextFile =
false;
109 $LoadPrevWeekFileNumber++;
112 if (!$EOFonLastFileToLoad) {
114 $temp_list = Array();
116 $log_input = fgets($log_hndl, 4096);
122 $temp_list = explode(
"','", $log_input);
124 $temp_list[$COL_DATE] = substr($temp_list[$COL_DATE], 1);
126 $temp_list[$COL_SORT_DATE] = substr($temp_list[$COL_DATE], 6, 4) .
127 substr($temp_list[$COL_DATE], 0, 2) .
128 substr($temp_list[$COL_DATE], 3, 2) .
129 substr($temp_list[$COL_DATE], 10);
132 if ($log_input !=
"") {
135 (isset($_POST[
'selSearch'][0]) && $_POST[
'selSearch'][0] !=
'')
136 || (isset($_POST[
'selSearch'][1]) && $_POST[
'selSearch'][1] !=
'')
137 || (isset($_POST[
'selSearch'][2]) && $_POST[
'selSearch'][2] !=
'')
141 $txt_match = Array(
true,
true,
true);
144 for ($SearchIDX = 0; $SearchIDX <=2; $SearchIDX++) {
145 if (isset($_POST[
'selSearch'][$SearchIDX]) && $_POST[
'selSearch'][$SearchIDX] !=
'') {
147 if (trim($_POST[
'txtSearch'][$SearchIDX]) ==
"") {
148 $txt_match[$SearchIDX] =
false;
151 $txt_match[$SearchIDX] = ($_POST[
'selSearch'][$SearchIDX] ==
'' || strpos(strtolower($temp_list[intval($_POST[
'selSearch'][$SearchIDX])]), strtolower($_POST[
'txtSearch'][$SearchIDX])) !== False);
156 if ( $txt_match[0] && $txt_match[1] && $txt_match[2]) {
158 $log_list[] = $temp_list;
162 $log_list[] = $temp_list;
168 if (feof($log_hndl)) {
173 if ($LoadPrevWeekFileNumber <= intval($_POST[
'nbrPrevWks'])) {
174 $LoadNextFile =
true;
176 $LoadNextFile =
true;
177 $EOFonLoadFileToLoad =
true;
185 if (isset($log_hndl)) {
191 if (isset($txtSort) && $txtSort !=
'') {
192 $col_sort = intval($txtSort);
204 $log_list = shellSort($log_list, $col_sort);
206 cu_header(
'View SMS Activity');
210 if (isset($selSearch)) {
211 if (HCU_array_key_value(0, $selSearch) !=
'') {
212 $preFill[
'sel'][0][intval($selSearch[0])] =
"SELECTED";
213 $preFill[
'txt'][0] = $txtSearch[0];
215 if (HCU_array_key_value(1, $selSearch) !=
'') {
216 $preFill[
'sel'][1][intval($selSearch[1])] =
"SELECTED";
217 $preFill[
'txt'][1] = $txtSearch[1];
219 if (HCU_array_key_value(2, $selSearch) !=
'') {
220 $preFill[
'sel'][2][intval($selSearch[2])] =
"SELECTED";
221 $preFill[
'txt'][2] = $txtSearch[2];
223 $preFill[
'PrevWks'][intval($_POST[
'nbrPrevWks'])] =
"SELECTED";
227 <form name=
'cellview' action=
'{$_SERVER['PHP_SELF
']}' method=
'post'>
228 <table
class=
'' border=0 width=800 cellpadding=0 cellspacing=0>
231 <DIV CLASS=
'empty'><br></DIV>
233 <td CLASS=
'matcenter'>
234 <DIV CLASS=
'bartitle'>View SMS Activity</DIV>
237 <DIV CLASS=
'empty'><br></DIV>
242 <DIV CLASS=
'empty'><br></DIV>
244 <td
class=
'matcenter'>
245 <table width=
'100%' border=0 cellspacing=0 cellpadding=1>
247 <td valign=
'top' class=
'dtl' colspan=
'7'>
248 This report will help you view the contents of the SMS log file.<br>
249 You may query the log file based on the parameters below.<br>
254 <td valign=
'top' class=
'dtl' colspan=
'1'>
257 <td
class=
'dtl' colspan=
'3'>
260 <select name='selSearch[]'> 261 <option value=''>No Search</option> 262 <option value='0' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(0, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][0] :
'') .
">Date</option> 263 <option value='1' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(1, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][1] :
'') .
">CU Code</option> 264 <option value='7' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(7, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][7] :
'') .
">Member</option> 265 <option value='2' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(2, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][2] :
'') .
">Cell Phone</option> 266 <option value='17' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(17, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][17] :
'') .
">Trans Code</option> 267 <option value='4' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(4, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][4] :
'') .
">Request</option> 268 <option value='5' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(5, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][5] :
'') .
">Response</option> 269 <option value='6' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(0, $preFill[
'sel']) && HCU_array_key_value(6, $preFill[
'sel'][0]) ? $preFill[
'sel'][0][6] :
'') .
">Response Error</option> 272 <input type='text' name='txtSearch[]' value='". (HCU_array_key_value(
'txt', $preFill) ? (HCU_array_key_value(0, $preFill[
'txt']) ? $preFill[
'txt'][0] :
'') :
'') .
"' maxlength=30 size=20> 276 <select name='selSearch[]'> 277 <option value=''>No Search</option> 278 <option value='0' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(0, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][0] :
'') .
">Date</option> 279 <option value='1' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(1, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][1] :
'') .
">CU Code</option> 280 <option value='7' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(7, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][7] :
'') .
">Member</option> 281 <option value='2' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(2, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][2] :
'') .
">Cell Phone</option> 282 <option value='17' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(17, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][17] :
'') .
">Trans Code</option> 283 <option value='4' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(4, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][4] :
'') .
">Request</option> 284 <option value='5' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(5, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][5] :
'') .
">Response</option> 285 <option value='6' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(1, $preFill[
'sel']) && HCU_array_key_value(6, $preFill[
'sel'][1]) ? $preFill[
'sel'][1][6] :
'') .
">Response Error</option> 288 <input type='text' name='txtSearch[]' value='". (HCU_array_key_value(
'txt', $preFill) ? (HCU_array_key_value(1, $preFill[
'txt']) ? $preFill[
'txt'][1] :
'') :
'') .
"' maxlength=30 size=20> 292 <select name='selSearch[]'> 293 <option value=''>No Search</option> 294 <option value='0' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(0, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][0] :
'') .
">Date</option> 295 <option value='1' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(1, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][1] :
'') .
">CU Code</option> 296 <option value='7' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(7, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][7] :
'') .
">Member</option> 297 <option value='2' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(2, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][2] :
'') .
">Cell Phone</option> 298 <option value='17' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(17, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][17] :
'') .
">Trans Code</option> 299 <option value='4' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(4, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][4] :
'') .
">Request</option> 300 <option value='5' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(5, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][5] :
'') .
">Response</option> 301 <option value='6' ". (HCU_array_key_value(
'sel', $preFill) && HCU_array_key_value(2, $preFill[
'sel']) && HCU_array_key_value(6, $preFill[
'sel'][2]) ? $preFill[
'sel'][2][6] :
'') .
">Response Error</option> 304 <input type='text' name='txtSearch[]' value='". (HCU_array_key_value(
'txt', $preFill) ? (HCU_array_key_value(2, $preFill[
'txt']) ? $preFill[
'txt'][2] :
'') :
'') .
"' maxlength=30 size=20> 307 <td valign='bottom' class='dtl' colspan='3'> 312 <td valign='' class='dtlr' colspan='2'> 315 <td class='dtl' colspan='2'> 316 <select name=\"nbrPrevWks\"> 317 <option value='0' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(0, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][0] :
'') :
'') .
">Current Week</option> 318 <option value='1' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(1, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][1] :
'') :
'') .
">Current +1 Previous Week</option> 319 <option value='2' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(2, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][2] :
'') :
'') .
">Current +2 Previous Weeks</option 320 <option value='3' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(3, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][3] :
'') :
'') .
">Current +3 Previous Weeks</option> 321 <option value='4' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(4, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][4] :
'') :
'') .
">Current +4 Previous Weeks</option> 322 <option value='5' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(5, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][5] :
'') :
'') .
">Current +5 Previous Weeks</option> 323 <option value='6' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(6, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][6] :
'') :
'') .
">Current +6 Previous Weeks</option> 324 <option value='7' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(7, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][7] :
'') :
'') .
">Current +7 Previous Weeks</option> 325 <option value='8' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(8, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][8] :
'') :
'') .
"Current +8 Previous Weeks</option> 326 <option value='9' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(9, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][9] :
'') :
'') .
">Current +9 Previous Weeks</option> 327 <option value='10' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(10, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][10] :
'') :
'') .
">Current +10 Previous Weeks</option> 328 <option value='11' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(11, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][11] :
'') :
'') .
">Current +11 Previous Weeks</option> 329 <option value='12' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(12, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][12] :
'') :
'') .
">Current +12 Previous Weeks</option> 330 <option value='13' ". (HCU_array_key_value(
'PrevWks', $preFill) ? (HCU_array_key_value(13, $preFill[
'PrevWks']) ? $preFill[
'PrevWks'][13] :
'') :
'') .
">Current +13 Previous Weeks</option> 333 <td valign='bottom' class='dtl' colspan='3'> 334 <input type='submit' name='btnSearch' value='Search'> 338 <td class='hdr' valign='top'><a href='javascript:sort_order(\"26\");'>Date</a></td> 339 <td class='hdr' valign='top'><nobr><a href='javascript:sort_order(\"1\");'>CU Code</a></nobr></td> 340 <td class='hdr' valign='top'><a href='javascript:sort_order(\"7\");'>Member</a></td> 341 <td class='hdr' valign='top'><a href='javascript:sort_order(\"2\");'>Cell Phone</a></td> 342 <td class='hdr' valign='top'><a href='javascript:sort_order(\"17\");'>Trans Code</a></td> 343 <td class='hdr' valign='top'><a href='javascript:sort_order(\"4\");'>Request</a></td> 344 <td class='hdr' valign='top'><a href='javascript:sort_order(\"5\");'>Response</a></td> 345 <td class='hdr' valign='top'><nobr><a href='javascript:sort_order(\"6\");'>Response Error</a></nobr></td> 351 foreach ($log_list as $list_row) {
354 $odd_even = ($odd_even ==
"odd_small" ?
"even_small" :
"odd_small");
355 array_walk($list_row,
'apply_htmlspecialchars');
357 <tr
class=
'$odd_even'>
358 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_DATE]}</td>
359 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_CUCODE]}</td>
360 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_MEMBER_NBR]}</td>
361 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_FROM_CELL_PHONE]}</td>
362 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_TRANS_CODE]}</td>
363 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_CELL_CMD]}</td>
364 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_RESPONSE]}</td>
365 <td
class=
'$odd_even' valign=
'top'>{$list_row[$COL_RESPONSE_ERROR]}</td>
376 <TD CLASS='matright'><DIV CLASS='empty'><br></DIV></td> 380 <DIV CLASS='empty'><br></DIV> 382 <td CLASS='matcenter'> 383 <DIV CLASS='empty'><br></DIV> 386 <DIV CLASS='empty'><br></DIV> 391 <input type='hidden' name='txtSort' value='{$txtSort}'> 392 <input type='hidden' name='SubmitSort' value=''> 393 <script language='javascript'> 395 function sort_order (col_order) { 396 document.cellview.txtSort.value = col_order; 397 // document.cellview.SubmitSort.value = '1'; 398 document.cellview.submit(); 407 function shellSort($array, $col_sort) {
408 if (!$length = count($array)) {
412 $gap[0] = (int)($length/2);
415 $gap[$k] = (int)($gap[$k-1]/2);
418 for ($i = 0; $i <= $k; $i++) {
420 for ($j = $step; $j < $length; $j++) {
423 while ($p >= 0 && strcasecmp($temp[$col_sort], $array[$p][$col_sort]) < 0) {
424 $array[$p + $step] = $array[$p];
427 $array[$p + $step] = $temp;
433 function apply_htmlspecialchars(&$itemValue, $itemKey) {
434 $itemValue = htmlspecialchars($itemValue);