startSection('content'); ?> where('id_cms_users',Session::get('admin_id'))->first(); $first_date = date('Y-m-d', strtotime(date("Y-m-d", strtotime(date('Y-m-d'))) . ", first day of this month")); $last_date = date('Y-m-d',strtotime(date("Y-m-d", strtotime(date('Y-m-d'))) . ", last day of this month")); $rangeDefault = date($first_date .' - '. $last_date); $range = (g('range'))?g('range'):$rangeDefault; $datestart = substr($range, 0, 10); $dateend = substr($range, -10); if(g('range')==''){ $awal = $first_date; $akhir = $last_date; }else{ $awal = $datestart; $akhir = $dateend; } $sales = DB::table('sales') ->where('type','Sales'); if(Session::get('admin_privileges')==2){ $sales->where('id_sales_spv',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $sales->where('id',Session::get('id_login')); } if(g('range')==''){ // $sales->whereMonth('created_at',date('m')); }else{ $sales->whereBetween('created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $sales = $sales->count(); $sales_spv = DB::table('sales') ->where('type','SPV'); if(Session::get('admin_privileges')==2){ $sales_spv->where('id_sales_spv',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $sales_spv->where('id',Session::get('id_login')); } if(g('range')==''){ // $sales_spv->whereMonth('created_at',date('m')); }else{ $sales_spv->whereBetween('created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $sales_spv = $sales_spv->count(); $order = DB::table('sales_order'); if(Session::get('admin_privileges')==2){ $order->join('sales','sales.id','=','sales_order.id_sales'); $order->orWhere('sales.id',Session::get('id_login')); $order->orWhere('sales.id_sales_spv',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $order->join('sales','sales.id','=','sales_order.id_sales'); $order->where('sales.id',Session::get('id_login')); } if(g('range')==''){ // $order->whereMonth('sales_order.created_at',date('m')); }else{ $order->whereBetween('sales_order.created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $order = $order->count(); $canvasing = DB::table('canvasing'); if(Session::get('admin_privileges')==2){ $canvasing->join('sales','sales.id','=','canvasing.id_sales'); $canvasing->orWhere('sales.id',Session::get('id_login')); $canvasing->orWhere('sales.id_sales_spv',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $canvasing->join('sales','sales.id','=','canvasing.id_sales'); $canvasing->where('sales.id',Session::get('id_login')); } if(g('range')==''){ // $canvasing->whereMonth('canvasing.created_at',date('m')); }else{ $canvasing->whereBetween('canvasing.created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $canvasing = $canvasing->count(); $list_order = DB::table('sales_order') ->join('sales','sales.id','sales_order.id_sales') ->select('sales_order.*','sales.nama as nama_sales','sales_order.customercompany as nama_customer') ->orderBy('sales_order.id','desc'); if(Session::get('admin_privileges')==2){ $list_order->orWhere('sales.id_sales_spv',Session::get('id_login')); $list_order->orWhere('sales.id',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $list_order->where('sales.id',Session::get('id_login')); } if(g('range')==''){ // $list_order->whereMonth('sales_order.created_at',date('m')); }else{ $list_order->whereBetween('sales_order.created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $list_order = $list_order->get(); $list_canvasing = DB::table('canvasing') ->join('sales','sales.id','canvasing.id_sales') ->select('canvasing.*','sales.nama as nama_sales','canvasing.customercompany as nama_customer') ->orderBy('canvasing.id','desc'); if(Session::get('admin_privileges')==2){ $list_canvasing->orWhere('sales.id',Session::get('id_login')); $list_canvasing->orWhere('sales.id_sales_spv',Session::get('id_login')); }elseif(Session::get('admin_privileges')==3){ $list_canvasing->where('sales.id',Session::get('id_login')); } if(g('range')==''){ // $list_canvasing->whereMonth('canvasing.created_at',date('m')); }else{ $list_canvasing->whereBetween('canvasing.created_at', array($datestart.' 00:00:00', $dateend.' 23:59:59')); } $list_canvasing = $list_canvasing->get(); $value_range = str_replace(" - ","+",$range); ?> type=='text'): ?>
type=='file'): ?>

Sales

Sales SPV

Order

Canvasing

Order
addLoop($__currentLoopData); foreach($__currentLoopData as $lo): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> popLoop(); $loop = $__env->getLastLoop(); ?>
No No Order Date Order Sales Customer
no_order); ?> tgl_order)); ?> nama_sales); ?> nama_customer); ?>

Canvasing
addLoop($__currentLoopData); foreach($__currentLoopData as $lc): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?> popLoop(); $loop = $__env->getLastLoop(); ?>
No Date Sales Customer
created_at)); ?> nama_sales); ?> nama_customer); ?>
stopSection(); ?> make("crudbooster::admin_template", array_except(get_defined_vars(), array('__data', '__path')))->render()