<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>