EVOLUTION-NINJA
Edit File: admin_dashboard.php
<?php echo view('includes/header');?> <script src="<?php echo base_url('public/assets/js/jquery-ui.js');?>"></script> <?php $admin_id = session()->get('admin_id'); $account_user_id = session()->get('account_user_id'); $executive_user_id = session()->get('executive_user_id'); $management_user_id = session()->get('management_user_id'); $documentation_user_id = session()->get('documentation_user_id'); $department = session()->get('user_type_id'); ?> <section class="content-header"> <h1> Dashboard </h1> </section> <?php if(session()->get('user_type_id') == 1) { ?> <section class="content"> <div class="row"> <div id="m51" class="col-lg-3 col-xs-6"> <div class="small-box bg-aqua"> <div class="inner"> <h3 class="total_owners">0</h3> <p>Land owners</p> </div> <div class="icon"> <i class="ion ion-bag"></i> </div> <a href="<?php echo base_url('/land-owner-list');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m52" class="col-lg-3 col-xs-6"> <div class="small-box bg-green"> <div class="inner"> <h3 class="total_brokers">0</h3> <p>Brokers</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/associate-broker-list');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m53" class="col-lg-3 col-xs-6"> <div class="small-box bg-yellow"> <div class="inner"> <h3 class="total_projects">0</h3> <p>Projects</p> </div> <div class="icon"> <i class="ion ion-person-add"></i> </div> <a href="<?php echo base_url('/project-list');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m54" class="col-lg-3 col-xs-6"> <div class="small-box bg-red"> <div class="inner"> <h3 class="total_enquiries">0</h3> <p>Enquiries</p> </div> <div class="icon"> <i class="ion ion-pie-graph"></i> </div> <a href="<?php echo base_url('/enquiry-list');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m55" class="col-lg-3 col-xs-6"> <div class="small-box bg-red"> <div class="inner"> <h3 class="accounts">0<sup style="font-size: 20px"></sup></h3> <p>Accounts</p> </div> <div class="icon"> <i class="ion ion-pie-graph"></i> </div> <a href="<?php echo base_url('/accounts');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m56" class="col-lg-3 col-xs-6"> <div class="small-box bg-yellow"> <div class="inner"> <h3 class="reception">0<sup style="font-size: 20px"></sup></h3> <p>Reception</p> </div> <div class="icon"> <i class="ion ion-person-add"></i> </div> <a href="<?php echo base_url('/reception-list');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m57" class="col-lg-3 col-xs-6"> <div class="small-box bg-green"> <div class="inner"> <h3 class="loans">0<sup style="font-size: 20px"></sup></h3> <p>Loans</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/loans');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m58" class="col-lg-3 col-xs-6"> <div class="small-box bg-aqua"> <div class="inner"> <h3 class="dob">0<sup style="font-size: 20px"></sup></h3> <p>DOB</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/dob-calendar');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m59" class="col-lg-3 col-xs-6"> <div class="small-box bg-green"> <div class="inner"> <h3 class="doa">0<sup style="font-size: 20px"></sup></h3> <p>DOA</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/doa-calendar');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> </div> <!-- row ----> <div class="row" style="margin-bottom: 15px !important;"> <form id="land_owner" class="form-inline sales_form"> <div class="form-group col-sm-12 col-md-4"> <label class="col-sm-4 ">From date</label> <input type="text" class="form-control col-sm-8 from_date_picker" name="from_date"> </div> <div class="form-group col-sm-12 col-md-4"> <label class="col-sm-4">To date</label> <input type="text" class="form-control col-sm-5 to_date_picker" name="to_date"> </div> <div class=" col-sm-12 col-md-4" > <button type="submit" id="sales_submit" class=" btn btn-primary submit" style="margin-top: 0px !important;">Submit</button> </div> </form> </div> <div class="row"> <section class="col-lg-7 connectedSortable"> <div class="nav-tabs-custom"> <!-- Tabs within a box --> <div class="tab-content no-padding"> <!-- Morris chart - Sales --> <label>Sales Graph (Total Sqft)</label> <div class="chart tab-pane active" id="revenue-chart-total-sqft" style="position: relative; height: 300px;"></div> </div> </div> <!--- Chat box ----> </section> <!--- left side --> <section class="col-lg-7 connectedSortable"> <div class="nav-tabs-custom"> <!-- Tabs within a box --> <div class="tab-content no-padding"> <!-- Morris chart - Sales --> <label>Sales Graph (Total Sqft Booked)</label> <div class="chart tab-pane active" id="revenue-chart" style="position: relative; height: 300px;"></div> </div> </div> <!--- Chat box ----> </section> <!--- left side ----> <section class="col-lg-7 connectedSortable"> <div class="nav-tabs-custom"> <!-- Tabs within a box --> <div class="tab-content no-padding"> <!-- Morris chart - Sales --> <label>Sales Graph (Total Sqft Left)</label> <div class="chart tab-pane active" id="revenue-chart-total-sqft-left" style="position: relative; height: 300px;"></div> </div> </div> <!--- Chat box ----> </section> <!--- left side --> </div> <!-- row 2 ----> </section> <?php } else if(session()->get('user_type_id') == 22) { ?> <section class="content"> <div class="row"> <div id="m59" class="col-lg-3 col-xs-6"> <div class="small-box bg-green"> <div class="inner"> <h3 class="doa">0<sup style="font-size: 20px"></sup></h3> <p>DOA</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/doa-calendar');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> <div id="m58" class="col-lg-3 col-xs-6"> <div class="small-box bg-aqua"> <div class="inner"> <h3 class="dob">0<sup style="font-size: 20px"></sup></h3> <p>DOB</p> </div> <div class="icon"> <i class="ion ion-stats-bars"></i> </div> <a href="<?php echo base_url('/dob-calendar');?>" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div> </div> <!-- ./col --> </div> <!-- row ----> </section> <?php } else { ?> <section> <div class="row"> <img class="img-responsive" width="100%" src="<?php echo base_url('public/assets/images/Gss_Welcome_banner.jpg');?>"> </div> </section> <?php } ?> <link href="https://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet"> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript">google.load('visualization', '1.0', {'packages': ['corechart']});</script> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <?php $admin_id = session()->get('admin_id'); $user_type = session()->get('user_type'); $user_type_id = session()->get('user_type_id'); // echo $user_type_id.'</br>'; //$access = session()->get('powers'); $admin_array = ''; $accounts_array = ''; $executive_array = ''; $management_array = ''; $documentation_array = ''; $loan_array = ''; ?> <script type="text/javascript"> $(document).ready(function(){ google.charts.load('current', {'packages': ['bar','corechart']}); $('.from_date_picker').datepicker({ changeMonth:true, changeYear:true, yearRange: "2000:c", dateFormat: 'dd-mm-yy' }); $('.to_date_picker').datepicker({ changeMonth:true, changeYear:true, yearRange: "2000:c", dateFormat: 'dd-mm-yy' }); //------------------------Sales graph-------------------------------// $('.sales_form').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $("#sales_submit").attr('disabled', 'disabled'); $("#sales_submit").text("submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("datewise-sales-for-chart")?>', data : formdata, contentType: false, processData: false, success:function(response){ // response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); chart_data = response; drawMouseoverVisualization(); } else { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); } } }); }); AllSales(); function AllSales() { $.ajax({ type : 'get', url : '<?php echo site_url("get-all-sales")?>', success:function(response){ // response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); chart_data = response; drawMouseoverVisualization(); } else { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); } } }); } // barsVisualization must be global in our script tag to be able // to get and set selection. var barsVisualization; function drawMouseoverVisualization() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Project'); data.addColumn('number', 'Total sqft booked'); $.each(chart_data.all_sales, function (idx, vx) { // alert(vx.dimension); if(vx.dimension > 0) { var cat = vx.project; var sales = parseFloat(vx.dimension); data.addRows([[cat, sales]]); } }); barsVisualization = new google.visualization.ColumnChart(document.getElementById('revenue-chart')); barsVisualization.draw(data, null); // Add our over/out handlers. google.visualization.events.addListener(barsVisualization, 'onmouseover', barMouseOver); google.visualization.events.addListener(barsVisualization, 'onmouseout', barMouseOut); } function barMouseOver(e) { barsVisualization.setSelection([e]); } function barMouseOut(e) { barsVisualization.setSelection([{'row': null, 'column': null}]); } //-----------------------------------------------------------------// AllTotalSqft(); function AllTotalSqft() { $.ajax({ type : 'get', url : '<?php echo site_url("get-project-total-sqft")?>', success:function(response){ // response=jQuery.parseJSON(response); // console.log(response); if(response.result==1) { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); chart_data = response; drawMouseoverVisualization1(); } else { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); } } }); } // barsVisualization must be global in our script tag to be able // to get and set selection. var barsVisualization1; function drawMouseoverVisualization1() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Project'); data.addColumn('number', 'Total sqft'); $.each(chart_data.all_sales, function (idx, vx) { if(vx.dimension != null) { var cat = vx.project; var sales = parseFloat(vx.dimension); data.addRows([[cat, sales]]); } }); barsVisualization1 = new google.visualization.ColumnChart(document.getElementById('revenue-chart-total-sqft')); barsVisualization1.draw(data, null); // Add our over/out handlers. google.visualization.events.addListener(barsVisualization1, 'onmouseover', barMouseOver1); google.visualization.events.addListener(barsVisualization1, 'onmouseout', barMouseOut1); } function barMouseOver1(e) { barsVisualization1.setSelection([e]); } function barMouseOut1(e) { barsVisualization1.setSelection([{'row': null, 'column': null}]); } //-----------------------------------------------------------------// LeftTotalSqft(); function LeftTotalSqft() { //alert(); $.ajax({ type : 'get', url : '<?php echo site_url("get-project-total-sqft-left")?>', success:function(response){ // response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); chart_data = response; drawMouseoverVisualization2(); } else { $("#sales_submit").text("Submit"); $("#sales_submit").removeAttr('disabled'); } } }); } // barsVisualization must be global in our script tag to be able // to get and set selection. var barsVisualization2; function drawMouseoverVisualization2() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Project'); data.addColumn('number', 'Total sqft'); $.each(chart_data.all_sales, function (idx, vx) { if(vx.dimension > 0) { var cat = vx.project; var sales = parseFloat(vx.dimension); data.addRows([[cat, sales]]); } }); barsVisualization2 = new google.visualization.ColumnChart(document.getElementById('revenue-chart-total-sqft-left')); barsVisualization2.draw(data, null); // Add our over/out handlers. google.visualization.events.addListener(barsVisualization2, 'onmouseover', barMouseOver2); google.visualization.events.addListener(barsVisualization2, 'onmouseout', barMouseOut2); } function barMouseOver2(e) { barsVisualization2.setSelection([e]); } function barMouseOut2(e) { barsVisualization2.setSelection([{'row': null, 'column': null}]); } get_total_all_stats(); function get_total_all_stats() { $.ajax({ type : 'get', url : '<?php echo site_url("get-total-stats")?>', success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.total_owners').append(response.total_owners); $('.total_projects').html(response.total_projects); $('.total_brokers').html(response.total_brokers); $('.total_enquiries').html(response.total_enquiries); $('.accounts').html(response.total_accounts); $('.reception').html(response.total_reception); $('.loans').html(response.total_loans); $('.doa').html(response.total_doa); $('.dob').html(response.total_dob); } } }); } }); </script> <?php echo view('includes/footer'); ?>