EVOLUTION-NINJA

Edit File: incentive.php

<?php echo view('includes/header');?> <link href="<?php echo base_url('public/assets/admin_dashboard/css/jquery-ui.css');?>" rel="stylesheet"> <script src="<?php echo base_url('public/assets/js/jquery-ui.js');?>"></script> <script src="<?php echo base_url('public/assets/admin_dashboard/js/jquery.table2excel.js');?>"></script> <?php $admin_id = session('admin_id'); $user_type = session('user_type'); $user_type_id = session('user_type_id'); ?> <input type="hidden" class="form-control col-sm-8 admin_id" name="admin_id" value="<?php echo $admin_id;?>" required="required"> <input type="hidden" class="form-control col-sm-8 user_type" name="user_type" value="<?php echo $user_type;?>" required="required"> <input type="hidden" class="form-control col-sm-8 user_type_id" name="user_type_id" value="<?php echo $user_type_id;?>" required="required"> <section class="content-header"> <h1> Incentive</h1> </section> <!--- section 1 --> <section class="content"> <div class="col-sm-12 col-md-12"> <input type="hidden" class="form-control col-sm-8 invoice_id_pk" name="id" required="required"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-6"> <div class="col-sm-12 col-md-6"> <label class="radio-inline"><input style="width:auto !important; height:auto !important;" type="radio" value="Executives" name="incentive_type" id="radio_executives">Executives</label> <label class="radio-inline"><input style="width:auto !important; height:auto !important;" type="radio" value="Logistic" name="incentive_type" id="radio_logistic">Logistic</label> </div> </div> </div> <!-- row 1----> <div id="div_executives" class="div_executives" style="display:none;"> <form id="land_owner" class="form-inline executive_form" method="post"> <div class="row executive"> <div class="row land_owner_a"> <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 bg_from" id="booking_from" name="from_date" required > </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 bg_to" id="booking_to" name="to_date" required > </div> <div class="form-group col-sm-12 col-md-4"> <label class="col-sm-4 ">Executive</label> <select class="form-control col-sm-8 en_executive" name="reference" id="type" required> <option value="">Select</option> <?php foreach($reference as $value){ ?> <option value="<?php echo $value->broker_id; ?>"><?php echo $value->associate_name; ?></option> <?php } ?> </select> </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-4 col-sm-offset-4 col-md-4"> <label class="col-sm-4"></label> <button type="submit" id="booking_submit" style="margin-top: 40px !important;" class="btn btn-primary center-block submit">Submit</button> </div> </div> </div> </form> </div> <div class="row shared_to_list" style="display:none;"> <div id = "jaytab1" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list1"></table> <div id="pager1"></div> <div id="dialogSelectRow1" title="Warning" style="display:none"> <p>Please select row</p> </div> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4" style="margin-top:2%;"> <!--<button type="button" id="get_site_grid" class="btn btn-primary center-block get_site_grid" style="display:none;width:70%;" onclick="getSelectedRow()" >Submit</button>--> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 4----> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="incentive_shared_export_table" class="shared_export_table"></table></div> <div class="row selected_list" style="display:none;"> <div id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list3"></table> <div id="pager3"></div> <div id="dialogSelectRow3" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div class="row selected_list" style="display:none;"> <div id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list20"></table> <div id="pager20"></div> <div id="dialogSelectRow3" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="incentive_selected_export_table" class="selected_export_table"></table></div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="60_selected_export_table" class="_60selected_export_table"></table></div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="both_selected_export_table" class="both_selected_export_table"></table></div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="100_selected_export_table" class="100_selected_export_table"></table></div> <div class="row paid_pending_list" style="display:none;"> <div id = "jaytab9" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list9"></table> <div id="pager9"></div> <div id="dialogSelectRow9" title="Warning" style="display:none"> <p>Please select row</p> </div> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4" style="margin-top:2%;"> <button type="button" id="get_site_grid_pending" class="btn btn-primary center-block get_site_grid_pending" style="display:none;width:70%;" onclick="pending_getSelectedRow()" >Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="insentive_details_export_table" class="insentive_export_table"></table></div> <div class="row pending_list" style="display:none;"> <div id = "jaytab5" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list5"></table> <div id="pager5"></div> <div id="dialogSelectRow5" title="Warning" style="display:none"> <p>Please select row</p> </div> <!-- row 4----> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="pending_insentive_export_table" class="pending_export_table"></table></div> <!----------------------------------------------------------------> <div class="row incentive_list" style="display:none;"> <div id = "jaytab4" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list4"></table> <div id="pager4"></div> <div id="dialogSelectRow4" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="paidpending_insentive_export_table" class="paidpending_export_table"></table></div> <!----------------------------------------------------------------> <div class="row show-executive" style="display:none;"> <form class="executive_incentive"> <div class="row land_owner_a"> <input type="hidden" class="form-control col-sm-8 status_booking_id" name="status_booking_id" required="required"> <input type="hidden" class="form-control col-sm-8 sixty_booking_id" name="sixty_booking_id"> <input type="hidden" class="form-control col-sm-8 fourty_booking_id" name="fourty_booking_id"> <input type="hidden" class="form-control col-sm-8 project_id" name="project_id" required="required"> <input type="hidden" class="form-control col-sm-8 site_number" name="site_number" required="required"> <input type="hidden" class="form-control col-sm-8 executive_id" name="executive_id" required="required"> <input type="hidden" class="form-control col-sm-8 both_booking_id" name="both_booking_id" required="required"> <input type="hidden" class="form-control col-sm-8 fourty_project_id" name="fourty_project_id" required="required"> <input type="hidden" class="form-control col-sm-8 fourty_site_number" name="fourty_site_number" required="required"> <input type="hidden" class="form-control col-sm-8 sixty_project_id" name="sixty_project_id" required="required"> <input type="hidden" class="form-control col-sm-8 sixty_site_number" name="sixty_site_number" required="required"> <input type="hidden" class="form-control col-sm-8 fourty_broker_id" name="fourty_broker_id" required="required"> <!-- <input type="text" class="form-control col-sm-8 sixty_broker_id" name="sixty_broker_id" required="required"> --> <input type="hidden" class="form-control col-sm-8 both_project_id" name="both_project_id" required="required"> <input type="hidden" class="form-control col-sm-8 both_site_number" name="both_site_number" required="required"> <input type="hidden" class="form-control col-sm-8 fourty_status" name="fourty_status" > <input type="hidden" class="form-control col-sm-8 sixty_status" name="sixty_status" > <input type="hidden" class="form-control col-sm-8 both_status" name="both_status" > <div class="row"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Total Sft</label> <input type="text" class="form-control col-sm-8 total_sq_ft" name="total_sqft" required="required" readonly> <input type="hidden" class="form-control col-sm-8 total_sqft_added" name="total_sqft_added" required="required" readonly> <input type="hidden" class="form-control col-sm-8 total_sqft_incentive_added" name="total_sqft_incentive_added" required="required" readonly> </div> <!--<div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Basic Target</label> <input type="text" class="col-sm-8 basic_target" name="basic_target" required="required" readonly> </div>--> <!-- <div class="form-group col-sm-12 col-md-6"> --> <!-- <label class="col-sm-4">Basic Target</label> --> <input type="hidden" class="form-control col-sm-8 basic_targets" name="basic_target" required="required" readonly> <input type="hidden" class="form-control col-sm-8 broker_id" name="broker_id" required="required" readonly> <input type="hidden" class="form-control col-sm-8 incentive_in_percentage" name="in_per" required="required" readonly> <input type="hidden" class="form-control col-sm-8 incentive_in_rs" name="in_rs" required="required" readonly> <!-- </div> --> </div> </div> <div class="row"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Duration</label> <input type="text" class="form-control col-sm-8 duration" name="duration"> </div> <!-- <div class="form-group col-sm-12 col-md-6"> --> <!-- <label class="col-sm-4">Total Target</label> --> <input type="hidden" class="form-control col-sm-8 total_target" name="total_target" required="required" readonly> <!-- </div> --> </div> </div> <div class="row"> <div class="container"> <!-- <div class="form-group col-sm-12 col-md-6"> --> <!-- <label class="col-sm-4">Achieved</label> --> <input type="hidden" class="form-control col-sm-8 achieved" name="achieved" required="required" readonly> <!-- </div> --> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Cancelled/Refunded</label> <input type="text" class="form-control col-sm-8 cancelled" name="cancelled" required="required" readonly> </div> </div> </div> <div class="row total_fourty_perc_div" style="display: none;"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Total 40% Amount</label> <input type="text" class="form-control col-sm-8 total_fourty_perc" name="total_fourty_perc" readonly> </div> </div> </div> <div class="row total_sixty_perc_div" style="display: none;"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Total 60% Amount</label> <input type="text" class="form-control col-sm-8 total_sixty_perc" name="total_sixty_perc[]" readonly> </div> </div> </div> <div class="row grand_total_div" style="display: none;"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Grand Total</label> <input type="text" class="form-control col-sm-8 grand_total" name="grand_total" > <input type="hidden" class="form-control col-sm-8 both_amount" name="both_amount" readonly> </div> </div> </div> <div class="row"> <div class="container"> <!-- <div class="form-group col-sm-12 col-md-6"> --> <!-- <label class="col-sm-4">Excess</label> --> <input type="hidden" class="form-control col-sm-8 excess" name="excess" required="required" readonly> <!-- </div> --> <!-- <div class="form-group col-sm-12 col-md-6"> --> <!-- <label class="col-sm-4">shortage</label> --> <input type="hidden" class="form-control col-sm-8 shortage" name="shortage" required="required" readonly> <!-- </div> --> </div> </div> <div class="row"> <div class="container"> <!-- <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Net Achieved Calculation</label> --> <input type="hidden" class="form-control col-sm-4 net_achieved" name="net_achieved" required="required" readonly> <!-- </div> --> <!-- <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Net Amount</label> --> <input type="hidden" class="form-control col-sm-4 net_amt" name="net_amt" required="required" readonly> <!-- </div> --> </div> </div> <div class="row"> <div class="container"> <!-- <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Amount</label> --> <input type="hidden" class="form-control col-sm-4 amount" name="amount" required="required" readonly> <!-- </div> --> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Payment Mode</label> <div class="col-sm-12 col-md-6"> <label class="radio-inline"><input type="radio" value="Cheque" id="check1" name="payment_type1" style="width:auto !important; height:auto !important;" required="required" >Cheque</label> <label class="radio-inline"><input type="radio" value="Cash" id="cash1" name="payment_type1" style="width:auto !important; height:auto !important;">Cash</label> <label class="radio-inline"><input type="radio" value="Online Payment" id="online_payment1" name="payment_type1" style="width:auto !important; height:auto !important;">NEFT</label> </div> </div> </div> </div> <div class="row"> <div class="container"> <div id="cheque_details"> </div><!-- Cheque --> </div> </div> <div class="row"> <div class="container"> <div id="neft_details"> </div> <!-- Online Payment --> </div> </div> <div class="row"> <div class="container"> <div id="cash_details"> </div> <!-- Cash --> </div> </div> <div class="row"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Remarks</label> <textarea type="text" rows="5" cols="5" class="form-control col-sm-8 exe_remark" style="margin: 0px !important; height: 94px !important; width: 324px !important;" name="exe_remark"></textarea> </div> </div> </div> </div> <!-- row 2----> <div class="row land_owner_a"> <div class="form-group col-sm-4 col-sm-offset-4 col-md-4"> <label class="col-sm-4"></label> <button type="submit" id="executive_submit_button" style="margin-top: 0px !important;" class="btn btn-primary center-block submit">Submit</button> </div> </div> </form> </div> <!--------------------------------------------------logistic--------------------------------------------------------> <div id="div_logistic" class="div_logistic" style="display:none;"> <form id="land_owner" class="form-inline logistic_form" method="post"> <div class="row logistic"> <div class="row land_owner_a"> <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 log_from_date_picker log_from" id="log_from" name="log_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 log_to_date_picker log_to" id="log_to" name="log_to_date" > </div> <div class="form-group col-sm-12 col-md-4"> <label class="col-sm-4 ">Logistic</label> <select class="form-control col-sm-8 bg_logistic" id="sel1" name="logistics"> <option value="">Select</option> <?php foreach($logistics as $val) { ?> <option value="<?php echo $val->broker_id;?>"><?php echo $val->associate_name;?></option> <?php } ?> </select> </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-4 col-sm-offset-4 col-md-4"> <label class="col-sm-4"></label> <button type="submit" id="log_submit" style="margin-top: 40px !important;" class="btn btn-primary center-block submit">Submit</button> </div> </div> </div> </form> </div> <div class="row shared_to_log_list" style="display:none;"> <div id = "jaytab2" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list2"></table> <div id="pager2"></div> <div id="dialogSelectRow2" title="Warning" style="display:none"> <p>Please select row</p> </div> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4" style="margin-top:2%;"> <!--<button type="button" id="get_site_grid" class="btn btn-primary center-block get_site_grid" style="display:none;width:70%;" onclick="getSelectedRow()" >Submit</button>--> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 4----> </div> </div> <div class="row selected_log_list" style="display:none;"> <div id = "jaytab6" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list6"></table> <div id="pager6"></div> <div id="dialogSelectRow6" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="selected_logistics_export_table" class="selected_logistics_export_table"></table></div> <div class="row incentive_log_list" style="display:none;"> <div id = "jaytab7" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list7"></table> <div id="pager7"></div> <div id="dialogSelectRow7" title="Warning" style="display:none"> <p>Please select row</p> </div> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4" style="margin-top:2%;"> <button type="button" id="get_logistic_site_grid" class="btn btn-primary center-block get_logistic_site_grid" style="display:none;width:70%;" onclick="log_getSelectedRow()" >Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 4----> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="insentive_logistics_export_table" class="insentive_logistics_export_table"></table></div> <div class="row pending_log_list" style="display:none;"> <div id = "jaytab8" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid"> <div class="grid_div"></div><table id="list8"></table> <div id="pager8"></div> <div id="dialogSelectRow8" title="Warning" style="display:none"> <p>Please select row</p> </div> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4" style="margin-top:2%;"> <button type="button" id="get_logistic_site_grid_pending" class="btn btn-primary center-block get_logistic_site_grid_pending" style="display:none;width:70%;" onclick="pending_log_getSelectedRow()" >Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 4----> </div> </div> <div style="display:none;"><table border="1" style="border-spacing: 0px !important;" id="pending_logistics_export_tabledata" class="pending_logistics_export_table"></table></div> <div class="row show-logistic" style="display:none;"> <form class="logistic_incentive"> <div class="row land_owner_a"> <div class="row"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Total Number of Sites</label> <input type="text" class="form-control col-sm-8 total_sites" name="total_sites" required="required" readonly> </div> <!--<div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Basic Target</label> <input type="text" class="col-sm-8 basic_target" name="basic_target" required="required" readonly> </div>--> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Total Amount</label> <input type="text" class="form-control col-sm-8 tot_amt" name="tot_amt" required="required" readonly> <input type="hidden" class="form-control col-sm-8 log_broker_id" name="log_broker_id" required="required" readonly> <input type="hidden" class="form-control col-sm-8 log_project_id" name="log_project_id" required="required"> <input type="hidden" class="form-control col-sm-8 log_site_number" name="log_site_number" required="required"> </div> </div> </div> </div> <!-- row 2----> <div class="row land_owner_a"> <div class="row"> <div class="container"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4">Remarks</label> <textarea type="text" rows="5" cols="5" class="form-control col-sm-8 log_remark" style="margin: 0px !important; height: 94px !important; width: 324px !important;" name="log_remark"></textarea> </div> </div> </div> </div> <div class="row land_owner_a"> <div class="form-group col-sm-4 col-sm-offset-4 col-md-4"> <label class="col-sm-4"></label> <button type="submit" id="logistic_submit_button" style="margin-top: 0px !important;" class="btn btn-primary center-block submit">Submit</button> </div> </div> </form> </div> </div> <div class="modal fade" id="share_exe_between_modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Sharefg</h4> </div> <div class="modal-body"> <form id="land_owner" class="form-inline share_exe_between" enctype="multipart/form-data"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4">Share with</label> <select class="form-control col-sm-8 incentive_executive" id="incentive_executive" name="executive_ids"> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <input type="hidden" class="form-control col-sm-8 shared_exe_to" name="shared_exe_to" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Amount</label> <input type="text" class="form-control col-sm-8 shared_exe_amount" name="shared_exe_amount" > </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Percentage</label> <input type="text" class="form-control col-sm-8 shared_exe_percent" name="shared_exe_percent"> </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Total Amount</label> <input type="text" class="form-control col-sm-8 shared_total_amount" name="shared_total_amount"> </div> </div> <input type="hidden" class="form-control col-sm-8 exe_booking_id" name="exe_booking_id" required="required" readonly> <input type="hidden" class="form-control col-sm-8 exe_broker_id" name="exe_broker_id" required="required" readonly> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block share_submit_button submit" id="share_exe_submit">Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> <div class="modal fade" id="share_log_between_modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Share</h4> </div> <div class="modal-body"> <form id="land_owner" class="form-inline share_log_between" enctype="multipart/form-data"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4">Share with</label> <select class="form-control col-sm-8 incentive_logistic" id="incentive_logistic" name="logistics_ids"> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Amount</label> <input type="text" class="form-control col-sm-8 shared_log_amount" name="shared_log_amount" required="required" readonly> </div> </div> <!-- row 2--> <input type="hidden" class="form-control col-sm-8 booking_id" name="booking_id" required="required" readonly> <input type="hidden" class="form-control col-sm-8 broker_id" name="broker_id" required="required" readonly> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block share_submit_button submit" id="share_log_submit">Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> <div class="modal fade" id="calc_model" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Add Calculation</h4> </div> <div class="modal-body"> <form id="land_owner" class="form-inline calc_form" method="post" > <input type="hidden" class="form-control col-sm-8 calc_reference" name="calc_reference" required="required"> <input type="hidden" class="form-control col-sm-8" name="calc_booking_id" required="required"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Sqft</label> <input type="text" class="form-control col-sm-8" name="calc_total_sqft" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Rate per Sqft</label> <input type="text" class="form-control col-sm-8" name="calc_rate_per_sqft" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Amount Fixed</label> <input type="text" class="form-control col-sm-8" name="calc_total_amount_fixed" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">40% Incentive on Agt</label> <input type="text" class="form-control col-sm-8" name="calc_incentive_on_agmnt" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">60% Incentive on Reg</label> <input type="text" class="form-control col-sm-8" name="calc_incentive_on_regn" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Insentive Precentage</label> <select class="form-control col-sm-8" name="calc_insentive_perc" required> <option value="">Select</option> <option value="40%">40%</option> <option value="60%">60%</option> <option value="Both">Both</option> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Balance</label> <input type="text" class="form-control col-sm-8" name="calc_balance" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Source</label> <input type="text" class="form-control col-sm-8" name="calc_source" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block calc_submit submit">Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> <div class="modal fade" id="paidcalc_model" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Add Calculation</h4> </div> <div class="modal-body"> <form id="land_owner" class="form-inline paidcalc_form" method="post" > <input type="hidden" class="form-control col-sm-8" name="paidcalc_reference" required="required"> <input type="hidden" class="form-control col-sm-8" name="paidcalc_booking_id" required="required"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Sqft</label> <input type="text" class="form-control col-sm-8" name="paidcalc_total_sqft" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Rate per Sqft</label> <input type="text" class="form-control col-sm-8" name="paidcalc_rate_per_sqft" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Amount Fixed</label> <input type="text" class="form-control col-sm-8" name="paidcalc_total_amount_fixed" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">40% Incentive on Agt</label> <input type="text" class="form-control col-sm-8" name="paidcalc_incentive_on_agmnt" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">60% Incentive on Reg</label> <input type="text" class="form-control col-sm-8" name="paidcalc_incentive_on_regn" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Insentive Precentage</label> <select class="form-control col-sm-8" name="paidcalc_insentive_perc" required> <option value="">Select</option> <option value="40%">40%</option> <option value="60%">60%</option> <option value="Both">Both</option> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Balance</label> <input type="text" class="form-control col-sm-8" name="paidcalc_balance" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Source</label> <input type="text" class="form-control col-sm-8" name="paidcalc_source" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block paidcalc_submit submit">Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> </section> <div class="modal fade" id="edit_share_exe_between_modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Share</h4> </div> <div class="modal-body"> <form id="update_shared_between" class="form-inline" enctype="multipart/form-data"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4">Share with</label> <select class="form-control col-sm-8 edit_incentive_executive" name="edit_shared_to_executive_ids"> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <input type="hidden" class="form-control col-sm-8 edit_exe_broker_id" name="edit_shared_exe_to" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Amount</label> <input type="text" class="form-control col-sm-8 edit_shared_exe_amount" name="edit_shared_exe_amount" > </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Percentage</label> <input type="text" class="form-control col-sm-8 edit_shared_exe_percent" name="edit_shared_exe_percent"> </div> </div> <!-- row 2--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-8"> <label class="col-sm-4"> Total Amount</label> <input type="text" class="form-control col-sm-8 edit_shared_total_amount" name="edit_shared_total_amount"> </div> </div> <input type="hidden" class="form-control col-sm-8 edit_exe_booking_id" name="edit_exe_booking_id" required="required" readonly> <input type="hidden" class="form-control col-sm-8 edit_exe_broker_id" name="shared_from_executive_id" required="required" readonly> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block edit_share_submit_button" >Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> <div class="modal fade" id="edit_model" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button> <h4 class="modal-title" id="myModalLabel">Edit Calculation</h4> </div> <div class="modal-body"> <form id="update_form" class="form-inline " method="post" > <input type="hidden" class="form-control col-sm-8" name="edit_calc_reference" required="required"> <input type="hidden" class="form-control col-sm-8" name="edit_calc_booking_id" required="required"> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Sqft</label> <input type="text" class="form-control col-sm-8" name="edit_calc_total_sqft" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Rate per Sqft</label> <input type="text" class="form-control col-sm-8" name="edit_calc_rate_per_sqft" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Total Amount Fixed</label> <input type="text" class="form-control col-sm-8" name="edit_calc_total_amount_fixed" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">40% Incentive on Agt</label> <input type="text" class="form-control col-sm-8" name="edit_calc_incentive_on_agmnt" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">60% Incentive on Reg</label> <input type="text" class="form-control col-sm-8" name="edit_calc_incentive_on_regn" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Insentive Precentage</label> <select class="form-control col-sm-8" name="edit_calc_insentive_perc" required> <option value="">Select</option> <option value="40%">40%</option> <option value="60%">60%</option> <option value="Both">Both</option> </select> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Balance</label> <input type="text" class="form-control col-sm-8" name="edit_calc_balance" required="required" readonly> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-4">Source</label> <input type="text" class="form-control col-sm-8" name="edit_calc_source" required="required"> </div> </div> <!-- row 1--> <div class="row land_owner_a"> <div class="col-sm-4 col-md-4"></div> <div class="col-sm-4 col-md-4"> <button type="submit" class="btn btn-primary center-block edit_calc_submit submit">Submit</button> </div> <div class="col-sm-4 col-md-4"></div> </div> <!-- row 6--> </form> </div> </div> </div> </div> <!-- This is the Javascript file of jqGrid --> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" /> <script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function() { $(function(){ $(".from_date_picker").datepicker({ dateFormat: 'dd-mm-yy', }).on('changeDate', function(ev){ $('.from_date_picker').datepicker('hide'); }); }); $('.from_date_picker').on('change', function(){ var date = $(this).val(); $('.to_date_picker').datepicker({ dateFormat: 'dd-mm-yy', minDate: date, }); }); $(function(){ $(".log_from_date_picker").datepicker({ dateFormat: 'dd-mm-yy', }).on('changeDate', function(ev){ $('.log_from_date_picker').datepicker('hide'); }); }); $('.log_from_date_picker').on('change', function(){ var date = $(this).val(); $('.log_to_date_picker').datepicker({ dateFormat: 'dd-mm-yy', minDate: date, }); }); }); $("input[name='payment_type1']").change(function(){ var value = $('input[name=payment_type1]:checked').val(); if(value == "Cheque") { $("#neft_details").empty(); $('#cash_details').empty(); var total1 = $('.total_fourty_perc').val(); if(total1 != "") { var fourty = $('.total_fourty_perc').val(); } else { var fourty = "0"; } var total2 = $('.total_sixty_perc').val(); if(total2 != "") { var sixty = $('.total_sixty_perc').val(); } else { var sixty = "0"; } var grand_total = parseFloat(fourty)+parseFloat(sixty); var both_amount = $('.both_amount').val(); if(both_amount != "" && grand_total != NaN) { var tot = parseFloat(both_amount)+parseFloat(grand_total); var final_amount = tot.toFixed(2); } else if(both_amount != "") { var final_amount = both_amount.toFixed(2); } else if(grand_total != NaN) { var final_amount = grand_total.toFixed(2); } var check_content = ''; check_content += '<div class="row land_owner_a">'; check_content += '<div class="form-group col-sm-12 col-md-6">'; check_content += '<label class="col-sm-4">Cheque No</label>'; check_content += '<input type="text" class="form-control col-sm-8" name="check_no1" required="required">'; check_content += '</div>'; check_content += '<div class="form-group col-sm-12 col-md-6">'; check_content += '<label class="col-sm-4">Cheque Date</label>'; check_content += '<input type="rext" class="form-control col-sm-8 date_picker" name="check_date1" max="" required="required" readonly>'; check_content += '</div>'; check_content += '</div>'; check_content += '<div class="row land_owner_a">'; check_content += '<div class="form-group col-sm-12 col-md-6">'; check_content += '<label class="col-sm-4">Bank Name</label>'; check_content += '<input type="text" class="form-control col-sm-8" name="bank_name1" required="required" >'; check_content += '</div>'; check_content += '<div class="form-group col-sm-12 col-md-6">'; check_content += '<label class="col-sm-4">Cheque Amount</label>'; check_content += '<input type="text" value="'+final_amount+'" class="form-control col-sm-8 total_amount" name="cheque_amount" required="required">'; check_content += '</div>'; check_content += '</div>'; $("#cheque_details").html(check_content).fadeIn('slow'); $('.date_picker').datepicker({ dateFormat: 'dd-mm-yy' }); } else if(value == "Online Payment") { $("#cheque_details").empty(); $('#cash_details').empty(); var total1 = $('.total_fourty_perc').val(); if(total1 != "") { var fourty = $('.total_fourty_perc').val(); } else { var fourty = "0"; } var total2 = $('.total_sixty_perc').val(); if(total2 != "") { var sixty = $('.total_sixty_perc').val(); } else { var sixty = "0"; } var grand_total = parseFloat(fourty)+parseFloat(sixty); var both_amount = $('.both_amount').val(); if(both_amount != "" && grand_total != NaN) { var tot = parseFloat(both_amount)+parseFloat(grand_total); var final_amount = tot.toFixed(2); } else if(both_amount != "") { var final_amount = both_amount.toFixed(2); } else if(grand_total != NaN) { var final_amount = grand_total.toFixed(2); } var payment_content = ''; payment_content += '<div class="row land_owner_a">'; payment_content += '<div class="form-group col-sm-12 col-md-6">'; payment_content += '<label class="col-sm-4">UTR No</label>'; payment_content += '<input type="text" class="form-control col-sm-8" name="vtr_no1">'; payment_content += '</div>'; payment_content += '<div class="form-group col-sm-12 col-md-6">'; payment_content += '<label class="col-sm-4">Date</label>'; payment_content += '<input type="text" class="form-control col-sm-8 date_picker" name="online_date1" max="" readonly>'; payment_content += '</div>'; payment_content += '</div>'; payment_content += '<div class="row land_owner_a">'; payment_content += '<div class="form-group col-sm-12 col-md-6">'; payment_content += '<label class="col-sm-4">Cheque No</label>'; payment_content += '<input type="text" class="form-control col-sm-8" name="neft_cheque" >'; payment_content += '</div>'; payment_content += '<div class="form-group col-sm-12 col-md-6">'; payment_content += '<label class="col-sm-4">Cheque Amount</label>'; payment_content += '<input type="text" value="'+final_amount+'" class="form-control col-sm-8 neft_cheque_amt" name="neft_cheque_amt">'; payment_content += '</div>'; payment_content += '</div>'; payment_content += '<div class="row land_owner_a">'; payment_content += '<div class="form-group col-sm-12 col-md-6">'; payment_content += '<label class="col-sm-4">Cheque Date</label>'; payment_content += '<input type="text" class="form-control col-sm-8 date_picker" name="neft_cheque_date" max="" readonly>'; payment_content += '</div>'; payment_content += '</div>'; $("#neft_details").html(payment_content).fadeIn('slow'); $('.date_picker').datepicker({ dateFormat: 'dd-mm-yy' }); } else if(value == "Cash") { var total1 = $('.total_fourty_perc').val(); if(total1 != "") { var fourty = $('.total_fourty_perc').val(); } else { var fourty = "0"; } var total2 = $('.total_sixty_perc').val(); if(total2 != "") { var sixty = $('.total_sixty_perc').val(); } else { var sixty = "0"; } var grand_total = parseFloat(fourty)+parseFloat(sixty); var both_amount = $('.both_amount').val(); if(both_amount != "" && grand_total != NaN) { var tot = parseFloat(both_amount)+parseFloat(grand_total); var final_amount = tot.toFixed(2); } else if(both_amount != "") { var final_amount = both_amount.toFixed(2); } else if(grand_total != NaN) { var final_amount = grand_total.toFixed(2); } var cash_content = ''; cash_content += '<div class="row land_owner_a">'; cash_content += '<div class="form-group col-sm-12 col-md-6">'; cash_content += '<label class="col-sm-4">Cash Amount</label>'; cash_content += '<input type="text" value="'+final_amount+'" class="form-control col-sm-8" name="cash_amount" required="required">'; cash_content += '</div>'; cash_content += '<div class="form-group col-sm-12 col-md-6">'; cash_content += '<label class="col-sm-4">Cash Date</label>'; cash_content += '<input type="rext" class="form-control col-sm-8 date_picker" name="cash_date" max="" readonly required="required">'; cash_content += '</div>'; cash_content += '</div>'; $("#neft_details").empty(); $("#cheque_details").empty(); $('#cash_details').html(cash_content).fadeIn('slow'); $('.date_picker').datepicker({ dateFormat: 'dd-mm-yy' }); } else { $("#cheque_details").empty(); $("#neft_details").empty(); $('#cash_details').empty(); } }); $('input[name=incentive_type').change(function() { var value = $( 'input[name=incentive_type]:checked' ).val(); if(value == "Executives") { $('.div_executives').show(); $('.div_logistic').hide(); $('.shared_to_log_list').hide(); $('.selected_log_list').hide(); $('.incentive_log_list').hide(); $('.pending_log_list').hide(); $('.show-logistic').hide(); $('.shared_to_list').show(); $('.selected_list').show(); $('.incentive_list').show(); $('.pending_list').show(); $('.paid_pending_list').show(); //$('.show-executive').show(); } else { $('.div_logistic').show(); $('.div_executives').hide(); $('.shared_to_list').hide(); $('.selected_list').hide(); $('.incentive_list').hide(); $('.pending_list').hide(); $('.paid_pending_list').hide(); $('.show-executive').hide(); $('.shared_to_log_list').show(); $('.selected_log_list').show(); $('.incentive_log_list').show(); $('.pending_log_list').show(); // $('.show-logistic').show(); } }); $('.executive_form').submit(function(e){ var value = $( 'input[name=incentive_type]:checked' ).val(); if(value == "Executives") { $('.div_executives').show(); $('.div_logistic').hide(); $('.shared_to_log_list').hide(); $('.selected_log_list').hide(); $('.incentive_log_list').hide(); $('.pending_log_list').hide(); $('.show-logistic').hide(); $('.shared_to_list').show(); $('.selected_list').show(); $('.incentive_list').show(); $('.pending_list').show(); $('.paid_pending_list').show(); //$('.show-executive').show(); } else { $('.div_logistic').show(); $('.div_executives').hide(); $('.shared_to_list').hide(); $('.selected_list').hide(); $('.incentive_list').hide(); $('.pending_list').hide(); $('.paid_pending_list').hide(); $('.show-executive').hide(); $('.shared_to_log_list').show(); $('.selected_log_list').show(); $('.incentive_log_list').show(); $('.pending_log_list').show(); // $('.show-logistic').show(); } e.preventDefault(); var reference= $("select[name=reference]").val(); $('.fourty_broker_id').val(reference); var from_date= $("input[name=from_date]").val(); var to_date= $("input[name=to_date]").val(); load_date_grid(); function load_date_grid() { $("#list1").setGridParam( { url:"<?php echo site_url('shared-to-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list1").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list1").jqGrid({ url:"<?php echo site_url('shared-to-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','','Booking Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Executive','','Booking Status','','','','Share Between','Amount','Percentage','40% Insentive','60% Insentive','Balance','Source','Edit'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'broker_id',index:'broker_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, //{name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'tsv',index:'tsv', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'associate_broker_id',index:'associate_broker_id', hidden:true,width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_percent',index:'incentive_percent',hidden:true, width:150,editable:false}, {name:'incentive_rupees',index:'incentive_rupees',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive', width:150,editable:false}, {name:'shared_executive_amount',index:'shared_executive_amount', width:150,editable:false}, {name:'shared_executive_percentage',index:'shared_executive_percentage', width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, // {name:'balance',index:'balance', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return 'onclick="edit_shared_between('+rawObject.tsv+','+rawObject.broker_id+','+rawObject.booking_id+','+rawObject.incentive_percent+','+rawObject.incentive_rupees+')";' },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='Edit'>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager1", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"Shared Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list1").jqGrid('getCol','dimension',false,'sum'); //$('.total_sqft').val(sumOfdimension.toFixed(2)); $('.total_sqft_added').val(sumOfdimension.toFixed(2)); var rows = $("#list1").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list1").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list1").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; //$('#jqg_list1_'+abc).attr("disabled", true); //$('#jqg_list1_'+abc).addClass("ui-state-disabled"); $("#list1").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); //$("#jqg_"+abc, "#list4").attr("disabled",true); // $("#rowid"+ " #jqg_"+abc, '#list4').attr("readonly",true); } var incentive_status = $("#list1").getCell(rows[i],"incentive_status"); if(incentive_status == 'YES') { var abc = parseInt(i)+1; //$('#jqg_list1_'+abc).attr("disabled", true); //$('#jqg_list1_'+abc).addClass("ui-state-disabled"); $("#list1").jqGrid('setRowData',rows[i],false, { background:'#ece6e6'}); } var shared_between_executive = $("#list1").getCell(rows[i],"shared_between_executive"); if(shared_between_executive != '') { /*var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ $("#list1").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, }); $("#list1").jqGrid("setLabel", "rn", "SL"); $("#list1").jqGrid('filterToolbar',{searchOperators : false}); $("#list1").jqGrid('navGrid','#pager1', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list1").navButtonAdd('#pager1', { caption:"Export", buttonicon:"", onClickButton: export_shared_insentives, position: "last", title:"", cursor: "pointer", id:"export_shared_insentives" } ); function export_shared_insentives() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('shared-to-executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>TSV</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>Share Between</th><th>Amount</th><th>Percentage</th><th>40% Insentive</th><th>60% Insentive</th><th>Balance</th><th>Source</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.tsv+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.shared_between_executive+'</td><td>'+va.shared_executive_amount+'</td><td>'+va.shared_executive_percentage+'</td><td>'+va.incentive_on_agmnt+'</td><td>'+va.incentive_on_regn+'</td><td>'+va.balance+'</td><td>'+va.source+'</td></tr>'; count++; }); $('#incentive_shared_export_table').html(content); export_shared(); } }); } function export_shared() { $("#incentive_shared_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Shared Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } var admin_id = $('.admin_id').val(); var user_type_id = $('.user_type_id').val(); if(admin_id == 18 && user_type_id == 1) { load_date_grid1(); function load_date_grid1() { $("#list3").setGridParam( { url:"<?php echo site_url('selected-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list3").jqGrid({ url:"<?php echo site_url('selected-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Calculation','Insentive Type','Executive','Booking Status','','','','40% Insentive','60% Insentive','Balance','Source','Edit','Delete'], colModel:[ {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc_sixty != "60%") { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' disabled>Add Calculation</button>'; } else { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' >Add Calculation</button>'; } } else { var retVal = '<button type="button" disabled>Calculation Done</button>'; } return retVal; }}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc_sixty != "60%") { var retVal = rowObject.insentive_perc; } else { var retVal = rowObject.insentive_perc; } return retVal; }}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, //{name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = '<button type="button" class="btn btn-default btn-sm edit_calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' perc_type='+rowObject.insentive_perc+'>Edit</button>'; return retVal; }}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return "onclick='fun_delete_exe("+rawObject.booking_id+") ';" },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE'>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, multiselect: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } if(rd.shared_between_executive != "") { return { "class": "rowClass" }; } }, loadonce:true, caption:"40% Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list3").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list3").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list3").getCell(rows[i],"booking_status"); $("#list3").jqGrid('setCell',rows[i],"incentive_on_agmnt","",{'color':'#008000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"balance","",{'color':'#FF0000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"amount_tobe_paid","",{'color':'#FF0000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"incentive_on_regn","",{'color':'#FF0000', 'background-image':'none'}); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list3").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list3_'+abc).attr("disabled", true); $('#jqg_list3_'+abc).addClass("ui-state-disabled"); $("#list3").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var balance = $("#list3").getCell(rows[i],"selected_incentive_status"); if(balance == 'YES') { var abc = parseInt(i)+1; $('#jqg_list3_'+abc).attr("disabled", true); $('#jqg_list3_'+abc).addClass("ui-state-disabled"); $("#list3").jqGrid('setRowData',rows[i],false, { background:"#ffc7e3"}); } } $('.cancelled').val(dimensions); }, /* gridComplete: function() { var recs = parseInt($("#list3").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_selected(); } else { hide_incentive(); } },*/ onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list3").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list3").jqGrid('getGridParam','selrow'); fourty_changefunction(id); } }, }); //$('.get_site_grid').show(); $("#list3").jqGrid("setLabel", "rn", "SL"); $("#list3").jqGrid('filterToolbar',{searchOperators : false}); $("#list3").jqGrid('navGrid','#pager3', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); load_date_grid20(); function load_date_grid20() { $("#list20").setGridParam( { url:"<?php echo site_url('sixty-perc-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list20").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list20").jqGrid({ url:"<?php echo site_url('sixty-perc-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Calculation','Insentive Type','Executive','Booking Status','','','','40% Insentive','60% Insentive','Balance','Source','Edit','Delete'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc != "40%") { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' disabled>Add Calculation</button>'; } else { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+'>Add Calculation</button>'; } } else { var retVal = '<button type="button" disabled>Calculation Done</button>'; } return retVal; }}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc != "40%") { var retVal = rowObject.insentive_perc_sixty; } else { var retVal = rowObject.insentive_perc_sixty; } return retVal; }}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, //{name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = '<button type="button" class="btn btn-default btn-sm edit_calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' perc_type='+rowObject.insentive_perc_sixty+'>Edit</button>'; return retVal; }}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return "onclick='fun_delete_exe("+rawObject.booking_id+") ';" },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE'>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager20", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: hide_selected, multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } if(rd.shared_between_executive != "") { return { "class": "rowClass" }; } }, loadonce:true, caption:"60% Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list20").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list20").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { $("#list20").jqGrid('setCell',rows[i],"incentive_on_regn","",{'color':'#008000', 'background-image':'none'}); var status = $("#list20").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list20").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list3_'+abc).attr("disabled", true); $('#jqg_list3_'+abc).addClass("ui-state-disabled"); $("#list20").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var balance = $("#list20").getCell(rows[i],"selected_incentive_status"); if(balance == 'YES') { var abc = parseInt(i)+1; $('#jqg_list20_'+abc).attr("disabled", true); $('#jqg_list20_'+abc).addClass("ui-state-disabled"); $("#list20").jqGrid('setRowData',rows[i],false, { background:"#ffc7e3"}); } } $('.cancelled').val(dimensions); }, /* gridComplete: function() { var recs = parseInt($("#list20").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_selected(); } else { hide_incentive(); } },*/ onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list20").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list20").jqGrid('getGridParam','selrow'); sixty_changefunction(id); } }, }); //$('.get_site_grid').show(); $("#list20").jqGrid("setLabel", "rn", "SL"); $("#list20").jqGrid('filterToolbar',{searchOperators : false}); $("#list20").jqGrid('navGrid','#pager20', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); } else { load_date_grid2(); function load_date_grid2() { $("#list3").setGridParam( { url:"<?php echo site_url('selected-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list3").jqGrid({ url:"<?php echo site_url('selected-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Calculation','Incentive Type','Executive','Booking Status','','','','40% Insentive','60% Insentive','Balance','Source'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc_sixty != "60%") { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' disabled>Add Calculation</button>'; } else { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+'>Add Calculation</button>'; } } else { var retVal = '<button type="button" disabled>Calculation Done</button>'; } return retVal; }}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc_sixty != "60%") { var retVal = rowObject.insentive_perc; } else { var retVal = rowObject.insentive_perc; } return retVal; }}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, // {name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager3", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: hide_selected, multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } if(rd.shared_between_executive != "") { return { "class": "rowClass" }; } }, loadonce:true, caption:"40% Incentive Details", footerrow: true, loadComplete: function () { $("#list3").jqGrid('setCell',rows[i],"incentive_on_agmnt","",{'color':'#008000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"balance","",{'color':'#FF0000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"amount_tobe_paid","",{'color':'#FF0000', 'background-image':'none'}); $("#list3").jqGrid('setCell',rows[i],"incentive_on_regn","",{'color':'#FF0000', 'background-image':'none'}); var sumOfdimension = jQuery("#list3").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list3").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list3").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list3").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list3_'+abc).attr("disabled", true); $('#jqg_list3_'+abc).addClass("ui-state-disabled"); $("#list3").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } } $('.cancelled').val(dimensions); }, /*gridComplete: function() { var recs = parseInt($("#list3").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_selected(); } else { hide_incentive(); } },*/ onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list3").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list3").jqGrid('getGridParam','selrow'); fourty_changefunction(id); } }, }); //$('.get_site_grid').show(); $("#list3").jqGrid("setLabel", "rn", "SL"); $("#list3").jqGrid('filterToolbar',{searchOperators : false}); $("#list3").jqGrid('navGrid','#pager3', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); load_date_grid20(); function load_date_grid20() { $("#list20").setGridParam( { url:"<?php echo site_url('sixty-perc-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list20").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list20").jqGrid({ url:"<?php echo site_url('sixty-perc-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Calculation','Incentive Type','Executive','Booking Status','','','','40% Insentive','60% Insentive','Balance','Source'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc != "40%") { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' disabled>Add Calculation</button>'; } else { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+'>Add Calculation</button>'; } } else { var retVal = '<button type="button" disabled>Calculation Done</button>'; } return retVal; }}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc != "40%") { var retVal = rowObject.insentive_perc_sixty; } else { var retVal = rowObject.insentive_perc_sixty; } return retVal; }}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, //{name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager20", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: hide_selected, multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } if(rd.shared_between_executive != "") { return { "class": "rowClass" }; } }, loadonce:true, caption:"60% Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list20").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list20").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list20").getCell(rows[i],"booking_status"); $("#list20").jqGrid('setCell',rows[i],"incentive_on_regn","",{'color':'#008000', 'background-image':'none'}); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list20").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list3_'+abc).attr("disabled", true); $('#jqg_list3_'+abc).addClass("ui-state-disabled"); $("#list20").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } } $('.cancelled').val(dimensions); }, /* gridComplete: function() { var recs = parseInt($("#list20").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_selected(); } else { hide_incentive(); } },*/ onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list20").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list20").jqGrid('getGridParam','selrow'); sixty_changefunction(id); } }, }); //$('.get_site_grid').show(); $("#list20").jqGrid("setLabel", "rn", "SL"); $("#list20").jqGrid('filterToolbar',{searchOperators : false}); $("#list20").jqGrid('navGrid','#pager20', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); } $("#list3").navButtonAdd('#pager3', { caption:"Export", buttonicon:"", onClickButton: export_selected_insentives, position: "last", title:"", cursor: "pointer", id:"export_selected_insentives" } ); $("#list20").navButtonAdd('#pager20', { caption:"Export", buttonicon:"", onClickButton: sixty_selected_insentives, position: "last", title:"", cursor: "pointer", id:"export_selected_insentives" } ); function export_selected_insentives() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('selected-executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { // response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>40% Insentive</th><th>60% Insentive</th><th>Balance</th><th>Source</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.incentive_on_agmnt+'</td><td>'+va.incentive_on_regn+'</td><td>'+va.balance+'</td><td>'+va.source+'</td></tr>'; count++; }); $('#incentive_selected_export_table').html(content); export_selected(); } }); } function export_selected() { $("#incentive_selected_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "40% Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } function sixty_selected_insentives() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('sixty-perc-executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { // response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>40% Insentive</th><th>60% Insentive</th><th>Balance</th><th>Source</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.incentive_on_agmnt+'</td><td>'+va.incentive_on_regn+'</td><td>'+va.balance+'</td><td>'+va.source+'</td></tr>'; count++; }); $('#60_selected_export_table').html(content); sixty_export_selected(); } }); } function sixty_export_selected() { $("#60_selected_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "60% Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } //----------------------------------------------------------------------------------------------// load_date_grid13(); function load_date_grid13() { $("#list4").setGridParam( { url:"<?php echo site_url('executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list4").jqGrid({ url:"<?php echo site_url('executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','','Booking Date','Cancelled Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Executive','Booking Status','','','','Share Between','40% Insentive','60% Insentive','Balance','Source',''], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'broker_id',index:'broker_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'tsv',index:'tsv', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_percent',index:'incentive_percent',hidden:true, width:150,editable:false}, {name:'incentive_rupees',index:'incentive_rupees',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive', width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, // {name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false,color:'red'}, {name:'source',index:'source', width:150,editable:false}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:false, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="shared_exe_between('+rawObject.tsv+','+rawObject.broker_id+','+rawObject.booking_id+','+rawObject.incentive_percent+','+rawObject.incentive_rupees+')" '; },formatter:function (cellvalue, options, rowObject) { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { return "<input type='button' value='Shared Between' disabled='disabled'\>"; } else { return "<input type='button' value='Shared Between' \>"; } }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager4", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, // multiselect: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"100% Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list4").jqGrid('getCol','dimension',false,'sum'); //$('.total_sqft').val(sumOfdimension.toFixed(2)); $('.total_sqft_incentive_added').val(sumOfdimension.toFixed(2)); var rows = $("#list4").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list4").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list4").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list4_'+abc).attr("disabled", true); $('#jqg_list4_'+abc).addClass("ui-state-disabled"); $("#list4").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); //$("#jqg_"+abc, "#list4").attr("disabled",true); // $("#rowid"+ " #jqg_"+abc, '#list4').attr("readonly",true); } var incentive_status = $("#list4").getCell(rows[i],"incentive_status"); if(incentive_status == 'YES') { /* var abc = parseInt(i)+1; $('#jqg_list4_'+abc).attr("disabled", true); $('#jqg_list4_'+abc).addClass("ui-state-disabled");*/ $("#list4").jqGrid('setRowData',rows[i],false, { background:'#ece6e6'}); } var shared_between_executive = $("#list4").getCell(rows[i],"shared_between_executive"); if(shared_between_executive != '') { /*var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ $("#list4").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, }); $('.get_site_grid').show(); $("#list4").jqGrid("setLabel", "rn", "SL"); $("#list4").jqGrid('filterToolbar',{searchOperators : false}); $("#list4").jqGrid('navGrid','#pager4', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list4").navButtonAdd('#pager4', { caption:"Export", buttonicon:"", onClickButton: export_insentive_details, position: "last", title:"", cursor: "pointer", id:"export_insentive_details" } ); function export_insentive_details() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Cancelled date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>TSV</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>Share Between</th><th>Amount</th><th>Percentage</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.cancelled_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.tsv+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.shared_between_executive+'</td><td>'+va.shared_executive_amount+'</td><td>'+va.shared_executive_percentage+'</td></tr>'; count++; }); $('#insentive_details_export_table').html(content); export_incentive_details(); } }); } function export_incentive_details() { $("#insentive_details_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } load_date_grid3(); function load_date_grid3() { $("#list5").setGridParam( { url:"<?php echo site_url('pending-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list5").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list5").jqGrid({ url:"<?php echo site_url('pending-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", //colNames:['SI','','','','Booking Date','Cancelled Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Calculation','Executive','Booking Status','','','','Share Between','Amount','Percentage','Shared With','40% Insentive','60% Insentive','Amount to be paid','Balance','Source'], colNames:['SI','','','','Booking Date','Cancelled Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Calculation','Insentive Type','Executive','Booking Status','','','','Share Between','Shared With','40% Insentive','60% Insentive','Balance','Source'], colModel:[ {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'broker_id',index:'broker_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'tsv',index:'tsv', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' disabled>Add Calculation</button>'; } else { var retVal = '<button type="button" class="btn btn-default btn-sm calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+'>Add Calculation</button>'; } return retVal; }}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = ""; if(rowObject.insentive_perc == "" && rowObject.insentive_perc_sixty != "") { var retVal = "40%"; } else if(rowObject.insentive_perc != "" && rowObject.insentive_perc_sixty == "") { var retVal = "60%"; } else if(rowObject.insentive_perc == "" && rowObject.insentive_perc_sixty == "" && rowObject.insentive_perc_sixty != "") { var retVal = ""; } return retVal; }}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_percent',index:'incentive_percent',hidden:true, width:150,editable:false}, {name:'incentive_rupees',index:'incentive_rupees',hidden:true, width:150,editable:false}, {name:'shared_between_executive',index:'shared_between_executive', width:150,editable:false}, // {name:'shared_executive_amount',index:'shared_executive_amount', width:150,editable:false}, // {name:'shared_executive_percentage',index:'shared_executive_percentage', width:150,editable:false}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:false, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="shared_exe_between('+rawObject.tsv+','+rawObject.broker_id+','+rawObject.booking_id+','+rawObject.incentive_percent+','+rawObject.incentive_rupees+')" '; },formatter:function (cellvalue, options, rowObject) { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { return "<input type='button' value='Shared Between' disabled='disabled'\>"; } else { return "<input type='button' value='Shared Between' \>"; } }}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, //{name:'balance',index:'balance', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false}, {name:'source',index:'source', width:150,editable:false}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager5", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, multiselect: true, rowattr: function (rd) { $(this).val(); if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, // multiboxonly: true, loadonce:true, caption:"Pending Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list5").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list5").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list5").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list5").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list5_'+abc).attr("disabled", true); $('#jqg_list5_'+abc).addClass("ui-state-disabled"); $("#list5").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var incentive_status = $("#list5").getCell(rows[i],"incentive_status"); if(incentive_status == 'YES') { var abc = parseInt(i)+1; $('#jqg_list5_'+abc).attr("disabled", true); $('#jqg_list5_'+abc).addClass("ui-state-disabled"); $("#list5").jqGrid('setRowData',rows[i],false, { background:'#ece6e6'}); } var shared_between_executive = $("#list5").getCell(rows[i],"shared_between_executive"); if(shared_between_executive != '') { $("#list5").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list5").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list5").jqGrid('getGridParam','selrow'); changefunction(id); } }, }); $('.get_site_grid_pending').show(); $("#list5").jqGrid("setLabel", "rn", "SL"); $("#list5").jqGrid('filterToolbar',{searchOperators : false}); $("#list5").jqGrid('navGrid','#pager5', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list5").navButtonAdd('#pager5', { caption:"Export", buttonicon:"", onClickButton: export_pending_insentives, position: "last", title:"", cursor: "pointer", id:"export_pending_insentives" } ); function changefunction(cellValues1) { id = jQuery("#list5").jqGrid('getGridParam','selarrrow'); var $grid = $("#list5"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n; cellValues2 = []; cellValues3 = []; for (i = 0, n = selIds.length; i < n; i++) { cellValues2.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "site_number")); } $('.project_id').val(cellValues2); $('.site_number').val(cellValues3); $('.status_booking_id').val(id); } function fourty_changefunction(cellValues1) { $('.fourty_status').val('fourty'); id = jQuery("#list3").jqGrid('getGridParam','selarrrow'); $('.fourty_booking_id').val(id); var $grid = $("#list3"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n; cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var total_fourty_perc = 0; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "incentive_on_agmnt")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "broker_id")); } $('.fourty_project_id').val(cellValues2); $('.fourty_site_number').val(cellValues3); //$('.fourty_broker_id').val(cellValues4); $.ajax({ type : 'post', url : '<?php echo site_url("get-fourty-percentage-total-amount")?>', data : {'fourty_amount':cellValues1}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { if(response.fourty_percent_amount !="0") { $('.total_fourty_perc_div').hide(); $('.total_fourty_perc_div').show(); $('.total_fourty_perc').empty(); $('.total_fourty_perc').val(response.fourty_percent_amount.toFixed(2)); } else { $('.total_fourty_perc').val(0); $('.total_fourty_perc_div').hide(); } } else { $('.total_fourty_perc').val(0); $('.total_fourty_perc_div').hide(); } } }); } function sixty_changefunction(cellValues1) { $('.sixty_status').val('sixty'); id = jQuery("#list20").jqGrid('getGridParam','selarrrow'); $('.sixty_booking_id').val(id); var $grid = $("#list20"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; for (i = 0, n = selIds.length; i < n; i++) { var total_sixty_percentage = []; cellValues1.push($grid.jqGrid("getCell", selIds[i], "incentive_on_regn")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "broker_id")); } //alert(cellValues1); $('.sixty_project_id').val(cellValues2); $('.sixty_site_number').val(cellValues3); $('.sixty_broker_id').val(cellValues4); // var sixty_amount = 0; // for (i = 0; i < cellValues1.length;i++) // { // sixty_amount = sixty_amount + parseFloat(cellValues1[i]); // // alert(parseFloat(cellValues1[i])); // // alert(sixty_amount); // } // if(sixty_amount == 0){ // $('.total_sixty_perc').val(0); // $('.total_sixty_perc_div').hide(); // } // else{ // $('.total_sixty_perc_div').hide(); // $('.total_sixty_perc_div').show(); // $('.total_sixty_perc').empty(); // $('.total_sixty_perc').val(sixty_amount); // } $.ajax({ type : 'post', url : '<?php echo site_url("get-sixty-percentage-total-amount")?>', data : {'sixty_amount':cellValues1}, success:function(response) { console.log(response); //return; //response=jQuery.parseJSON(response); if(response.result == 1) { if(response.sixty_percent_amount !="0") { $('.total_sixty_perc_div').hide(); $('.total_sixty_perc_div').show(); $('.total_sixty_perc').empty(); $('.total_sixty_perc').val(response.sixty_percent_amount.toFixed(2)); } else { $('.total_sixty_perc').val(0); $('.total_sixty_perc_div').hide(); } } else { $('.total_sixty_perc').val(0); $('.total_sixty_perc_div').hide(); } } }); } function both_changefunction(cellValues1) { $('.both_status').val('both'); id = jQuery("#list9").jqGrid('getGridParam','selarrrow'); $('.both_booking_id').val(id); $('.grand_total_div').show(); var $grid = $("#list9"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n; cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var total_fourty_perc = 0; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "incentive_on_agmnt")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "incentive_on_regn")); } $('.both_project_id').val(cellValues2); $('.both_site_number').val(cellValues3); $.ajax({ type : 'post', url : '<?php echo site_url("get-both-total-amount")?>', data : {'fourty_amount':cellValues1,'sixty_amount':cellValues4}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { if(response.both_amount !="" || response.both_amount !=NaN) { $('.both_amount').val(response.both_amount.toFixed(2)); } else { $('.both_amount').val(0); } } else { $('.both_amount').val(0); } } }); } function export_pending_insentives() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('pending-executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Cancelled date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>TSV</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>Share Between</th><th>Amount</th><th>Percentage</th><th>40% Insentive</th><th>60% Insentive</th><th>Balance</th><th>Source</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.cancelled_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.tsv+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.shared_between_executive+'</td><td>'+va.shared_executive_amount+'</td><td>'+va.shared_executive_percentage+'</td><td>'+va.incentive_on_agmnt+'</td><td>'+va.incentive_on_regn+'</td><td>'+va.balance+'</td><td>'+va.source+'</td></tr>'; count++; }); $('#pending_insentive_export_table').html(content); export_pending(); } }); } function export_pending() { $("#pending_insentive_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Pending Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } //---------------------------paid pending insentive---------------------------------------------------// load_date_grid4(); function load_date_grid4() { $("#list9").setGridParam( { url:"<?php echo site_url('paidpending-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list9").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list9").jqGrid({ url:"<?php echo site_url('paidpending-executive-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','','Booking Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Executive','Booking Status','','','','40% Insentive','60% Insentive','Balance','Source','Edit','','Delete'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false,key:true}, {name:'broker_id',index:'broker_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'tsv',index:'tsv', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_percent',index:'incentive_percent',hidden:true, width:150,editable:false}, {name:'incentive_rupees',index:'incentive_rupees',hidden:true, width:150,editable:false}, {name:'incentive_on_agmnt',index:'incentive_on_agmnt', width:150,editable:false}, {name:'incentive_on_regn',index:'incentive_on_regn', width:150,editable:false}, // {name:'amount_tobe_paid',index:'amount_tobe_paid', width:150,editable:false}, {name:'balance',index:'balance', width:150,editable:false,color:'red'}, {name:'source',index:'source', width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status', width:150,editable:false,hidden:true}, {name:'',index:'', search:false, width:240, editable:false,formatter: function (cellvalue, options, rowObject) { var retVal = '<button type="button" class="btn btn-default btn-sm edit_calc_btn" webportal="'+rowObject.webportal+'" dim='+rowObject.dimension+' booking_id='+rowObject.booking_id+' perc_type='+rowObject.balance+'>Edit</button>'; return retVal; }}, {name:'',index:'',align: "center",editable:false,search:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return "onclick='fun_delete_exe("+rawObject.booking_id+") ';" },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE'>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager9", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, multiselect: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, // multiboxonly: true, loadonce:true, caption:"Both Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list9").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list9").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { // $("#list9").jqGrid('setRowData',rows[i],false, { color:'#f3f098'}); $("#list9").jqGrid('setCell',rows[i],"incentive_on_agmnt","",{'color':'green', 'background-image':'none'}); $("#list9").jqGrid('setCell',rows[i],"incentive_on_regn","",{'color':'green', 'background-image':'none'}); $("#list9").jqGrid('setCell',rows[i],"balance","",{'color':'red', 'background-image':'none'}); var status = $("#list9").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list9").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list9_'+abc).attr("disabled", true); $('#jqg_list9_'+abc).addClass("ui-state-disabled"); $("#list9").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var shared_between_executive = $("#list9").getCell(rows[i],"shared_between_executive"); if(shared_between_executive != '') { $("#list9").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } var balance = $("#list9").getCell(rows[i],"selected_incentive_status"); if(balance == 'YES') { var abc = parseInt(i)+1; $('#jqg_list9_'+abc).attr("disabled", true); $('#jqg_list9_'+abc).addClass("ui-state-disabled"); $("#list9").jqGrid('setRowData',rows[i],false, { background:"#ffc7e3"}); } } $('.cancelled').val(dimensions); }, onSelectRow: function(booking_id) { if(booking_id == null) { booking_id=0; if(jQuery("#list3").jqGrid('getGridParam','records') >0 ) { changefunction(cellValues1); } } else { var id=jQuery("#list3").jqGrid('getGridParam','selrow'); both_changefunction(id); } }, }); $('.get_site_grid_pending').show(); $("#list9").jqGrid("setLabel", "rn", "SL"); $("#list9").jqGrid('filterToolbar',{searchOperators : false}); $("#list9").jqGrid('navGrid','#pager9', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list9").navButtonAdd('#pager9', { caption:"Export", buttonicon:"", onClickButton: both_pending_insentives, position: "last", title:"", cursor: "pointer", id:"both_pending_insentives" } ); function both_pending_insentives() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=reference] option:selected").val(); $.ajax({ url:"<?php echo base_url('paidpending-executive-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Executive</th><th>40% Insentive</th><th>60% Insentive</th><th>Balance</th><th>Source</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.incentive_on_agmnt+'</td><td>'+va.incentive_on_regn+'</td><td>'+va.balance+'</td><td>'+va.source+'</td></tr>'; count++; }); $('#both_selected_export_table').html(content); both_insentives(); } }); } function both_insentives() { $("#both_selected_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Both Incentive Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } }); //---------------------------------------------------------------------------// $("input[name=calc_rate_per_sqft]").change(function(){ var total_sqft = $("input[name=calc_total_sqft]").val(); var rate_per_sqft = $(this).val(); //---------------------------------------------------------------------------// var total_amount_fixed = parseFloat(total_sqft) * parseFloat(rate_per_sqft); var total_amount_fixed_point = total_amount_fixed.toFixed(2); var total_amount_fixed2 = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount2 = ("" +total_amount_fixed2).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; $("input[name=calc_total_amount_fixed]").val(res2+'.'+total_amount_fixed_float); //--------------------------------------------------------------------------// var incentive_on_agmnt = parseFloat(total_amount_fixed) * 40/100; var incentive_on_agmnt_point = incentive_on_agmnt.toFixed(2); var incentive_on_agmnt1 = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; /*var amount = ("" +incentive_on_agmnt1).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; $("input[name=calc_incentive_on_agmnt]").val(res+'.'+incentive_on_agmnt_float);*/ $("input[name=calc_incentive_on_agmnt]").val(incentive_on_agmnt); //----------------------------------------------------------------------------// var incentive_on_regn = parseFloat(total_amount_fixed) * 60/100; var incentive_on_regn_point = incentive_on_regn.toFixed(2); var incentive_on_regn1 = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; /*var amount1 = ("" +incentive_on_regn1).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; $("input[name=calc_incentive_on_regn]").val(res1+'.'+incentive_on_regn_float);*/ $("input[name=calc_incentive_on_regn]").val(incentive_on_regn); }); $("input[name=edit_calc_rate_per_sqft]").change(function(){ var total_sqft = $("input[name=edit_calc_total_sqft]").val(); var rate_per_sqft = $(this).val(); //---------------------------------------------------------------------------// var total_amount_fixed = parseFloat(total_sqft) * parseFloat(rate_per_sqft); var total_amount_fixed_point = total_amount_fixed.toFixed(2); var total_amount_fixed2 = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount2 = ("" +total_amount_fixed2).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; $("input[name=edit_calc_total_amount_fixed]").val(res2+'.'+total_amount_fixed_float); //--------------------------------------------------------------------------// var incentive_on_agmnt = parseFloat(total_amount_fixed) * 40/100; var incentive_on_agmnt_point = incentive_on_agmnt.toFixed(2); var incentive_on_agmnt1 = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; /*var amount = ("" +incentive_on_agmnt1).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; $("input[name=calc_incentive_on_agmnt]").val(res+'.'+incentive_on_agmnt_float);*/ $("input[name=edit_calc_incentive_on_agmnt]").val(incentive_on_agmnt); //----------------------------------------------------------------------------// var incentive_on_regn = parseFloat(total_amount_fixed) * 60/100; var incentive_on_regn_point = incentive_on_regn.toFixed(2); var incentive_on_regn1 = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; /*var amount1 = ("" +incentive_on_regn1).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; $("input[name=calc_incentive_on_regn]").val(res1+'.'+incentive_on_regn_float);*/ $("input[name=edit_calc_incentive_on_regn]").val(incentive_on_regn); }); $("select[name=edit_calc_insentive_perc]").change(function(){ var insentive_perc = $(this).val(); var total_amount_fixed = $("input[name=edit_calc_total_amount_fixed]").val(); var total_amount_fixed1 = total_amount_fixed.replace(/\,/g,''); var total_amount_fixed2 = Number(total_amount_fixed1); var calc_incentive_on_agmnt = $("input[name=edit_calc_incentive_on_agmnt]").val(); var calc_incentive_on_agmnt1 = calc_incentive_on_agmnt.replace(/\,/g,''); var calc_incentive_on_agmnt2 = Number(calc_incentive_on_agmnt1); var calc_incentive_on_regn = $("input[name=edit_calc_incentive_on_regn]").val(); var calc_incentive_on_regn1 = calc_incentive_on_regn.replace(/\,/g,''); var calc_incentive_on_regn2 = Number(calc_incentive_on_regn1); if(insentive_perc == "40%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_agmnt2; } else if(insentive_perc == "60%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_regn2; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=edit_calc_balance]").val(res+'.'+balance_float); }); $("select[name=calc_insentive_perc]").change(function(){ var insentive_perc = $(this).val(); var total_amount_fixed = $("input[name=calc_total_amount_fixed]").val(); var total_amount_fixed1 = total_amount_fixed.replace(/\,/g,''); var total_amount_fixed2 = Number(total_amount_fixed1); var calc_incentive_on_agmnt = $("input[name=calc_incentive_on_agmnt]").val(); var calc_incentive_on_agmnt1 = calc_incentive_on_agmnt.replace(/\,/g,''); var calc_incentive_on_agmnt2 = Number(calc_incentive_on_agmnt1); var calc_incentive_on_regn = $("input[name=calc_incentive_on_regn]").val(); var calc_incentive_on_regn1 = calc_incentive_on_regn.replace(/\,/g,''); var calc_incentive_on_regn2 = Number(calc_incentive_on_regn1); var booking_id = $("input[name=calc_booking_id]").val(); var reference_id = $('.en_executive').val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-insentive-details")?>', data : {booking_id:booking_id,reference:reference_id}, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { if(response.executive == "executive1") { var val_balance = response.data.balance; if(val_balance == "0" || val_balance == "") { if(insentive_perc == "40%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_agmnt2; } else if(insentive_perc == "60%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_regn2; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=calc_balance]").val(res+'.'+balance_float); } else { if(insentive_perc == "40%") { var total_amt = parseFloat(response.data.incentive_on_regn)+parseFloat(calc_incentive_on_agmnt2); var balance = parseFloat(total_amount_fixed2) - total_amt; } else if(insentive_perc == "60%") { var total_amt = parseFloat(response.data.incentive_on_agmnt)+parseFloat(calc_incentive_on_regn2); var balance = parseFloat(total_amount_fixed2) - total_amt; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=calc_balance]").val(res+'.'+balance_float); } } else { var val_balance = response.data.balance2; if(val_balance == "0" || val_balance == "") { if(insentive_perc == "40%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_agmnt2; } else if(insentive_perc == "60%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_regn2; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=calc_balance]").val(res+'.'+balance_float); } else { if(insentive_perc == "40%") { var total_amt = parseFloat(response.data.incentive_on_regn2)+parseFloat(calc_incentive_on_agmnt2); var balance = parseFloat(total_amount_fixed2) - total_amt; } else if(insentive_perc == "60%") { var total_amt = parseFloat(response.data.incentive_on_agmnt2)+parseFloat(calc_incentive_on_regn2); var balance = parseFloat(total_amount_fixed2) - total_amt; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=calc_balance]").val(res+'.'+balance_float); } } } else { if(insentive_perc == "40%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_agmnt2; } else if(insentive_perc == "60%") { var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_regn2; } else { var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=calc_balance]").val(res+'.'+balance_float); } } }); }); function reset() { console.log(" button clicked!"); } $(document).on('click','.calc_btn',function(){ $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.sixty_booking_id').empty(); $('.fourty_booking_id').empty(); $('.both_booking_id').empty(); $('.sixty_booking_id').val('0'); $('.fourty_booking_id').val('0'); $('.both_booking_id').val('0'); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); var booking_id = $(this).attr('booking_id'); $("input[name=calc_booking_id]").val(booking_id); var total_sqft = $(this).attr('dim'); $("input[name=calc_total_sqft]").val(total_sqft); var reference_id = $('.en_executive').val(); $('.calc_reference').val(reference_id); $.ajax({ type : 'post', url : '<?php echo site_url("get-insentive-details")?>', data : {booking_id:booking_id,reference:reference_id}, success:function(response){ // response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); $('.sixty_booking_id').empty(); $('.fourty_booking_id').empty(); $('.both_booking_id').empty(); if(response.executive == "executive1") { $("input[name=calc_rate_per_sqft]").val(response.data.rate_per_sqft); var total_amount_fixed_point = response.data.total_amount_fixed; var total_amount_fixed = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount = ("" +total_amount_fixed).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; if(total_amount_fixed_float == undefined) { $("input[name=calc_total_amount_fixed]").val(res); } else { $("input[name=calc_total_amount_fixed]").val(res+'.'+total_amount_fixed_float); } //---------------------------------------------------------------------------------// var incentive_on_agmnt_point = response.data.incentive_on_agmnt; var incentive_on_agmnt = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; var amount1 = ("" +incentive_on_agmnt).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; if(incentive_on_agmnt_float == undefined) { $("input[name=calc_incentive_on_agmnt]").val(res1); } else { $("input[name=calc_incentive_on_agmnt]").val(res1+'.'+incentive_on_agmnt_float); } //------------------------------------------------------------------------------// var incentive_on_regn_point = response.data.incentive_on_regn; var incentive_on_regn = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; var amount2 = ("" +incentive_on_regn).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; if(incentive_on_regn_float == undefined) { $("input[name=calc_incentive_on_regn]").val(res2); } else { $("input[name=calc_incentive_on_regn]").val(res2+'.'+incentive_on_regn_float); } //----------------------------------------------------------------------------// var balance_point = response.data.balance; var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount3 = ("" +balance).replace(/,/g, ""); x3=amount3.toString(); var lastThree3 = x3.substring(x3.length-3); var otherNumbers3 = x3.substring(0,x2.length-3); if(otherNumbers3 != '') lastThree3 = ',' + lastThree3; var res3 = otherNumbers3.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree3; if(balance_float == undefined) { $("input[name=calc_balance]").val(res3); } else { $("input[name=calc_balance]").val(res3+'.'+balance_float); } //------------------------------------------------------------------------// if(response.data.balance != '0') { if(response.data.insentive_perc != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc); } else if(response.data.insentive_perc_sixty != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc_sixty); } else if(response.data.insentive_perc_both != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc_both); } } else { $("select[name=calc_insentive_perc]").val("Both"); } $("input[name=calc_source]").val(response.data.source); } else { $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); $("input[name=calc_rate_per_sqft]").val(response.data.rate_per_sqft2); var total_amount_fixed_point = response.data.total_amount_fixed2; var total_amount_fixed = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount = ("" +total_amount_fixed).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; if(total_amount_fixed_float == undefined) { $("input[name=calc_total_amount_fixed]").val(res); } else { $("input[name=calc_total_amount_fixed]").val(res+'.'+total_amount_fixed_float); } //---------------------------------------------------------------------------------// var incentive_on_agmnt_point = response.data.incentive_on_agmnt2; var incentive_on_agmnt = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; var amount1 = ("" +incentive_on_agmnt).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; if(incentive_on_agmnt_float == undefined) { $("input[name=calc_incentive_on_agmnt]").val(res1); } else { $("input[name=calc_incentive_on_agmnt]").val(res1+'.'+incentive_on_agmnt_float); } //------------------------------------------------------------------------------// var incentive_on_regn_point = response.data.incentive_on_regn2; var incentive_on_regn = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; var amount2 = ("" +incentive_on_regn).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; if(incentive_on_regn_float == undefined) { $("input[name=calc_incentive_on_regn]").val(res2); } else { $("input[name=calc_incentive_on_regn]").val(res2+'.'+incentive_on_regn_float); } //----------------------------------------------------------------------------// var balance_point = response.data.balance2; var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount3 = ("" +balance).replace(/,/g, ""); x3=amount3.toString(); var lastThree3 = x3.substring(x3.length-3); var otherNumbers3 = x3.substring(0,x2.length-3); if(otherNumbers3 != '') lastThree3 = ',' + lastThree3; var res3 = otherNumbers3.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree3; if(balance_float == undefined) { $("input[name=calc_balance]").val(res3); } else { $("input[name=calc_balance]").val(res3+'.'+balance_float); } //------------------------------------------------------------------------// if(response.data.balance2 != '0') { if(response.data.insentive_perc2 != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc2); } else if(response.data.insentive_perc_sixty2 != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc_sixty2); } else if(response.data.insentive_perc_both2 != "") { $("select[name=calc_insentive_perc]").val(response.data.insentive_perc_both2); } } else { $("select[name=calc_insentive_perc]").val("Both"); } $("input[name=calc_source]").val(response.data.source2); } } else { $("input[name=calc_rate_per_sqft]").val(""); $("input[name=calc_total_amount_fixed]").val(""); $("input[name=calc_incentive_on_agmnt]").val(""); $("input[name=calc_incentive_on_regn]").val(""); $("select[name=calc_insentive_perc]").val(""); $("input[name=calc_balance]").val(""); $("input[name=calc_source]").val(""); } } }); $("#calc_model").modal('show'); }); $(document).on('click','.paidcalc_btn',function(){ var booking_id = $(this).attr('booking_id'); $("input[name=paidcalc_booking_id]").val(booking_id); var total_sqft = $(this).attr('dim'); $("input[name=paidcalc_total_sqft]").val(total_sqft); $.ajax({ type : 'post', url : '<?php echo site_url("get-insentive-details")?>', data : {booking_id:booking_id}, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { var paid_insentive = response.data.insentive_perc; $("input[name=paidcalc_rate_per_sqft]").val(response.data.rate_per_sqft); var total_amount_fixed_point = response.data.total_amount_fixed; var total_amount_fixed = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount = ("" +total_amount_fixed).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; if(total_amount_fixed_float == undefined) { $("input[name=paidcalc_total_amount_fixed]").val(res); } else { $("input[name=paidcalc_total_amount_fixed]").val(res+'.'+total_amount_fixed_float); } //---------------------------------------------------------------------------------// var incentive_on_agmnt_point = response.data.incentive_on_agmnt; var incentive_on_agmnt = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; var amount1 = ("" +incentive_on_agmnt).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; if(incentive_on_agmnt_float == undefined) { $("input[name=paidcalc_incentive_on_agmnt]").val(res1); } else { $("input[name=paidcalc_incentive_on_agmnt]").val(res1+'.'+incentive_on_agmnt_float); } //------------------------------------------------------------------------------// var incentive_on_regn_point = response.data.incentive_on_regn; var incentive_on_regn = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; var amount2 = ("" +incentive_on_regn).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; if(incentive_on_regn_float == undefined) { $("input[name=paidcalc_incentive_on_regn]").val(res2); } else { $("input[name=paidcalc_incentive_on_regn]").val(res2+'.'+incentive_on_regn_float); } //----------------------------------------------------------------------------// var balance_point = response.data.balance; var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount3 = ("" +balance).replace(/,/g, ""); x3=amount3.toString(); var lastThree3 = x3.substring(x3.length-3); var otherNumbers3 = x3.substring(0,x2.length-3); if(otherNumbers3 != '') lastThree3 = ',' + lastThree3; var res3 = otherNumbers3.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree3; if(balance_float == undefined) { $("input[name=paidcalc_balance]").val(res3); } else { $("input[name=paidcalc_balance]").val(res3+'.'+balance_float); } //------------------------------------------------------------------------// if(response.data.insentive_perc != "") { $("select[name=paidcalc_insentive_perc]").val(response.data.insentive_perc); } else if(response.data.insentive_perc_sixty != "") { $("select[name=paidcalc_insentive_perc]").val(response.data.insentive_perc_sixty); } else if(response.data.insentive_perc_both != "") { $("select[name=paidcalc_insentive_perc]").val(response.data.insentive_perc_both); } $("input[name=paidcalc_source]").val(response.data.source); } else { $("input[name=paidcalc_rate_per_sqft]").val(""); $("input[name=paidcalc_total_amount_fixed]").val(""); $("input[name=paidcalc_incentive_on_agmnt]").val(""); $("input[name=paidcalc_incentive_on_regn]").val(""); $("select[name=paidcalc_insentive_perc]").val(""); $("input[name=paidcalc_balance]").val(""); $("input[name=paidcalc_source]").val(""); } } }); $("#paidcalc_model").modal('show'); }); $("select[name=paidcalc_insentive_perc]").change(function(){ var booking_id = $("input[name=paidcalc_booking_id]").val(); var insentive_perc = $(this).val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-insentive-details")?>', data : {booking_id:booking_id}, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { var total_amount_fixed = $("input[name=paidcalc_total_amount_fixed]").val(); var total_amount_fixed1 = total_amount_fixed.replace(/\,/g,''); var total_amount_fixed2 = Number(total_amount_fixed1); var calc_incentive_on_agmnt = $("input[name=paidcalc_incentive_on_agmnt]").val(); var calc_incentive_on_agmnt1 = calc_incentive_on_agmnt.replace(/\,/g,''); var calc_incentive_on_agmnt2 = Number(calc_incentive_on_agmnt1); var calc_incentive_on_regn = $("input[name=paidcalc_incentive_on_regn]").val(); var calc_incentive_on_regn1 = calc_incentive_on_regn.replace(/\,/g,''); var calc_incentive_on_regn2 = Number(calc_incentive_on_regn1); if(response.data.insentive_perc == "") { //var value = parseFloat(calc_incentive_on_agmnt2) + parseFloat(calc_incentive_on_regn2); var balance = 0.0; } else if(response.data.insentive_perc_sixty == "") { // var value = parseFloat(calc_incentive_on_agmnt2) + parseFloat(calc_incentive_on_regn2); var balance = 0.0; } var balance_point = balance.toFixed(2); var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount = ("" +balance).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; var balance = $("input[name=paidcalc_balance]").val(res+'.'+balance_float); } } }); // var insentive_perc = $(this).val(); // var total_amount_fixed = $("input[name=paidcalc_total_amount_fixed]").val(); // var total_amount_fixed1 = total_amount_fixed.replace(/\,/g,''); // var total_amount_fixed2 = Number(total_amount_fixed1); // var calc_incentive_on_agmnt = $("input[name=paidcalc_incentive_on_agmnt]").val(); // var calc_incentive_on_agmnt1 = calc_incentive_on_agmnt.replace(/\,/g,''); // var calc_incentive_on_agmnt2 = Number(calc_incentive_on_agmnt1); // var calc_incentive_on_regn = $("input[name=paidcalc_incentive_on_regn]").val(); // var calc_incentive_on_regn1 = calc_incentive_on_regn.replace(/\,/g,''); // var calc_incentive_on_regn2 = Number(calc_incentive_on_regn1); // if(insentive_perc == "40%") // { // var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_agmnt2; // } // else if(insentive_perc == "60%") // { // var balance = parseFloat(total_amount_fixed2) - calc_incentive_on_regn2; // } // else // { // var value = parseFloat(calc_incentive_on_agmnt2) + parseFloat(calc_incentive_on_regn2); // var balance = parseFloat(total_amount_fixed2) - value; // } // var balance_point = balance.toFixed(2); // var balance = balance_point.split('.')[0]; // var balance_float = balance_point.split('.')[1]; // var amount = ("" +balance).replace(/,/g, ""); // x=amount.toString(); // var lastThree = x.substring(x.length-3); // var otherNumbers = x.substring(0,x.length-3); // if(otherNumbers != '') // lastThree = ',' + lastThree; // var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; // var balance = $("input[name=paidcalc_balance]").val(res+'.'+balance_float); }); $('.calc_form').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $.ajax({ type : 'post', url : '<?php echo site_url("add-insentive-calculation")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('.calc_form')[0].reset(); $(".share_submit_button ").text("Submit"); $(".share_submit_button ").removeAttr('disabled'); $("#calc_model").modal('hide'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list20").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } else { toastr["error"](response.message); $(".share_submit_button ").text("Submit"); $(".share_submit_button ").removeAttr('disabled'); } } }); }); $('.paidcalc_form').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $.ajax({ type : 'post', url : '<?php echo site_url("add-paidinsentive-calculation")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('.paidcalc_form')[0].reset(); $(".calc_submit").text("Submit"); $(".calc_submit").removeAttr('disabled'); $("#calc_model").modal('hide'); } else { toastr["error"](response.message); $(".calc_submit").text("Submit"); $(".calc_submit").removeAttr('disabled'); } } }); }); //----------------------------------------------------------------------------// /* function hide_selected() { $('.selected_list').hide(); $('.pending_list').hide(); } function hide_incentive() { $('.incentive_list').hide(); }*/ function loctionreload() { toastr["success"]('No data Found'); setTimeout(function(){ location.reload(); }, 1500); } function getSelectedRow() { $("#get_site_grid").attr('disabled', 'disabled'); var total_sqft = 0; var id1; id1 = jQuery("#list1").jqGrid('getGridParam','selarrrow'); var row1 = $("#list1").jqGrid('getGridParam','selrow'); var id; id = jQuery("#list4").jqGrid('getGridParam','selarrrow'); if(row1 != null) { var total_sqft_added = $('.total_sqft_added').val(); if(total_sqft_added != '' || total_sqft_added != null || total_sqft_added != undefined) { var total_sqft_added = $('.total_sqft_added').val(); } else { var total_sqft_added = "0"; } var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var $grid1 = $("#list1"), selIds1 = $grid1.jqGrid("getGridParam", "selarrrow"), i, n; // cellValues4 = []; // cellValues5 = []; // cellValues6 = []; var $grid = $("#list4"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; for (i = 0, n = id.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "associate_broker_id")); } for (i = 0, n = id1.length; i < n; i++) { cellValues1.push($grid1.jqGrid("getCell", selIds1[i], "project_id")); cellValues2.push($grid1.jqGrid("getCell", selIds1[i], "site_number")); cellValues3.push($grid1.jqGrid("getCell", selIds1[i], "booking_id")); cellValues4.push($grid1.jqGrid("getCell", selIds[i], "broker_id")); } $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3,'broker_id':cellValues4}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-executive').show(); $('.achieved').val(response.message); get_broker_targets_incentive(); $('.project_id').val(response.project_id); $('.site_number').val(response.site_number); $('.executive_id').val(response.executive_id); } } }); } else { var total_sqft_added = '0'; var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var id; id = jQuery("#list4").jqGrid('getGridParam','selarrrow'); var row = $("#list4").jqGrid('getGridParam','selrow'); if(row != null) { var $grid = $("#list4"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "broker_id")); var project_id=cellValues1.join(","); var site_id=cellValues2.join(","); var booking_id=cellValues3.join(","); } $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3,'broker_id':cellValues4}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-executive').show(); $('.achieved').val(response.message); get_broker_targets_incentive(); $('.project_id').val(response.project_id); $('.site_number').val(response.site_number); $('.executive_id').val(response.executive_id); //$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); $('#list4'+i).addClass( "ui-state-highlight" ); } else { $( "#dialogSelectRow4" ).dialog(); } } function get_broker_targets_incentive() { var reference= $("select[name=reference]").val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-broker-targets")?>', data : {'reference':reference}, success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.basic_targets').val(response.details.basic_target); $('.broker_id').val(response.details.broker_id); if(response.details.incentive_type == "incentive_in_percentage") { $('.incentive_in_percentage').val(response.details.incentive_percent); $('.incentive_in_rs').val(0); } else if(response.details.incentive_type == "incentive_in_rs") { $('.incentive_in_rs').val(response.details.incentive_rupees); $('.incentive_in_percentage').val(0); } //get_excess_or_shortage(); } else { } } }); } } var total_sixty_perc = 0; function pending_getSelectedRow() { $("#neft_details").empty(); $("#cheque_details").empty(); $('#cash_details').empty(); $('.show-executive').show(); $('.grand_total_div').show(); $(".grand_total").empty(); var total1 = $('.total_fourty_perc').val(); if(total1 != "") { var fourty = $('.total_fourty_perc').val(); } else { var fourty = "0"; } var total2 = $('.total_sixty_perc').val(); if(total2 != "") { var sixty = $('.total_sixty_perc').val(); } else { var sixty = "0"; } var grand_total = parseFloat(fourty)+parseFloat(sixty); var both_amount = $('.both_amount').val(); if(both_amount != "" && grand_total != NaN) { var final_amount = parseFloat(both_amount)+parseFloat(grand_total); $('.grand_total').val(final_amount.toFixed(2)); } else if(both_amount != "") { parseFloat($('.grand_total').val(both_amount.toFixed(2))); } else if(grand_total != NaN) { parseFloat($('.grand_total').val(grand_total.toFixed(2))); } else { $('.grand_total').val(0); } var fourty_booking_id = $('.fourty_booking_id').val(); var sixty_booking_id = $('.sixty_booking_id').val(); var both_booking_id = $('.both_booking_id').val(); $.ajax({ type : 'post', url : '<?php echo site_url("get_total_sqft")?>', data : {'fourty_booking_id':fourty_booking_id,'sixty_booking_id':sixty_booking_id,'both_booking_id':both_booking_id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.total_sq_ft').val(response.message); } } }); var id1; id1 = jQuery("#list1").jqGrid('getGridParam','selarrrow'); var row1 = $("#list1").jqGrid('getGridParam','selrow'); var id; id = jQuery("#list5").jqGrid('getGridParam','selarrrow'); var row = $("#list5").jqGrid('getGridParam','selrow'); if(row1 != null) { var total_sqft_added = $('.total_sqft_added').val(); if(total_sqft_added != '' || total_sqft_added != null || total_sqft_added != undefined) { var total_sqft_added = $('.total_sqft_added').val(); } else { var total_sqft_added = "0"; } var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var $grid1 = $("#list1"), selIds1 = $grid1.jqGrid("getGridParam", "selarrrow"), i, n; // cellValues4 = []; // cellValues5 = []; // cellValues6 = []; var $grid = $("#list5"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; for (i = 0, n = id.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "associate_broker_id")); } for (i = 0, n = id1.length; i < n; i++) { cellValues1.push($grid1.jqGrid("getCell", selIds1[i], "project_id")); cellValues2.push($grid1.jqGrid("getCell", selIds1[i], "site_number")); cellValues3.push($grid1.jqGrid("getCell", selIds1[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "broker_id")); } $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3,'broker_id':cellValues4}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-executive').show(); $('.achieved').val(response.message); get_broker_targets(); /*$('.project_id').val(response.project_id); $('.site_number').val(response.site_number); $('.executive_id').val(response.executive_id);*/ } } }); } else { var total_sqft_added = '0'; var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var id; id = jQuery("#list5").jqGrid('getGridParam','selarrrow'); var row = $("#list5").jqGrid('getGridParam','selrow'); if(row != null) { var $grid = $("#list5"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "broker_id")); var project_id=cellValues1.join(","); var site_id=cellValues2.join(","); var booking_id=cellValues3.join(","); var broker_id=cellValues4.join(","); } $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3,'broker_id':cellValues4}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-executive').show(); $('.achieved').val(response.message); get_broker_targets(); /* $('.project_id').val(response.project_id); $('.site_number').val(response.site_number); $('.executive_id').val(response.executive_id);*/ //$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); $('#list5'+i).addClass( "ui-state-highlight" ); } /*else { $( "#dialogSelectRow4" ).dialog(); }*/ } function get_broker_targets() { var reference= $("select[name=reference]").val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-broker-targets")?>', data : {'reference':reference}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.basic_targets').val(response.details.basic_target); $('.broker_id').val(response.details.broker_id); if(response.details.incentive_type == "incentive_in_percentage") { $('.incentive_in_percentage').val(response.details.incentive_percent); $('.incentive_in_rs').val(0); } else if(response.details.incentive_type == "incentive_in_rs") { $('.incentive_in_rs').val(response.details.incentive_rupees); $('.incentive_in_percentage').val(0); } //get_excess_or_shortage(); } else { } } }); } } $('.executive_incentive').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $("#executive_submit_button").attr('disabled', 'disabled'); $("#executive_submit_button").text("Submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("add-executive-incentive")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); $("#executive_submit_button").removeAttr('disabled'); $("#get_site_grid_pending").text("Submit"); $("#get_site_grid_pending").removeAttr('disabled'); $('.executive_incentive')[0].reset(); $("#executive_submit_button").text("Submit"); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list20").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); //setTimeout(function(){ window.location.href = "<?php echo site_url('invoice-print');?>?id="+response.message }, 1500); $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.sixty_booking_id').empty(); $('.fourty_booking_id').empty(); $('.both_booking_id').empty(); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); $('.show-executive').hide(); } else if(response.result == 2) { toastr["error"](response.message); $("#executive_submit_button").text("Submit"); $("#executive_submit_button").removeAttr('disabled'); } else { toastr["error"](response.message); $("#executive_submit_button").text("Submit"); $("#executive_submit_button").removeAttr('disabled'); } } }); }); $('.logistic_incentive').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $("#logistic_submit_button").attr('disabled', 'disabled'); $("#logistic_submit_button").text("Submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("add-logistic-incentive")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); $('.logistic_incentive')[0].reset(); location.reload(); } else if(response.result == 2) { toastr["error"](response.message); $("#logistic_submit_button").text("Submit"); $("#logistic_submit_button").removeAttr('disabled'); } else { toastr["error"](response.message); $("#logistic_submit_button").text("Submit"); $("#logistic_submit_button").removeAttr('disabled'); } } }); }); function shared_exe_between(tsv,rowId,booking_id,inc_per,inc_rs) { var tsv = tsv; if(inc_per != 0) { var percentage = inc_per; if(percentage == undefined) { percentage = 0; $('.shared_exe_percent').val(0); $('.shared_total_amount').val(percentage); } else { percentage = percentage; var act_per_amt = parseInt(tsv)*parseInt(percentage)/parseInt(100); $('.shared_exe_percent').val(percentage); $('.shared_total_amount').val(act_per_amt); $('.shared_exe_amount').val(0); } } else { var amount = inc_rs; if(amount == undefined) { amount = 0; $('.shared_exe_amount').val(0); $('.shared_total_amount').val(amount); } else { amount = amount; var act_per_amt = parseInt(amount)/2; $('.shared_exe_percent').val(0); $('.shared_exe_amount').val(act_per_amt); $('.shared_total_amount').val(act_per_amt); } } var booking_id = booking_id; var broker_id = rowId; $('.exe_booking_id').val(booking_id); $('.exe_broker_id').val(broker_id); $.ajax({ type : 'post', url : '<?php echo site_url("get_executives")?>', data : {'broker_id':broker_id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.shared_exe_to').val(broker_id); var content = ""; content += '<option value="">Select</option>'; $.each(response.executives,function(key,value) { //content += '<option value="'+vals->broker_id+'">'+vals->associate_name+'</option>'; content += '<option value="' + value.broker_id + '">' + value.associate_name + '</option>'; }); $('.incentive_executive').append(content); } } }); $('#share_exe_between_modal').modal('show'); } $('.share_exe_between').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $("#share_exe_submit").attr('disabled', 'disabled'); $("#share_exe_submit").text("submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("update-shared-executive")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('#share_exe_between_modal').modal('hide'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list20").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('#share_exe_submit').trigger('reset'); $("#share_exe_submit").text("Submit"); $("#share_exe_submit").removeAttr('disabled'); } else { toastr["error"](response.message); $("#share_exe_submit").text("Submit"); $("#share_exe_submit").removeAttr('disabled'); } } }); }); $('.logistic_form').submit(function(e){ e.preventDefault(); //formdata = new FormData($(this)[0]); //$("#log_submit").attr('disabled', 'disabled'); //$("#log_submit").text("submitting..."); var reference= $("select[name=logistics]").val(); var from_date= $("input[name=log_from_date]").val(); var to_date= $("input[name=log_to_date]").val(); load_date_grid12(); function load_date_grid12() { $("#list2").setGridParam( { url:"<?php echo site_url('shared-to-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list2").jqGrid({ url:"<?php echo site_url('shared-to-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','','Booking Date','Project','Site','Client','Dimension','TSV','Agreement Date','Registration Date','Executive','Booking Status','','','','Share Between','Amount'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'broker_id',index:'broker_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, //{name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'tsv',index:'tsv', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'incentive_status',index:'incentive_status',hidden:true, width:150,editable:false}, {name:'incentive_percent',index:'incentive_percent',hidden:true, width:150,editable:false}, {name:'incentive_rupees',index:'incentive_rupees',hidden:true, width:150,editable:false}, {name:'shared_between_logistic',index:'shared_between_logistic', width:150,editable:false}, {name:'shared_logistic_amount',index:'shared_logistic_amount', width:150,editable:false}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager2", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, multiselect: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"Shared Logistic Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list2").jqGrid('getCol','dimension',false,'sum'); //$('.total_sqft').val(sumOfdimension.toFixed(2)); $('.total_sqft_added').val(sumOfdimension.toFixed(2)); var rows = $("#list2").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list2").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list2").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; /* $('#jqg_list2_'+abc).attr("disabled", true); $('#jqg_list2_'+abc).addClass("ui-state-disabled");*/ $("#list2").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); //$("#jqg_"+abc, "#list4").attr("disabled",true); // $("#rowid"+ " #jqg_"+abc, '#list4').attr("readonly",true); } var incentive_status = $("#list2").getCell(rows[i],"incentive_status"); if(incentive_status == 'YES') { var abc = parseInt(i)+1; /*$('#jqg_list2_'+abc).attr("disabled", true); $('#jqg_list2_'+abc).addClass("ui-state-disabled");*/ $("#list2").jqGrid('setRowData',rows[i],false, { background:'#ece6e6'}); } var shared_between_logistic = $("#list2").getCell(rows[i],"shared_between_logistic"); if(shared_between_logistic != '') { /*var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ $("#list2").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, }); $("#list2").jqGrid("setLabel", "rn", "SL"); $("#list2").jqGrid('filterToolbar',{searchOperators : false}); $("#list2").jqGrid('navGrid','#pager2', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); var admin_id = $('.admin_id').val(); var user_type_id = $('.user_type_id').val(); if(admin_id == 18 && user_type_id == 1) { load_date_grid11(); function load_date_grid11() { $("#list6").setGridParam( { url:"<?php echo site_url('selected-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list6").jqGrid({ url:"<?php echo site_url('selected-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Logistic','Booking Status','','','','Executive','DELETE'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'logistic_name',index:'logistic_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'log_incentive_status',index:'log_incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_logistic',index:'shared_between_logistic',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'executive',index:'executive', width:100,editable:false,search:true}, {name:'delete',index:'delete',align: "center",editable:false,search:false,editrules:{required: true}, width:175,cellattr: function (rowId, tv, rawObject, cm, rdata) { return "onclick='fun_delete_log("+rawObject.id+","+rawObject.project_id+","+rawObject.booking_id+",\""+rawObject.site_number+"\") ';" },formatter:function (cellvalue, options, rowObject) { return "<input type='button' value='DELETE'>"; }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager6", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: hide_selected, //multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"Selected Logistic Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list6").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list6").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list6").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list6").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list6_'+abc).attr("disabled", true); $('#jqg_list6_'+abc).addClass("ui-state-disabled"); $("#list6").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var shared_between_logistic = $("#list6").getCell(rows[i],"shared_between_logistic"); //var selected_incentive_status = $("#list6").getCell(rows[i],"selected_incentive_status"); if(shared_between_logistic != '') { $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } // if(shared_between_logistic != '') // { // /*var abc = parseInt(i)+1; // $('#jqg_list8_'+abc).attr("disabled", true); // $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ // $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); // } // else if(selected_incentive_status == 'YES') // { // $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f7caca'}); // } } $('.cancelled').val(dimensions); }, gridComplete: function() { var recs = parseInt($("#list6").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_log_selected(); } else { hide_log_incentive(); } }, }); //$('.get_site_grid').show(); $("#list6").jqGrid("setLabel", "rn", "SL"); $("#list6").jqGrid('filterToolbar',{searchOperators : false}); $("#list6").jqGrid('navGrid','#pager6', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); } else { load_date_grid10(); function load_date_grid10() { $("#list6").setGridParam( { url:"<?php echo site_url('selected-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list6").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list6").jqGrid({ url:"<?php echo site_url('selected-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Logistic','Booking Status','','','','Executive'], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'logistic_name',index:'logistic_name', width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, {name:'log_incentive_status',index:'log_incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_logistic',index:'shared_between_logistic',hidden:true, width:150,editable:false}, {name:'selected_incentive_status',index:'selected_incentive_status',hidden:true, width:150,editable:false}, {name:'executive',index:'executive', width:100,editable:false,search:true}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager6", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: hide_selected, //multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"Selected Logistic Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list6").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list6").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list6").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list6").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list6_'+abc).attr("disabled", true); $('#jqg_list6_'+abc).addClass("ui-state-disabled"); $("#list6").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } var shared_between_logistic = $("#list6").getCell(rows[i],"shared_between_logistic"); //var selected_incentive_status = $("#list6").getCell(rows[i],"selected_incentive_status"); if(shared_between_logistic != '') { $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } // if(shared_between_logistic != '') // { // /*var abc = parseInt(i)+1; // $('#jqg_list8_'+abc).attr("disabled", true); // $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ // $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); // } // else if(selected_incentive_status == 'YES') // { // $("#list6").jqGrid('setRowData',rows[i],false, { background:'#f7caca'}); // } } $('.cancelled').val(dimensions); }, gridComplete: function() { var recs = parseInt($("#list6").getGridParam("records"),10); if (isNaN(recs) || recs == 0) { hide_log_selected(); } else { hide_log_incentive(); } }, }); //$('.get_site_grid').show(); $("#list6").jqGrid("setLabel", "rn", "SL"); $("#list6").jqGrid('filterToolbar',{searchOperators : false}); $("#list6").jqGrid('navGrid','#pager6', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); } $("#list6").navButtonAdd('#pager6', { caption:"Export", buttonicon:"", onClickButton: export_pending_insentives_logistics, position: "last", title:"", cursor: "pointer", id:"export_pending_insentives_logistics" } ); function export_pending_insentives_logistics() { var from_date = $("input[name=from_date]").val(); var to_date = $("input[name=to_date]").val(); var reference = $("select[name=logistics] option:selected").val(); $.ajax({ url:"<?php echo base_url('selected-logistic-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Logistic</th><th>Executive</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.logistic_name+'</td><td>'+va.executive+'</td></tr>'; count++; }); $('#selected_logistics_export_table').html(content); export_selected_logistics(); } }); } function export_selected_logistics() { $("#selected_logistics_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Selected Incentive Logistics Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } load_date_grid6(); function load_date_grid6() { $("#list7").setGridParam( { url:"<?php echo site_url('logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list7").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list7").jqGrid({ url:"<?php echo site_url('logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Cancelled Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Logistic','','Booking Status','','Share With','Amount','Executive',''], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,editable:false}, {name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false}, {name:'site_number',index:'site_number', width:75, editable:false}, {name:'customer_name',index:'customer_name', width:75, editable:false}, {name:'dimension',index:'dimension', width:75, editable:false}, {name:'agreement_date',index:'agreement_date', width:100,editable:false}, {name:'registration_date',index:'registration_date', width:100,editable:false}, {name:'associate_name',index:'associate_name', width:100,editable:false}, {name:'broker_id',index:'broker_id',hidden:true,width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, //{name:'incentive_target_rs',index:'incentive_target_rs', width:150,editable:false,hidden:true}, {name:'log_incentive_status',index:'log_incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_logistic',index:'shared_between_logistic', width:150,editable:false}, {name:'shared_logistic_amount',index:'shared_logistic_amount',width:150,editable:false}, {name:'executive',index:'executive', width:100,editable:false,search:true}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:false, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="shared_log_between('+rawObject.incentive_target_rs+','+rawObject.booking_id+','+rawObject.broker_id+')" '; },formatter:function (cellvalue, options, rowObject) { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { return "<input type='button' value='Shared Between' disabled='disabled'\>"; } else { return "<input type='button' value='Shared Between' \>"; } }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager7", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, multiselect: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, // multiboxonly: true, loadonce:true, caption:"Logistic Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list7").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft_incentive_added').val(sumOfdimension.toFixed(2)); var rows = $("#list7").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list7").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list7").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list7_'+abc).attr("disabled", true); $('#jqg_list7_'+abc).addClass("ui-state-disabled"); $("#list7").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } /* var incentive_status = $("#list7").getCell(rows[i],"log_incentive_status"); if(incentive_status == 'YES') { var abc = parseInt(i)+1; $('#jqg_list7_'+abc).attr("disabled", true); $('#jqg_list7_'+abc).addClass("ui-state-disabled"); $("#list7").jqGrid('setRowData',rows[i],false, { background:'#f7caca'}); }*/ var shared_between_logistic = $("#list7").getCell(rows[i],"shared_between_logistic"); if(shared_between_logistic != '') { /*var abc = parseInt(i)+1; $('#jqg_list7_'+abc).attr("disabled", true); $('#jqg_list7_'+abc).addClass("ui-state-disabled");*/ $("#list7").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, }); $('.get_logistic_site_grid').show(); $("#list7").jqGrid("setLabel", "rn", "SL"); $("#list7").jqGrid('filterToolbar',{searchOperators : false}); $("#list7").jqGrid('navGrid','#pager7', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list7").navButtonAdd('#pager7', { caption:"Export", buttonicon:"", onClickButton: export_insentive_logistics, position: "last", title:"", cursor: "pointer", id:"export_insentive_logistics" } ); function export_insentive_logistics() { var from_date = $("input[name=log_from_date]").val(); var to_date = $("input[name=log_to_date]").val(); var reference = $("select[name=logistics] option:selected").val(); $.ajax({ url:"<?php echo base_url('logistic-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Cancelled date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Logistic</th><th>Share With</th><th>Amount</th><th>Executive</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.cancelled_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.shared_between_logistic+'</td><td>'+va.shared_logistic_amount+'</td><td>'+va.executive+'</td></tr>'; count++; }); $('#insentive_logistics_export_table').html(content); export_insentive_logistics1(); } }); } function export_insentive_logistics1() { $("#insentive_logistics_export_table").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Incentive Logistics Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } //---------------------------------------------------------------------------------------// load_date_grid7(); function load_date_grid7() { $("#list8").setGridParam( { url:"<?php echo site_url('pending-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, page:1 }).trigger("reloadGrid");//Reload grid trigger $("#list8").setGridParam({datatype:'json', page:1}).trigger('reloadGrid'); return false } jQuery("#list8").jqGrid({ url:"<?php echo site_url('pending-logistic-incentive')?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", datatype: "json", colNames:['SI','','','Booking Date','Cancelled Date','Project','Site','Client','Dimension','Agreement Date','Registration Date','Logistic','','Booking Status','','Share With','Amount','Executive',''], colModel:[ {name:'id',index:'id', width:150, hidden:true,editable:false,key:true}, {name:'project_id',index:'project_id',hidden:true, width:150,editable:false}, {name:'booking_id',index:'booking_id',hidden:true, width:150,editable:false}, {name:'booking_date',index:'booking_date', width:150,search:true,editable:false}, {name:'cancelled_date',index:'cancelled_date', width:150,editable:false}, {name:'project_name',index:'project_name', width:150,editable:false,search:true}, {name:'site_number',index:'site_number', width:75, editable:false,search:true}, {name:'customer_name',index:'customer_name', width:75, editable:false,search:true}, {name:'dimension',index:'dimension', width:75, editable:false,search:true}, {name:'agreement_date',index:'agreement_date', width:100,editable:false,search:true}, {name:'registration_date',index:'registration_date', width:100,editable:false,search:true}, {name:'associate_name',index:'associate_name', width:100,editable:false,search:true}, {name:'broker_id',index:'broker_id',hidden:true, width:100,editable:false}, {name:'booking_status',index:'booking_status',hidden:true, width:150,editable:false}, //{name:'incentive_target_rs',index:'incentive_target_rs', width:150,editable:false}, {name:'log_incentive_status',index:'log_incentive_status',hidden:true, width:150,editable:false}, {name:'shared_between_logistic',index:'shared_between_logistic', width:150,editable:false,search:true}, {name:'shared_logistic_amount',index:'shared_logistic_amount', width:150,editable:false,search:true}, {name:'executive',index:'executive', width:100,editable:false,search:true}, {name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:true, width:150,cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' onclick="shared_log_between('+rawObject.incentive_target_rs+','+rawObject.booking_id+','+rawObject.broker_id+')" '; },formatter:function (cellvalue, options, rowObject) { if(rowObject.booking_status == "CANCELLED" || rowObject.booking_status == "REFUNDED" || rowObject.booking_status == "REFUND_PENDING") { return "<input type='button' value='Shared Between' disabled='disabled'\>"; } else { return "<input type='button' value='Shared Between' \>"; } }}, ], rowNum:20, rowTotal: 2000, rowList : [10,20,30,50,100,500,1000], rownumbers: true, rownumWidth: 40, pager:"#pager8", sortname:'id', viewrecords: true, gridview: true, autowidth: true, sortorder:"asc", shrinkToFit: true, //emptyrecords: loctionreload, multiselect: true, // multiboxonly: true, rowattr: function (rd) { if (rd.booking_status == "CANCELLED" || rd.booking_status == "REFUNDED" || rd.booking_status == "REFUND_PENDING") { return { "class": "ui-state-disabled ui-jqgrid-disablePointerEvents" }; } }, loadonce:true, caption:"Pending Logistic Incentive Details", footerrow: true, loadComplete: function () { var sumOfdimension = jQuery("#list8").jqGrid('getCol','dimension',false,'sum'); $('.total_sqft').val(sumOfdimension.toFixed(2)); var rows = $("#list8").getDataIDs(); var dimensions = "0"; for (var i = 0; i < rows.length; i++) { var status = $("#list8").getCell(rows[i],"booking_status"); if(status == "CANCELLED" || status == "REFUNDED" || status == "REFUND_PENDING") { var dimension = $("#list8").getCell(rows[i],"dimension"); dimensions = parseInt(dimensions)+parseInt(dimension); var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled"); $("#list8").jqGrid('setRowData',rows[i],false, { background:'#ef1f1d'}); } /*var incentive_status = $("#list8").getCell(rows[i],"log_incentive_status"); if(incentive_status == 'YES') { var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled"); $("#list8").jqGrid('setRowData',rows[i],false, { background:'#f7caca'}); }*/ var shared_between_logistic = $("#list8").getCell(rows[i],"shared_between_logistic"); if(shared_between_logistic != '') { /*var abc = parseInt(i)+1; $('#jqg_list8_'+abc).attr("disabled", true); $('#jqg_list8_'+abc).addClass("ui-state-disabled");*/ $("#list8").jqGrid('setRowData',rows[i],false, { background:'#f3f098'}); } } $('.cancelled').val(dimensions); }, }); $('.get_logistic_site_grid_pending').show(); $("#list8").jqGrid("setLabel", "rn", "SL"); $("#list8").jqGrid('filterToolbar',{searchOperators : false}); $("#list8").jqGrid('navGrid','#pager8', {edit:false,add:false,del:false,search:false,refresh:false}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true } ); $("#list8").navButtonAdd('#pager8', { caption:"Export", buttonicon:"", onClickButton: export_pending_logistics, position: "last", title:"", cursor: "pointer", id:"export_pending_logistics" } ); function export_pending_logistics() { var from_date = $("input[name=log_from_date]").val(); var to_date = $("input[name=log_to_date]").val(); var reference = $("select[name=logistics] option:selected").val(); $.ajax({ url:"<?php echo base_url('pending-logistic-incentive');?>?from_date="+from_date+'&to_date='+to_date+'&reference='+reference, type : "GET", success:function(data) { //response = jQuery.parseJSON(data); console.log(response); var count = 1; var content = ''; content +='<thead><tr><th>Sl No</th><th>Booking date</th><th>Cancelled date</th><th>Project</th><th>Site</th><th>Client</th><th>Dimension</th><th>Agreement Date</th><th>Registration Date</th><th>Logistic</th><th>Share With</th><th>Amount</th><th>Executive</th></tr></thead>'; $.each(response,function(key,va){ content +='<tr><td>'+count+'</td> <td>'+va.booking_date+'</td><td>'+va.cancelled_date+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.customer_name+'</td><td>'+va.dimension+'</td><td>'+va.agreement_date+'</td><td>'+va.registration_date+'</td><td>'+va.associate_name+'</td><td>'+va.shared_between_logistic+'</td><td>'+va.shared_logistic_amount+'</td><td>'+va.executive+'</td></tr>'; count++; }); $('#pending_logistics_export_tabledata').html(content); export_pending_logistics1(); } }); } function export_pending_logistics1() { $("#pending_logistics_export_tabledata").table2excel({ exclude: ".noExl", footer:true, name: "Excel Document Name", filename: "Pending Incentive Logistics Details", fileext: ".xls", exclude_img: true, exclude_links: true, exclude_inputs: true }); } }); function hide_log_selected() { $('.selected_log_list').hide(); $('.pending_log_list').hide(); } function hide_log_incentive() { $('.incentive_log_list').hide(); } function log_getSelectedRow() { $("#get_logistic_site_grid").attr('disabled', 'disabled'); var total_sqft = 0; var id1; id1 = jQuery("#list2").jqGrid('getGridParam','selarrrow'); var row1 = $("#list2").jqGrid('getGridParam','selrow'); var id; id = jQuery("#list7").jqGrid('getGridParam','selarrrow'); if(row1 != null) { var total_sqft_added = $('.total_sqft_added').val(); if(total_sqft_added != '' || total_sqft_added != null || total_sqft_added != undefined) { var total_sqft_added = $('.total_sqft_added').val(); } else { var total_sqft_added = "0"; } var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var selRowIds1 = jQuery('#list2').jqGrid('getGridParam', 'selarrrow'); var $grid1 = $("#list2"), selIds1 = $grid1.jqGrid("getGridParam", "selarrrow"), i, n; // cellValues4 = []; // cellValues5 = []; // cellValues6 = []; var selRowIds = jQuery('#list7').jqGrid('getGridParam', 'selarrrow'); var sites_count11 = selRowIds.length; var sites_count12 = selRowIds1.length; var sites_count = selRowIds1.length+selRowIds.length; var $grid = $("#list7"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var shared_logistic_amount = 0; var shared_logistic_amount11 = 0; for (i = 0, n = id.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "shared_logistic_amount")); shared_logistic_amount11 += parseFloat($("#list7").jqGrid('getCell', selIds[i], 'shared_logistic_amount')); } var shared_logistic_amount12 = 0; for (i = 0, n = id1.length; i < n; i++) { cellValues1.push($grid1.jqGrid("getCell", selIds1[i], "project_id")); cellValues2.push($grid1.jqGrid("getCell", selIds1[i], "site_number")); cellValues3.push($grid1.jqGrid("getCell", selIds1[i], "booking_id")); cellValues4.push($grid1.jqGrid("getCell", selIds1[i], "shared_logistic_amount")); shared_logistic_amount12 += parseFloat($("#list2").jqGrid('getCell', selIds1[i], 'shared_logistic_amount')); } var shared_logistic_amount = parseFloat(shared_logistic_amount11)+parseFloat(shared_logistic_amount12); $('.tot_amt').val(shared_logistic_amount); $('.total_sites').val(sites_count); $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3}, success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-logistic').show(); $('.sites_count').val(sites_count); var reference= $("select[name=logistics]").val(); $('.log_broker_id').val(reference); //get_broker_targets(); $('.log_project_id').val(response.project_id); $('.log_site_number').val(response.site_number); } } }); } else { var total_sqft_added = '0'; var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); $("#get_logistic_site_grid").attr('disabled', 'disabled'); var id; id = jQuery("#list7").jqGrid('getGridParam','selarrrow'); var row = $("#list7").jqGrid('getGridParam','selrow'); var selRowIds = jQuery('#list7').jqGrid('getGridParam', 'selarrrow'); var sites_count = selRowIds.length; if(row != null ) { var $grid = $("#list7"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var shared_logistic_amount = 0; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "shared_logistic_amount")); var project_id=cellValues1.join(","); var site_id=cellValues2.join(","); var booking_id=cellValues3.join(","); shared_logistic_amount += parseFloat($("#list7").jqGrid('getCell', selIds[i], 'shared_logistic_amount')); } $('.show-logistic').show(); $('.total_sites').val(sites_count); $('.tot_amt').val(shared_logistic_amount); $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-logistic').show(); $('.sites_count').val(sites_count); var reference= $("select[name=logistics]").val(); $('.log_broker_id').val(reference); //get_broker_targets(); $('.log_project_id').val(response.project_id); $('.log_site_number').val(response.site_number); //$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); $('#list7'+i).addClass( "ui-state-highlight" ); //$('.show-remaining').show(); } else { $( "#dialogSelectRow7" ).dialog(); } } function get_broker_targets_incentive() { var reference= $("select[name=reference]").val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-broker-targets")?>', data : {'reference':reference}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.basic_targets').val(response.details.basic_target); $('.broker_id').val(response.details.broker_id); if(response.details.incentive_type == "incentive_in_percentage") { $('.incentive_in_percentage').val(response.details.incentive_percent); $('.incentive_in_rs').val(0); } else if(response.details.incentive_type == "incentive_in_rs") { $('.incentive_in_rs').val(response.details.incentive_rupees); $('.incentive_in_percentage').val(0); } //get_excess_or_shortage(); } else { } } }); } } function pending_log_getSelectedRow() { $("#get_logistic_site_grid").attr('disabled', 'disabled'); var id1; id1 = jQuery("#list2").jqGrid('getGridParam','selarrrow'); var row1 = $("#list2").jqGrid('getGridParam','selrow'); var id; id = jQuery("#list8").jqGrid('getGridParam','selarrrow'); if(row1 != null) { var total_sqft_added = $('.total_sqft_added').val(); if(total_sqft_added != '' || total_sqft_added != null || total_sqft_added != undefined) { var total_sqft_added = $('.total_sqft_added').val(); } else { var total_sqft_added = "0"; } var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); var selRowIds1 = jQuery('#list2').jqGrid('getGridParam', 'selarrrow'); var $grid1 = $("#list2"), selIds1 = $grid1.jqGrid("getGridParam", "selarrrow"), i, n; // cellValues4 = []; // cellValues5 = []; // cellValues6 = []; var selRowIds = jQuery('#list8').jqGrid('getGridParam', 'selarrrow'); var sites_count11 = selRowIds.length; var sites_count12 = selRowIds1.length; var sites_count = selRowIds1.length+selRowIds.length; var $grid = $("#list8"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var shared_logistic_amount = 0; var shared_logistic_amount11 = 0; for (i = 0, n = id.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "shared_logistic_amount")); shared_logistic_amount11 += parseFloat($("#list8").jqGrid('getCell', selIds[i], 'shared_logistic_amount')); } var shared_logistic_amount12 = 0; for (i = 0, n = id1.length; i < n; i++) { cellValues1.push($grid1.jqGrid("getCell", selIds1[i], "project_id")); cellValues2.push($grid1.jqGrid("getCell", selIds1[i], "site_number")); cellValues3.push($grid1.jqGrid("getCell", selIds1[i], "booking_id")); cellValues4.push($grid1.jqGrid("getCell", selIds1[i], "shared_logistic_amount")); shared_logistic_amount12 += parseFloat($("#list2").jqGrid('getCell', selIds1[i], 'shared_logistic_amount')); } var shared_logistic_amount = parseFloat(shared_logistic_amount11)+parseFloat(shared_logistic_amount12); $('.tot_amt').val(shared_logistic_amount); $('.total_sites').val(sites_count); $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-logistic').show(); $('.sites_count').val(sites_count); var reference= $("select[name=logistics]").val(); $('.log_broker_id').val(reference); //get_broker_targets(); $('.log_project_id').val(response.project_id); $('.log_site_number').val(response.site_number); } } }); } else { var total_sqft_added = '0'; var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); if(total_sqft_incentive_added != '' || total_sqft_incentive_added != null || total_sqft_incentive_added != undefined) { var total_sqft_incentive_added = $('.total_sqft_incentive_added').val(); } else { var total_sqft_incentive_added = "0"; } total_sqft = parseFloat(total_sqft_added)+parseFloat(total_sqft_incentive_added); $('.total_sqft').val(total_sqft.toFixed(2)); $("#get_logistic_site_grid").attr('disabled', 'disabled'); var id; id = jQuery("#list8").jqGrid('getGridParam','selarrrow'); var row = $("#list8").jqGrid('getGridParam','selrow'); var selRowIds = jQuery('#list8').jqGrid('getGridParam', 'selarrrow'); var sites_count = selRowIds.length; if(row != null ) { var $grid = $("#list8"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues1 = []; cellValues2 = []; cellValues3 = []; cellValues4 = []; var shared_logistic_amount = 0; for (i = 0, n = selIds.length; i < n; i++) { cellValues1.push($grid.jqGrid("getCell", selIds[i], "project_id")); cellValues2.push($grid.jqGrid("getCell", selIds[i], "site_number")); cellValues3.push($grid.jqGrid("getCell", selIds[i], "booking_id")); cellValues4.push($grid.jqGrid("getCell", selIds[i], "shared_logistic_amount")); var project_id=cellValues1.join(","); var site_id=cellValues2.join(","); var booking_id=cellValues3.join(","); shared_logistic_amount += parseFloat($("#list8").jqGrid('getCell', selIds[i], 'shared_logistic_amount')); } $('.show-logistic').show(); $('.total_sites').val(sites_count); $('.tot_amt').val(shared_logistic_amount); $.ajax({ type : 'post', url : '<?php echo site_url("get_brokers_total_sites_sqft")?>', data : {'project_id':cellValues1,'site_id':cellValues2,'booking_id':cellValues3}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.show-logistic').show(); $('.sites_count').val(sites_count); var reference= $("select[name=logistics]").val(); $('.log_broker_id').val(reference); //get_broker_targets(); $('.log_project_id').val(response.project_id); $('.log_site_number').val(response.site_number); //$("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); $('#list8'+i).addClass( "ui-state-highlight" ); //$('.show-remaining').show(); } else { $( "#dialogSelectRow7" ).dialog(); } } function get_broker_targets_incentive() { var reference= $("select[name=reference]").val(); $.ajax({ type : 'post', url : '<?php echo site_url("get-broker-targets")?>', data : {'reference':reference}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { $('.basic_targets').val(response.details.basic_target); $('.broker_id').val(response.details.broker_id); if(response.details.incentive_type == "incentive_in_percentage") { $('.incentive_in_percentage').val(response.details.incentive_percent); $('.incentive_in_rs').val(0); } else if(response.details.incentive_type == "incentive_in_rs") { $('.incentive_in_rs').val(response.details.incentive_rupees); $('.incentive_in_percentage').val(0); } //get_excess_or_shortage(); } else { } } }); } } function shared_log_between(rowId,booking_id,broker_id) { var amount = rowId; if(amount == "") { toastr["error"]("Amount not added for logistic!"); } var booking_id = booking_id; var broker_id = broker_id; var act_amt = parseInt(amount)/2; $('.shared_log_amount').val(act_amt); $('.booking_id').val(booking_id); $('.broker_id').val(broker_id); $.ajax({ type : 'post', url : '<?php echo site_url("get_logistics")?>', data : {'broker_id':broker_id}, success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var content = ""; content += '<option value="">Select</option>'; $.each(response.logistics,function(key,value) { //content += '<option value="'+vals->broker_id+'">'+vals->associate_name+'</option>'; content += '<option value="' + value.broker_id + '">' + value.associate_name + '</option>'; }); $('.incentive_logistic').append(content); } } }); $('#share_log_between_modal').modal('show'); } $('.share_log_between').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); $("#share_log_submit").attr('disabled', 'disabled'); $("#share_log_submit").text("submitting..."); $.ajax({ type : 'post', url : '<?php echo site_url("update-shared-logistic")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('#share_log_between_modal').modal('hide'); $("#list7").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('.share_log_between')[0].reset(); $(".share_log_submit").text("Submit"); $(".share_log_submit").removeAttr('disabled'); } else { toastr["error"](response.message); $(".share_log_submit").text("Submit"); $(".share_log_submit").removeAttr('disabled'); } } }); }); function fun_delete_exe(booking_id) { swal({ title: "Are you sure?", text: "You will not be able to recover this data!", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, delete it!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : '<?php echo site_url("delete-executive-incentives")?>', data : {booking_id:booking_id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); // location.reload(); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } function fun_delete_log(id,project_id,booking_id,site_number) { swal({ title: "Are you sure?", text: "You will not be able to recover this data!", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, delete it!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : '<?php echo site_url("delete-logistic-incentives")?>', data : {id:id,project_id:project_id,booking_id:booking_id,site_number:site_number}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); $("#list6").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list2").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list8").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } $(document).on("change", ".duration", function() { var duration = $(this).val(); if(duration != "") { var basic_targets = $(".basic_targets").val(); var total_target = parseFloat(duration)*parseFloat(basic_targets); $(".total_target").val(total_target); var total_target_val = $(".total_target").val(); var achieved = $('.achieved').val(); var cancelled = $('.cancelled').val(); var value = parseInt(achieved)-parseInt(total_target_val)-parseInt(cancelled); var values = value.toFixed(2); var net_amount = 0; if(value > 0) { $('.excess').val(values); $('.shortage').val(0); var excess_amt = parseFloat(value); var in_per = $('.incentive_in_percentage').val(); var in_rs = $('.incentive_in_rs').val(); if(in_per == 0) { var rs = $('.incentive_in_rs').val(); var net_amount = parseFloat(excess_amt)*parseFloat(rs); } else { var per = $('.incentive_in_percentage').val(); var net_amount = (parseFloat(excess_amt)*parseFloat(per))/100; } $('.net_amt').val(net_amount); } else { $('.shortage').val(values); $('.excess').val(0); $('.net_amt').val(0); } $('.net_achieved').val(values); var net_amount = $('.net_amt').val(); if(net_amount > 0) { $(".amount").attr("readonly", true); $(".amount").val(0); } else { $(".amount").attr("readonly", false); } } else { $(".total_target").val(0); $(".duration").val(0); } }); /*function get_excess_or_shortage() { var duration = $(".duration").val(); if(duration != "") { duration = duration; } else { duration = 0; } var basic_target = $('.basic_targets').val(); var total_target = parseFloat(duration)*parseFloat(basic_target); var achieved = $('.achieved').val(); var cancelled = $('.cancelled').val(); var value = parseInt(achieved)-parseInt(total_target)-parseInt(cancelled); var values = value.toFixed(2); var net_amount = 0; if(value > 0) { $('.excess').val(values); $('.shortage').val(0); var excess_amt = parseFloat(value); var in_per = $('.incentive_in_percentage').val(); var in_rs = $('.incentive_in_rs').val(); if(in_per == 0) { var rs = $('.incentive_in_rs').val(); var net_amount = parseFloat(excess_amt)*parseFloat(rs); } else { var per = $('.incentive_in_percentage').val(); var net_amount = (parseFloat(excess_amt)*parseFloat(per))/100; } $('.net_amt').val(net_amount); } else { $('.shortage').val(values); $('.excess').val(0); $('.net_amt').val(0); } $('.net_achieved').val(values); var net_amount = $('.net_amt').val(); if(net_amount > 0) { $(".amount").attr("readonly", true); $(".amount").val(0); } else { $(".amount").attr("readonly", false); } }*/ function edit_shared_between(tsv,rowId,booking_id,inc_per,inc_rs) { var booking_id = booking_id; var broker_id = rowId; $('.edit_exe_booking_id').val(booking_id); var reference= $("select[name=reference]").val(); $('.edit_exe_broker_id').val(reference); $.ajax({ type : 'post', url : '<?php echo site_url("get_edit_executives")?>', data : {'broker_id':broker_id,'booking_id':booking_id}, success:function(response) { // response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { var content = ""; content += '<option value="">Select</option>'; $.each(response.executives,function(key,value) { if(response.message.shared_between_executive == value.broker_id) { content += '<option value="'+value.broker_id+'" selected>' + value.associate_name + '</option>'; } else { content += '<option value="'+value.broker_id+'">' + value.associate_name + '</option>'; } }); $('.edit_incentive_executive').append(content); $('.edit_shared_exe_amount').val(response.message.shared_executive_amount); $('.edit_shared_exe_percent').val(response.message.shared_executive_percentage); $('.edit_shared_total_amount').val(response.message.shared_amount); } } }); $('#edit_share_exe_between_modal').modal('show'); } function reset() { console.log(" button clicked!"); } $('#update_shared_between').submit(function(e){ e.preventDefault(); formdata = new FormData($(this)[0]); /*$(".edit_share_submit_button").attr('disabled', 'disabled'); $(".edit_share_submit_button").text("submitting...");*/ $.ajax({ type : 'post', url : '<?php echo site_url("update-shared-executive-between")?>', data : formdata, contentType: false, processData: false, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { toastr["success"](response.message); $('#edit_share_exe_between_modal').modal('hide'); $("#list4").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list20").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); $('.edit_share_submit_button')[0].reset(); $(".edit_share_submit_button").text("Submit"); $(".edit_share_submit_button").removeAttr('disabled'); } else { toastr["error"](response.message); $(".edit_share_submit_button").text("Submit"); $(".edit_share_submit_button").removeAttr('disabled'); } } }); }); function fun_edit_exe(booking_id) { swal({ title: "Are you sure?", text: "You will not be able to recover this data!", type: "warning", showCancelButton: true, confirmButtonColor: "#DD6B55", confirmButtonText: "Yes, delete it!", cancelButtonText: "No, cancel plz!", closeOnConfirm: false, closeOnCancel: false }, function(isConfirm){ if (isConfirm) { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); $.ajax({ type : 'post', url : '<?php echo site_url("edit-executive-incentives")?>', data : {booking_id:booking_id}, success:function(response) { //response=jQuery.parseJSON(response); console.log(response); if(response.result == 1) { toastr["success"](response.message); // $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); // $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); // $("#list5").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); location.reload(); } } }); } else { $(".sweet-alert").hide(); $(".sweet-overlay").hide(); } }); } $(document).on('click','.edit_calc_btn',function(){ $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); var booking_id = $(this).attr('booking_id'); $("input[name=edit_calc_booking_id]").val(booking_id); var total_sqft = $(this).attr('dim'); $("input[name=edit_calc_total_sqft]").val(total_sqft); var perc_type = $(this).attr('perc_type'); $.ajax({ type : 'post', url : '<?php echo site_url("get-insentive-details")?>', data : {booking_id:booking_id}, success:function(response){ //response=jQuery.parseJSON(response); console.log(response); if(response.result==1) { $('.fourty_status').empty(); $('.both_status').empty(); $('.sixty_status').empty(); $('.total_fourty_perc').val('0'); $('.total_sixty_perc').val('0'); $('.grand_total').val('0'); $('.both_amount').val('0'); $('.total_amount').val('0'); $("input[name=edit_calc_rate_per_sqft]").val(response.data.rate_per_sqft); var total_amount_fixed_point = response.data.total_amount_fixed; var total_amount_fixed = total_amount_fixed_point.split('.')[0]; var total_amount_fixed_float = total_amount_fixed_point.split('.')[1]; var amount = ("" +total_amount_fixed).replace(/,/g, ""); x=amount.toString(); var lastThree = x.substring(x.length-3); var otherNumbers = x.substring(0,x.length-3); if(otherNumbers != '') lastThree = ',' + lastThree; var res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; if(total_amount_fixed_float == undefined) { $("input[name=edit_calc_total_amount_fixed]").val(res); } else { $("input[name=edit_calc_total_amount_fixed]").val(res+'.'+total_amount_fixed_float); } //---------------------------------------------------------------------------------// var incentive_on_agmnt_point = response.data.incentive_on_agmnt; var incentive_on_agmnt = incentive_on_agmnt_point.split('.')[0]; var incentive_on_agmnt_float = incentive_on_agmnt_point.split('.')[1]; var amount1 = ("" +incentive_on_agmnt).replace(/,/g, ""); x1=amount1.toString(); var lastThree1 = x1.substring(x1.length-3); var otherNumbers1 = x1.substring(0,x1.length-3); if(otherNumbers1 != '') lastThree1 = ',' + lastThree1; var res1 = otherNumbers1.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree1; if(incentive_on_agmnt_float == undefined) { $("input[name=edit_calc_incentive_on_agmnt]").val(res1); } else { $("input[name=edit_calc_incentive_on_agmnt]").val(res1+'.'+incentive_on_agmnt_float); } //------------------------------------------------------------------------------// var incentive_on_regn_point = response.data.incentive_on_regn; var incentive_on_regn = incentive_on_regn_point.split('.')[0]; var incentive_on_regn_float = incentive_on_regn_point.split('.')[1]; var amount2 = ("" +incentive_on_regn).replace(/,/g, ""); x2=amount2.toString(); var lastThree2 = x2.substring(x2.length-3); var otherNumbers2 = x2.substring(0,x2.length-3); if(otherNumbers2 != '') lastThree2 = ',' + lastThree2; var res2 = otherNumbers2.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree2; if(incentive_on_regn_float == undefined) { $("input[name=edit_calc_incentive_on_regn]").val(res2); } else { $("input[name=edit_calc_incentive_on_regn]").val(res2+'.'+incentive_on_regn_float); } //----------------------------------------------------------------------------// var balance_point = response.data.balance; var balance = balance_point.split('.')[0]; var balance_float = balance_point.split('.')[1]; var amount3 = ("" +balance).replace(/,/g, ""); x3=amount3.toString(); var lastThree3 = x3.substring(x3.length-3); var otherNumbers3 = x3.substring(0,x2.length-3); if(otherNumbers3 != '') lastThree3 = ',' + lastThree3; var res3 = otherNumbers3.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree3; if(perc_type == "40%") { if(incentive_on_regn_float == undefined) { $("input[name=edit_calc_balance]").val(res2); } else { $("input[name=edit_calc_balance]").val(res2+'.'+incentive_on_regn_float); } } else if(perc_type == "60%") { if(incentive_on_agmnt_float == undefined) { $("input[name=edit_calc_balance]").val(res1); } else { $("input[name=edit_calc_balance]").val(res1+'.'+incentive_on_agmnt_float); } } else if(perc_type == "0") { if(balance_float == undefined) { $("input[name=edit_calc_balance]").val(res3); } else { $("input[name=edit_calc_balance]").val(res3+'.'+balance_float); } } //------------------------------------------------------------------------// if(perc_type == "40%") { $("select[name=edit_calc_insentive_perc]").val(response.data.insentive_perc); } else if(perc_type == "60%") { $("select[name=edit_calc_insentive_perc]").val(response.data.insentive_perc_sixty); } else if(perc_type == "0") { $("select[name=edit_calc_insentive_perc]").val(response.data.insentive_perc_both); } $("input[name=edit_calc_source]").val(response.data.source); } else { $("input[name=edit_calc_rate_per_sqft]").val(""); $("input[name=edit_calc_total_amount_fixed]").val(""); $("input[name=edit_calc_incentive_on_agmnt]").val(""); $("input[name=edit_calc_incentive_on_regn]").val(""); $("select[name=edit_calc_insentive_perc]").val(""); $("input[name=edit_calc_balance]").val(""); $("input[name=edit_calc_source]").val(""); } } }); $("#edit_model").modal('show'); }); $('#update_form').submit(function(e) { e.preventDefault(); let form = this; // ✅ Save the current form reference let formdata = new FormData(form); $.ajax({ type: 'post', url: '<?php echo site_url("update-insentive-calculation")?>', data: formdata, contentType: false, processData: false, success: function(response) { console.log(response); if (response.result == 1) { toastr["success"](response.message); $("#edit_model").modal('hide'); form.reset(); // ✅ Reset the form using saved reference $(".edit_calc_submit").text("Submit"); $(".edit_calc_submit").removeAttr('disabled'); $("#list3").jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); $("#list20").jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); $("#list5").jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); $("#list9").jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); $("#list1").jqGrid('setGridParam', { datatype: 'json' }).trigger('reloadGrid'); } else { toastr["error"](response.message); $(".edit_calc_submit").text("Submit"); $(".edit_calc_submit").removeAttr('disabled'); } } }); }); </script> <style type="text/css"> a { color: inherit; } .form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus { border-color: #FF0000; box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6); } #FrmGrid_list2 { width: 100% !important; } .ui-jqdialog .ui-jqdialog-titlebar { height: 29px !important; background-color: #001a00; color: white; padding-left: 10px; } .fm-button { height: 21px !important; padding: 1px; margin-right: 10px !important; height: 21px !important; width: 50%; margin-top: -7px !important; } .ui-jqdialog-content td.navButton { padding-top: 12px !important; } .ui-jqgrid .ui-jqgrid-titlebar { height: 27px !important; background:#AF0100 !important; color:white !important; } .ui-jqgrid-bdiv { height: auto !important; } .ui-widget-overlay { z-index:0 !important; } .ui-resizable { z-index:9999 !important; } .ui-widget-header { background: #1e7ad7 !important; } .ui-jqgrid-hdiv ui-state-default { width: 873px !important; cursor: default!important } ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight { border: 1px solid #fed22f; background: #ffe45c; } .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default { font-weight: bold; color: black; } .ui-jqgrid .ui-jqgrid-bdiv { overflow-y: scroll; //overflow-x: hidden; } .agr_appr { font-weight:bold !important; color:#AF0100; cursor: pointer; } .content-wrapper { min-height: 2500px !important; } #div_executives > #land_owner, #div_logistic > #land_owner { padding-top:0; } .ui-state-disabled, .ui-widget-content .ui-state-disabled { opacity: 1.35 !important; } .rowClass { background-color: #f3f098; } </style> <?php echo view('includes/footer');?>