Online PHP editor | output for vfEOK

<? include( 'init.inc.php' ); if( !$_REQUEST["month"]) $_REQUEST["month"] = date("Y-m"); if( !$_REQUEST["date_f"]) $_REQUEST["date_f"] = date("Y-m-01"); if( !$_REQUEST["date_t"]) $_REQUEST["date_t"] = date("Y-m-d"); if( !$_REQUEST["show"]) $_REQUEST["show"] = 'active'; $cal = new cal($_REQUEST["month"]); //$cal->next(); if( $_REQUEST["next"] ) $cal->next(); if( $_REQUEST["prev"] ) $cal->prev(); ?> <form action="<?=SITE_URL.pathinfo(__FILE__,PATHINFO_BASENAME)?>" class="blockContent blockForm" method="get"> <? if($_REQUEST["order"]) {?><input type="hidden" name="order" value="<?=$_REQUEST["order"]?>" /><? }?> <? if($_REQUEST["order_type"]) {?><input type="hidden" name="order_type" value="<?=$_REQUEST["order_type"]?>" /><? }?>  <table width="100%" class="data sticky tablesorter" border="0" cellspacing="0" cellpadding="0"> <? if ($_REQUEST["order"]) { $order = 'ORDER by '.$_REQUEST["order"].' '.$_REQUEST["order_type"]; } else{ $order = "ORDER by income desc"; } $w = array(); if( $_REQUEST["office_ids"] ) $w['office_ids'] = "b.office_id IN (". join(',',$_REQUEST["office_ids"]) .")"; $w['type'] = "b.type IN ('broker', 'apprentice')"; if( $_REQUEST["show"]=='active' ) $w['status'] = "b.status='active'"; $query = stats::get_broker_stats_query($_REQUEST["date_f"], $_REQUEST["date_t"], $w) . $order; $office_q = stats::get_broker_stats_query_offices($_REQUEST["date_f"], $_REQUEST["date_t"], $w); $data = stats::get_broker_stats_query_offices_data($office_q); foreach($data['offices_involved'] as &$o) { $o = stats::get_data_on_office($o, $data['data']); } if(isset($o)) { unset($o); } _dbg( $query ); $out = db_query($query); $i = 0; unset($total); while( $row = db_object($out) ) { $broker = new broker( $row->broker_id ); $broker->loadOptions(); $broker->cache = true; if( $broker->data['mint_status'] == 'hide_on_stats' && !in_array($_REQUEST["show"], ['all', 'worked']) ) continue; unset($comm_proc); if( $row->pard_amount ) $comm_proc = 100 / $row->pard_amount * ($row->brokerComm + $row->pard_admAmount); unset($pastang_bal, $pinig_bal); //$worked_days = $d_dateIn->diff(new DateTime())->format('%a') + 1; $worked_days = $broker->get_work_time($_REQUEST["date_f"], $_REQUEST["date_t"])->days; if( $_REQUEST["show"] == 'worked' && $worked_days <= 0 ) continue; $bal_data = json_decode($broker->data['bal_data']); $mint_data = json_decode($broker->data['mint_data']); $worked_days_total = $broker->get_work_time()->days + 1; if( $_REQUEST["worked_f"] && $_REQUEST["worked_f"] > $worked_days_total / 30 ) continue; if( $_REQUEST["worked_t"] && $_REQUEST["worked_t"] < $worked_days_total / 30 ) continue; //$bendr_bal_3month = $fin_data->pastang_bal + $fin_data->pinig_bal; $color = ''; $bgColor = ''; if( $broker->data['mint_status'] == 'bandom_laik' ) { $bgColor = '#CCC'; }elseif($broker->data['mint_status'] == 'hide_on_stats'){ $bgColor = '#FFD1D1'; } if( round($broker->data['bal'], 1) < 5 ) $color = 'cRed'; if( round($broker->data['bal'], 1) >= 5 ) $color = 'cGreen'; if( !$broker->data['bal_f'] || date('Y-m-d') < $broker->data['bal_f'] ) $color = 'cBlue'; if( $broker->get_naujok_period()->is_naujok ) { $color = 'cBlue'; $bgColor = ''; } if( $broker->data['skip_bal_color'] || $broker->data['status'] != 'active' ) { unset($color, $bgColor); $color = 'cBlack'; } $total["calls"] += $row->calls; $total["meets"] += $row->meets; $total["new_clients"] += $row->new_clients; $total["a_calls"] += $row->a_calls; $total["a_meets"] += $row->a_meets; $total["contracts"] += $row->contracts; $total["object_reviews"] += $row->object_reviews; $total["income"] += $row->income; $total["ct_done"] += $row->ct_done; $total["comm"] += $row->comm; $i++; ?> <tr style="background-color:<?=$bgColor?>"> <td align="right"><?=$i?>.</td> <td><a class="<?=$color?>" href="?doAction=chBroker&broker_id=<?=$broker->data['id']?>#account?cat=plan"><?=$broker->getName()?></a></td> <td><?=(int)$row->new_clients?></td> <td><?=(int)$row->calls?> <? if($row->app_calls) {?>(<? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a href="#calls?broker_id=<?=(int)$broker->data["id"]?>&date_f=<?=$_REQUEST["date_f"]?>&date_t=<?=$_REQUEST["date_t"]?>&duration_f=1&client=1" target="_blank"><?=$row->app_calls?></a><? }else{?><?=$row->app_calls?><? }?>)<? }?></td> <td><? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a onclick="cal.open('<?=$_REQUEST["date_f"]?>',{dateTo:'<?=$_REQUEST["date_t"]?>',type:'call',status:'active',broker_id:<?=(int)$broker->data["id"]?>});" class="cRed"><?=(int)$row->a_calls?></a><? }else{?><?=(int)$row->a_calls?><? }?></td> <td><?=(int)$row->meets?></td> <td><? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a onclick="cal.open('<?=$_REQUEST["date_f"]?>',{dateTo:'<?=$_REQUEST["date_t"]?>',type:'meet',status:'active',broker_id:<?=(int)$broker->data["id"]?>});" class="cRed"><?=(int)$row->a_meets?></a><? }else{?><?=(int)$row->a_meets?><? }?></td> <td><? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a href="#contracts?broker_id=<?=(int)$broker->data["id"]?>&office_id=<?=(int)$broker->data["office_id"]?>&dateBegin_f=<?=$_REQUEST["date_f"]?>&dateBegin_t=<?=$_REQUEST["date_t"]?>" target="_blank" _onclick="stats.activityDialog({date:'<?=$_REQUEST["date_f"]?>',dateTo:'<?=$_REQUEST["date_t"]?>',status:'pasirasyta_sutartis',broker_id:<?=(int)$broker->data["id"]?>,office_id:<?=(int)$broker->data["office_id"]?>});"><?=(int)$row->contracts?></a><? }else{?><?=(int)$row->contracts?><? }?></td> <td><?=(int)$row->object_reviews?> (<?=(int)$row->orw_calls?>)</td> <td><?=(int)$row->ct_done?></td> <td><?=_number_format($row->comm)?></td> <td><?=_number_format($comm_proc, 1)?>%</td> <td><? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?> <a href="#contracts?uzd=1&uzd_broker_id=<?=$broker->data['id']?>&uzd_date_f=<?=$_REQUEST["date_f"]?>&uzd_date_t=<?=$_REQUEST["date_t"]?>&search=1" target="_blank"><?=_number_format($row->income)?></a><? }else{?><?=_number_format($row->income)?><? }?></td> <td><?=_number_format($broker->data['pastang_bal'],1)?> <div style="display:none"> Sutartys <?=_number_format($bal_data->contracts,1)?> bal. Prezentacijos <?=_number_format($bal_data->meets,1)?> bal. Skambučiai <?=_number_format($bal_data->calls,1)?> bal. Nauji kontaktai <?=_number_format($bal_data->new_clients,1)?> bal. Apž. aktai <?=_number_format($bal_data->object_reviews,1)?> bal. Viso <?=_number_format($bal_data->total,1)?> bal. </div> </td> <td><?=_number_format($broker->data['pinig_bal'], 1)?></td> <td align="center">"><?=_number_format($broker->data['bal'], 1)?> <div style="display:none"> Esamas laikotarpis: "><?=_number_format($broker->data['bal'], 1)?> <? if( $broker->data['bal_f'] && $broker->data['bal_t'] ) {?> <?=date('Y.m.d', strtotime($broker->data['bal_f']))?> - <?=date('Y.m.d', strtotime($broker->data['bal_t']))?> - pastangų: <?=_number_format($broker->data['pastang_bal'], 1)?> <?=date('Y.m.d', strtotime($broker->data['pinig_f']))?> - <?=date('Y.m.d', strtotime($broker->data['bal_t']))?> - pinigų: <?=_number_format($broker->data['pinig_bal'], 1)?> <? }?> <? if( $broker->data['mint_f'] < $broker->data['mint_t'] ) {?> Buvęs laikotarpis: data['mint_bal'], 1) >= 5?'cGreen':'cRed'?>"><?=_number_format($broker->data['mint_bal'], 1)?> <?=date('Y.m.d', strtotime($broker->data['mint_f']))?> - <?=date('Y.m.d', strtotime($broker->data['mint_t']))?> - pastangų: <?=_number_format($mint_data->pastang_bal, 1)?> <?=date('Y.m.d', strtotime($broker->data['mint_pinig_f']))?> - <?=date('Y.m.d', strtotime($broker->data['mint_t']))?> - pinigų: <?=_number_format($mint_data->pinig_bal, 1)?> <? }?> <? if( $broker->data['mint_status'] && !$broker->data['skip_bal_color'] ) {?> Balo statusas: get_naujok_period()->is_naujok?'cBlue':'cRed'?>"><?=broker::$mint_states[$broker->data['mint_status']]['title']?> <? }?> </div> </td> <td><?=floor($worked_days_total/30)?></td> </tr> <? }?> <tfoot> <tr> <td colspan="2">VISO</td> <td> <?=(int)$total["new_clients"]?> </td> <td><?=(int)$total["calls"]?></td> <td><?=(int)$total["a_calls"]?></td> <td><?=(int)$total["meets"]?></td> <td><?=(int)$total["a_meets"]?></td> <td><?=(int)$total["contracts"]?></td> <td><?=(int)$total["object_reviews"]?></td> <td><?=(int)$total["ct_done"]?></td> <td><?=_number_format($total["comm"])?></td> <td></td> <td><?=_number_format($total["income"])?></td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr><td colspan="17"> </td></tr> <?php if(is_array($data['offices_involved']) && !empty($data['offices_involved'])) { foreach($data['offices_involved'] as $office_id => $o_total) { $office = new office($office_id); $title = ($office_id == -1) ? '- Kitos kompanijos / Kita -' : $office->data['title']; $title = ($office_id == -2) ? '- uNTu -' : $title; $title = ($office_id == -3) ? '- Prezentacijų bankas -' : $title; ?> <tr style="font-size:10px;"> <td colspan="2"><?= htmlspecialchars($title, ENT_QUOTES, 'utf-8'); ?></td> <td><?= (int)$o_total->new_clients ?></td> <td><?= (int)$o_total->calls ?> (<?= (int)$o_total->app_calls ?>)</td> <td><?= (int)$o_total->a_calls ?></td> <td><?= (int)$o_total->meets ?></td> <td><?= (int)$o_total->a_meets ?></td> <td><?= (int)$o_total->contracts ?></td> <td><?= (int)$o_total->object_reviews ?> (<?= (int)$o_total->orw_calls ?>)</td> <td><?= (int)$o_total->ct_done ?></td> <td><?= _number_format($o_total->comm) ?></td> <td></td> <td><abbr title="<?= trim(str_replace('.', ',', $o_total->income_math)); ?>"><?= _number_format($o_total->income) ?></abbr></td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <?php } } ?> </tfoot> </table> <? if (in_array($_REQUEST["order"], array('calls','meets','a_calls','a_meets','emails','total'))) { $order = 'ORDER by '.$_REQUEST["order"].' '.$_REQUEST["order_type"]; } else{ $order = "ORDER by total desc"; } $w = array(); if( $_REQUEST["office_ids"] ) $w[] = "b.office_id IN (". join(',',$_REQUEST["office_ids"]) .")"; $w[] = "b.type IN ('tele')"; if( $_REQUEST["show"] == 'active' ) $w[] = "b.status='active'"; $query = stats::get_broker_stats_query($_REQUEST["date_f"], $_REQUEST["date_t"], $w) . $order; echo ''; unset($total); $out = db_query($query); if( db_rows($out) ) { ?> <table width="100%" class="data tablesorter" border="0" cellspacing="0" cellpadding="0"> <thead> <tr> <th width="16"> </th> <th>getOrderType('b.surname')?>" rel="b.surname">Specialistas</th> <th>getOrderType('calls')?>" rel="calls">Skambučiai</th> <th>getOrderType('a_calls')?>" rel="a_calls">Skambučiai</th> <th width="100"> </th> <th width="100"> </th> <th>getOrderType('emails')?>" rel="emails">El.laiškai</th> <th>getOrderType('contracts')?>" rel="contracts">Pasirašytos sutartys</th> </tr> </thead> <? $i = 0; while( $row = db_object($out) ) { $i++; $broker = new broker( $row->broker_id ); $total["calls"] += $row->calls; $total["meets"] += $row->meets; $total["emails"] += $row->emails; $total["a_calls"] += $row->a_calls; $total["a_meets"] += $row->a_meets; $total["contracts"] += $row->contracts; ?> <tr> <td align="right"><?=$i?>.</td> <td><?=$broker->getName()?></td> <td><?=(int)$row->calls?> <? if($row->app_calls) {?>(<? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a href="#calls?broker_id=<?=(int)$broker->data["id"]?>&date_f=<?=$_REQUEST["date_f"]?>&date_t=<?=$_REQUEST["date_t"]?>&duration_f=1&client=1" target="_blank"><?=$row->app_calls?></a><? }else{?><?=$row->app_calls?><? }?>)<? }?></td> <td><? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?><a onclick="cal.open('<?=$_REQUEST["date_f"]?>',{dateTo:'<?=$_REQUEST["date_t"]?>',type:'call',status:'active',broker_id:<?=(int)$broker->data["id"]?>});" class="cRed"><?=(int)$row->a_calls?></a><? }else{?><?=(int)$row->a_calls?><? }?></td> <td> </td> <td> </td> <td><?=(int)$row->emails?></td> <td><a <? if(in_array($admin->data["type"], array('admin','office')) || $site->broker->data["id"] == $broker->data["id"]){?>onclick="stats.activityDialog({date:'<?=$_REQUEST["date_f"]?>',dateTo:'<?=$_REQUEST["date_t"]?>',status:'pasirasyta_sutartis',broker_id:<?=(int)$broker->data["id"]?>});"<? }?>><?=(int)$row->contracts?></a></td> </tr> <? }?> </table> <? }?> </form>