Changeset 975
- Timestamp:
- 08/26/08 07:57:29 (3 months ago)
- Files:
-
- trunk/admin/Public/call-comp.php (modified) (17 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/admin/Public/call-comp.php
r777 r975 5 5 6 6 7 if (! has_rights (ACX_CALL_REPORT)) {7 if (! has_rights (ACX_CALL_REPORT)) { 8 8 Header ("HTTP/1.0 401 Unauthorized"); 9 9 Header ("Location: PP_error.php?c=accessdenied"); … … 15 15 16 16 17 if (!isset ($current_page) || ($current_page == "")) {18 19 17 if (!isset ($current_page) || ($current_page == "")) { 18 $current_page=0; 19 } 20 20 21 21 // this variable specifie the debug type (0 => nothing, 1 => sql result, 2 => boucle checking, 3 other value checking) … … 29 29 // THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE 30 30 $FG_TABLE_HEAD_COLOR = "#D1D9E7"; 31 32 33 31 $FG_TABLE_EXTERN_COLOR = "#7F99CC"; //#CC0033 (Rouge) 34 32 $FG_TABLE_INTERN_COLOR = "#EDF3FF"; //#FFEAFF (Rose) 35 36 37 38 39 33 // THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE 40 34 $FG_TABLE_ALTERNATE_ROW_COLOR[] = "#FFFFFF"; … … 42 36 43 37 44 45 //$link = DbConnect();46 38 $DBHandle = DbConnect(); 47 48 // The variable Var_col would define the col that we want show in your table49 // First Name of the column in the html page, second name of the field50 39 $FG_TABLE_COL = array(); 51 52 53 40 54 41 /******* … … 57 44 58 45 $FG_TABLE_COL[]=array (gettext("Calldate"), "starttime", "15%", "center", "SORT", "19", "", "", "", "", "", "display_dateformat"); 59 //$FG_TABLE_COL[]=array ("Callend", "stoptime", "15%", "center", "SORT", "19");60 61 62 //$FG_TABLE_COL[]=array ("Source", "source", "20%", "center", "SORT", "30");63 64 46 $FG_TABLE_COL[]=array (gettext("CalledNumber"), "calledstation", "15%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 65 47 $FG_TABLE_COL[]=array (gettext("Destination"), "destination", "15%", "center", "SORT", "30", "", "", "", "", "", "remove_prefix"); 66 //$FG_TABLE_COL[]=array ("Country", "calledcountry", "10%", "center", "SORT", "30", "lie", "country", "countryname", "countrycode='%id'", "%1");67 //$FG_TABLE_COL[]=array ("Site", "site_id", "7%", "center", "sort", "15", "lie", "site", "name", "id='%id'", "%1");68 69 48 $FG_TABLE_COL[]=array (gettext("Duration"), "sessiontime", "7%", "center", "SORT", "30", "", "", "", "", "", "display_minute"); 70 71 49 $FG_TABLE_COL[]=array (gettext("CardUsed"), "username", "11%", "center", "SORT", "", "30", "", "", "", "", "linktocustomer"); 72 50 $FG_TABLE_COL[]=array (gettext("terminatecause"), "terminatecause", "10%", "center", "SORT", "30"); 73 51 $FG_TABLE_COL[]=array (gettext("IAX/SIP"), "sipiax", "6%", "center", "SORT", "", "list", $yesno); 74 //$FG_TABLE_COL[]=array ("DestID", "destID", "12%", "center", "SORT", "30");75 76 //if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Con_charg", "connectcharge", "12%", "center", "SORT", "30");77 //if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Dis_charg", "disconnectcharge", "12%", "center", "SORT", "30");78 //if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Sec/mn", "secpermin", "12%", "center", "SORT", "30");79 80 81 //if ($_SESSION["is_admin"]==1) $FG_TABLE_COL[]=array ("Buycosts", "buycosts", "12%", "center", "SORT", "30");82 52 $FG_TABLE_COL[]=array (gettext("InitialRate"), "calledrate", "10%", "center", "SORT", "30", "", "", "", "", "", "display_2dec"); 83 53 $FG_TABLE_COL[]=array (gettext("Cost"), "sessionbill", "10%", "center", "SORT", "30", "", "", "", "", "", "display_2bill"); … … 85 55 86 56 87 // ??? cardID88 57 $FG_TABLE_DEFAULT_ORDER = "t1.starttime"; 89 58 $FG_TABLE_DEFAULT_SENS = "DESC"; 90 59 91 60 // This Variable store the argument for the SQL query 92 93 61 $FG_COL_QUERY='t1.starttime, t1.calledstation, t1.destination, t1.sessiontime, t1.username, t1.terminatecause, t1.sipiax, t1.calledrate, t1.sessionbill'; 94 // t1.stoptime,95 96 62 $FG_COL_QUERY_GRAPH='t1.starttime, t1.sessiontime, t1.sessionbill-t1.buycost as profit, t1.sessionbill, t1.buycost'; 97 98 63 99 64 // The variable LIMITE_DISPLAY define the limit of record to display by page … … 117 82 118 83 119 120 121 84 if ($FG_DEBUG == 3) echo "<br>Table : $FG_TABLE_NAME - Col_query : $FG_COL_QUERY"; 122 85 $instance_table = new Table($FG_TABLE_NAME, $FG_COL_QUERY); … … 124 87 125 88 126 if ( is_null ($order) || is_null($sens) ){89 if ( is_null ($order) || is_null($sens)) { 127 90 $order = $FG_TABLE_DEFAULT_ORDER; 128 91 $sens = $FG_TABLE_DEFAULT_SENS; … … 130 93 131 94 132 if ($posted==1){ 133 $SQLcmd = ''; 134 $SQLcmd = do_field($SQLcmd, 'src', 'src'); 135 $SQLcmd = do_field($SQLcmd, 'dst', 'calledstation'); 136 137 if ($_POST['before']) { 138 if (strpos($SQLcmd, 'WHERE') > 0) { $SQLcmd = "$SQLcmd AND "; 139 }else{ $SQLcmd = "$SQLcmd WHERE "; } 140 $SQLcmd = "$SQLcmd starttime <'".$_POST['before']."'"; 141 } 142 if ($_POST['after']) { if (strpos($SQLcmd, 'WHERE') > 0) { $SQLcmd = "$SQLcmd AND "; 143 } else { $SQLcmd = "$SQLcmd WHERE "; } 144 $SQLcmd = "$SQLcmd starttime >'".$_POST['after']."'"; 145 } 146 147 148 } 149 150 //echo "SQLcmd:$SQLcmd<br>"; 95 if ($posted==1) { 96 $SQLcmd = ''; 97 $SQLcmd = do_field($SQLcmd, 'src', 'src'); 98 $SQLcmd = do_field($SQLcmd, 'dst', 'calledstation'); 99 100 if ($_POST['before']) { 101 if (strpos($SQLcmd, 'WHERE') > 0) { 102 $SQLcmd = "$SQLcmd AND "; 103 } else { 104 $SQLcmd = "$SQLcmd WHERE "; 105 } 106 $SQLcmd = "$SQLcmd starttime <'".$_POST['before']."'"; 107 } 108 if ($_POST['after']) { 109 if (strpos($SQLcmd, 'WHERE') > 0) { 110 $SQLcmd = "$SQLcmd AND "; 111 } else { 112 $SQLcmd = "$SQLcmd WHERE "; 113 } 114 $SQLcmd = "$SQLcmd starttime >'".$_POST['after']."'"; 115 } 116 } 151 117 152 118 $date_clause=''; 153 119 // Period (Month-Day) 154 155 156 if (!isset($fromstatsday_sday)){ 120 if (!isset($fromstatsday_sday)) { 157 121 $fromstatsday_sday = date("d"); 158 122 $fromstatsmonth_sday = date("Y-m"); 159 123 } 160 124 161 162 if (!isset($days_compare)){ 163 $days_compare=2; 164 } 165 166 167 168 //if (isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) $date_clause.=" AND calldate <= '$fromstatsmonth_sday-$fromstatsday_sday+23' AND calldate >= SUBDATE('$fromstatsmonth_sday-$fromstatsday_sday',INTERVAL $days_compare DAY)"; 169 170 if (DB_TYPE == "postgres"){ 171 if (isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) $date_clause.=" AND t1.starttime < date'$fromstatsmonth_sday-$fromstatsday_sday'+ INTERVAL '1 DAY' AND t1.starttime >= date'$fromstatsmonth_sday-$fromstatsday_sday' - INTERVAL '$days_compare DAY'"; 172 }else{ 173 if (isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) $date_clause.=" AND t1.starttime < ADDDATE('$fromstatsmonth_sday-$fromstatsday_sday',INTERVAL 1 DAY) AND t1.starttime >= SUBDATE('$fromstatsmonth_sday-$fromstatsday_sday',INTERVAL $days_compare DAY)"; 125 if (!isset($days_compare)) $days_compare=2; 126 127 128 129 if (DB_TYPE == "postgres") { 130 if (isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) 131 $date_clause.=" AND t1.starttime < date'$fromstatsmonth_sday-$fromstatsday_sday'+ INTERVAL '1 DAY' AND t1.starttime >= date'$fromstatsmonth_sday-$fromstatsday_sday' - INTERVAL '$days_compare DAY'"; 132 } else { 133 if (isset($fromstatsday_sday) && isset($fromstatsmonth_sday)) 134 $date_clause.=" AND t1.starttime < ADDDATE('$fromstatsmonth_sday-$fromstatsday_sday',INTERVAL 1 DAY) AND t1.starttime >= SUBDATE('$fromstatsmonth_sday-$fromstatsday_sday',INTERVAL $days_compare DAY)"; 174 135 } 175 136 … … 177 138 178 139 179 if (isset($customer) && ($customer>0)) {140 if (isset($customer) && ($customer>0)) { 180 141 if (strlen($SQLcmd)>0) $SQLcmd.=" AND "; 181 142 else $SQLcmd.=" WHERE "; 182 143 $SQLcmd.=" username='$customer' "; 183 } else{144 } else { 184 145 if (isset($entercustomer) && ($entercustomer>0)){ 185 146 if (strlen($SQLcmd)>0) $SQLcmd.=" AND "; … … 188 149 } 189 150 } 190 if ($_SESSION["is_admin"] == 1) 191 {151 152 if ($_SESSION["is_admin"] == 1) { 192 153 if (isset($enterprovider) && $enterprovider > 0) { 193 154 if (strlen($SQLcmd) > 0) $SQLcmd .= " AND "; else $SQLcmd .= " WHERE "; … … 208 169 } 209 170 210 //print $SQLcmd; 171 211 172 if (strpos($SQLcmd, 'WHERE') > 0) { 212 173 $FG_TABLE_CLAUSE = substr($SQLcmd,6).$date_clause; 213 } elseif (strpos($date_clause, 'AND') > 0){174 } elseif (strpos($date_clause, 'AND') > 0) { 214 175 $FG_TABLE_CLAUSE = substr($date_clause,5); 215 176 } … … 223 184 224 185 if ($FG_DEBUG == 3) echo "<br>Clause : $FG_TABLE_CLAUSE"; 225 //$nb_record = $instance_table -> Table_count ($FG_TABLE_CLAUSE);226 186 $nb_record = count($list_total); 227 187 if ($FG_DEBUG >= 1) var_dump ($list); … … 229 189 230 190 231 if ($nb_record<=$FG_LIMITE_DISPLAY) {191 if ($nb_record<=$FG_LIMITE_DISPLAY) { 232 192 $nb_record_max=1; 233 } else{193 } else { 234 194 $nb_record_max=(intval($nb_record/$FG_LIMITE_DISPLAY)+1); 235 195 } … … 239 199 240 200 241 /*************************************************************/242 243 244 $instance_table_customer = new Table("cc_card", "id, username, lastname");245 246 $FG_TABLE_CLAUSE = "";247 /*if ($_SESSION["is_admin"]==0){248 $FG_TABLE_CLAUSE =" IDmanager='".$_SESSION["pr_reseller_ID"]."'";249 }*/250 251 $list_customer = $instance_table_customer -> Get_list ($DBHandle, $FG_TABLE_CLAUSE, "id", "ASC", null, null, null, null);252 253 $nb_customer = count($list_customer);254 255 ?>256 257 <?php258 201 $smarty->display('main.tpl'); 202 259 203 ?> 260 204 … … 580 524 <IMG SRC="graph_stat.php?min_call=<?php echo $min_call?>&fromstatsday_sday=<?php echo $fromstatsday_sday?>&days_compare=<?php echo $days_compare?>&fromstatsmonth_sday=<?php echo $fromstatsmonth_sday?>&dsttype=<?php echo $dsttype?>&srctype=<?php echo $srctype?>&clidtype=<?php echo $clidtype?>&channel=<?php echo $channel?>&resulttype=<?php echo $resulttype?>&dst=<?php echo $dst?>&src=<?php echo $src?>&clid=<?php echo $clid?>&userfieldtype=<?php echo $userfieldtype?>&userfield=<?php echo $userfield?>&accountcodetype=<?php echo $accountcodetype?>&accountcode=<?php echo $accountcode?>&customer=<?php echo $customer?>&entercustomer=<?php echo $entercustomer?>&entertariffgroup=<?php echo $entertariffgroup?>&enterprovider=<?php echo $enterprovider?>&entertrunk=<?php echo $entertrunk?>&enterratecard=<?php echo $enterratecard?>" ALT="Stat Graph"> 581 525 582 <?php } else{ ?>526 <?php } else { ?> 583 527 <center><h3><?php echo gettext("No calls in your selection");?>.</h3></center> 584 528 <?php } ?> … … 587 531 588 532 <br><br> 533 589 534 <?php 590 535 $smarty->display('footer.tpl');
