<div class="row"> <div class="col-md-12"> <div class="portlet box purple"> <div class="portlet-title"> <div class="caption"> <i class="fa fa-edit"></i> بحث عن بيانات .. </div> </div> <div class="portlet-body form"> <form action="<?php echo base_url().'work/search_workers_info/export' ?>" method="post" role="form" class="horizontal-form" id="searchForm" name="searchForm" > <div class="form-body"> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-2"> <div class="form-group"> <label class="control-label"> رقم الهوية </label> <input type="text" name="worker_ssn" id="worker_ssn" class="form-control" maxlength="9"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">الاسم</label> <input type="text" value="" name="worker_name" id="worker_name" class="form-control" placeholder=""> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">رقم الوصل : من </label> <input type="text" class="form-control" id="from_serial" name="from_serial"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">رقم الوصل : إلى</label> <input type="text" class="form-control" id="to_serial" name="to_serial"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label"> السنة </label> <input type="text" class="form-control" id="year" name="year"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">الحالة </label> <select name="worker_status" id="worker_status" class="form-control "> <option value=""></option> <?php foreach ($worker_status['out_rs'] as $r): ?> <option value="<?php echo $r['SUB_CD']; ?>"><?php echo $r['ARB_DESC']; ?></option> <?php endforeach; ?> </select> </div> </div> </div> <div class="row"> <div class="col-md-2"> <div class="form-group"> <label class="control-label">رقم التأمين - وزارة الصحة</label> <input type="text" class="form-control" id="moh_insurance_no" name="moh_insurance_no"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">حالة التامين - وزارة الصحة</label> <select class="form-control" id="moh_insurance_status" name="moh_insurance_status"> <option value="-1"></option> <option value="0">مقبول</option> <option value="1">غير مقبول</option> </select> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">من تاريخ</label> <input type="text" class="form-control date" id="from_date" name="from_date"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">الى تاريخ</label> <input type="text" class="form-control date" id="to_date" name="to_date" value=""> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">المدينة</label> <select name="governorate" id="governorate" class="form-control "> <option value=""></option> <?php foreach ($governorate['out_rs'] as $r): ?> <option value="<?php echo $r['SUB_CD']; ?>"><?php echo $r['ARB_DESC']; ?></option> <?php endforeach; ?> </select> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">الحي</label> <select name="city" id="city" class="form-control "> </select> </div> </div> </div> <div class="row"> <div class="col-md-2"> <div class="form-group"> <label class="control-label">الجوال </label> <input type="text" name="mobile" id="mobile" class="form-control" placeholder=""> </div> </div> <div class="col-md-2"> <div class="form-group"> <label class="control-label">المهنة </label> <select name="job" id="job" class="form-control "> <option value=""></option> <?php foreach ($jobs['out_rs'] as $r): ?> <option value="<?php echo $r['SUB_CD']; ?>"><?php echo $r['ARB_DESC']; ?></option> <?php endforeach; ?> </select> </div> </div> </div> </div> </div> </div> <div class="form-actions right"> <button class="btn purple" id="btnSearch" type="button"><i class="fa fa-search"></i> بحث </button> <?php if( $check_admin['o_success'] == 1): ?> <button class="btn green" id="btnExport" type="submit"><i class="fa fa-file-excel-o" ></i> تصدير إكسل </button> <?php endif; ?> <button id="btnClear" class="btn default" type="button">تفريغ</button> </div> <div class="form-body"> <div class="row"> <div class="col-md-12"> <br> <?php $data['name'] = 'data'; $data['GVInfo'] = '' ; $data['columns'] = array( array('label'=>'W_ID','name'=>'W_ID','index'=>'W_ID','hidden'=>true), array('label'=>'insur_id','name'=>'insur_id','index'=>'insur_id','hidden'=>true), array('label'=>'FNAME','name'=>'FNAME','index'=>'FNAME','hidden'=>true), array('label'=>'SNAME','name'=>'SNAME','index'=>'SNAME','hidden'=>true), array('label'=>'TNAME','name'=>'TNAME','index'=>'TNAME','hidden'=>true), array('label'=>'FAMILY','name'=>'FAMILY','index'=>'FAMILY','hidden'=>true), array('label'=>'','name'=>'','index'=>'','formatter'=>'printFormatter','width'=>50), array('label'=>'رقم الهوية','name'=>'SSN','index'=>'SSN','width'=>90), array('label'=>'الاسم','name'=>'FNAME','index'=>'FNAME','formatter'=>'FullNameFormatter', 'cellattr'=>'function (rowId, tv, rawObject, cm, rdata) {return style="white-space: normal;}' ), array('label'=>'هوية الزوجة','name'=>'WIFE_SSN','index'=>'WIFE_SSN','width'=>90), array('label'=>'رقم التأمين','name'=>'CARD_ID','index'=>'CARD_ID','width'=>80), array('label'=>'حالة التأمين','name'=>'INSUR_STATUS_DESC','index'=>'INSUR_STATUS_DESC','width'=>85), array('label'=>'تأمين الصحة','name'=>'MOH_STATUS_DESC','index'=>'MOH_STATUS_DESC','width'=>83), array('label'=>'تاريخ الادخال','name'=>'ENTER_DT','index'=>'ENTER_DT','width'=>85), array('label'=>'المدينة','name'=>'GOV_DESC','index'=>'GOV_DESC','width'=>80), array('label'=>'الحي','name'=>'CITY_DESC','index'=>'CITY_DESC','width'=>100), array('label'=>'الموظف المختص','name'=>'ENTER_USER','index'=>'ENTER_USER','width'=>100, 'cellattr'=>'function (rowId, tv, rawObject, cm, rdata) {return style="white-space: normal;}') ); $data['multiselect'] = false; $data['caption'] = false; if( $check_admin['o_success'] == 1) { array_push($data['columns'],array('label'=>'تعديل','name'=>'','index'=>'','formatter'=>'editFormatter','width'=>50)) ; array_push($data['columns'],array('label'=>'حذف','name'=>'','index'=>'','formatter'=>'deleteFormatter','width'=>45)) ; } $this->load->view('grid_view',$data); ?> <br> </div> </div> </div> </form> </div> </div> </div> </div> <div class="_gridCaption hide"> <span><a id="printAll" name="printAll" target="_blank" href="javascript:;" data-original-title="طباعة التأمينات " class="btn blue"><i class="fa fa-print"></i> طباعة التأمينات </a></span> </div> <div class="hide output"> <div id="output_iframe" name="output_iframe" style="width: auto;height: 100%;overflow-y: scroll;" ></div> </div> <script> $(document).ready(function () { $('#job').select2(); var mainForm = $('#searchForm'); $('#btnSearch').die().live('click', function () { if (mainForm.validationEngine('validate') == true) { var data = 'action=search&' + mainForm.serialize(); var dfd = do_ajax({ parms:data, handler:'work/search_workers_info' }); dfd.then(function (r) { reloadGrid($('#data_GV'),r['out_rs']); }); } }); $('#governorate').change(function () { var code = $(this).val(); if (code != '') var data = {action:'getCities', code:code}; var dfd = do_ajax({ parms:data, handler:'work/add_workers_info', dataType:'html' }); dfd.then(function (r) { $('#city').html(r).select2(); }); }); $('#btnClear').click(function () { $('input[type=text]').val(''); $('select').val(''); $('job').val('').select2(); }); $('#printAll').die().live('click',function () { var workerId = ''; var insuranceId = ''; var delm = '' var $grid = $("#data_GV"), selIds = $grid.jqGrid("getGridParam", "selarrrow"), i, n, cellValues = [],workValues = []; for (i = 0, n = selIds.length; i < n; i++) { //workValues.push($grid.jqGrid("getCell", selIds[i], "W_ID")); workerId += delm+$grid.jqGrid("getCell", selIds[i], "W_ID");delm='@'; } delm =''; for (i = 0, n = selIds.length; i < n; i++) { //cellValues.push($grid.jqGrid("getCell", selIds[i], "insur_id")); insuranceId += delm+$grid.jqGrid("getCell", selIds[i], "insur_id");delm='@'; } $('#printAll').attr('href','<?php echo base_url().'work/print_all_insurance'; ?>/'+btoa(workerId)+'/'+btoa(insuranceId)); }); $('.deleteBtn').die().live('click',function(){ var rowId = $(this).attr('data-id'); var row = $('#data_GV').getRowData(rowId); var workerId = row['W_ID']; var insuranceId = row['insur_id']; showMessage('تنبيه','سيتم حذف بيانات العامل و التأمين الخاص به .. هل أنت متأكد ؟ ','confirm','حذف',function(){ var data = 'action=deleteInsurance&insuranceId='+insuranceId+'&workerId='+workerId ; var dfd = do_ajax({ parms:data, handler: 'work/show_insurances' }); dfd.then(function (r) { if (r['o_success'] == 1) { delGridRow($('#data_GV'),'W_ID',workerId); showMessage('رسالة', 'تم الحذف بنجاح ... ', 'done', '', ''); } if (r['o_success'] == 0) { showMessage('خطأ', r['o_msgtxt'], 'alert', '', ''); } }); }); }); $('.printBtn').die().live('click',function(){ var rowId = $(this).attr('data-id'); var row = $('#data_GV').getRowData(rowId); var workerId = row['W_ID']; var insuranceId = row['insur_id']; var options = { content:'<?php echo base_url().'work/print_insurance'; ?>/'+workerId+'/'+insuranceId,backOpacity:0.4 , width:900,height:450}; popup = new $.Popup(options); popup.open(); }); }); function FullNameFormatter(cellvalue, options, rowObject){ return rowObject['FNAME']+' '+rowObject['SNAME']+' '+rowObject['TNAME']+' '+rowObject['FAMILY']; } function editFormatter(cellvalue, options, rowObject){ return '<a href="<?php echo base_url().'work/edit_worker_info/'; ?>'+rowObject['W_ID']+'/'+rowObject['insur_id']+'" class="editBtn"><i class="font-blue fa fa-edit"></i></a>'; } function deleteFormatter(cellvalue, options, rowObject){ return '<a data-id="'+options['rowId']+'" href="#" class="btn deleteBtn"><i class="fa fa-trash font-red"></i></a>'; } function printFormatter(cellvalue, options, rowObject){ return '<a data-id="'+options['rowId']+'" href="#" class="btn printBtn"><i class="fa fa-print font-purple"></i></a>'; } </script>