コード例 #1
0
ファイル: News.php プロジェクト: KanexKane/hrsystem
 public function edit($news_id)
 {
     //form validation
     $rules = array(array("field" => "input_newstype", "label" => "ประเภทข่าว", "rules" => "greater_than[0]"), array("field" => "input_topic", "label" => "หัวข้อข่าว", "rules" => "trim|required|max_length[200]"));
     $this->form_validation->set_rules($rules);
     $this->form_validation->set_message("greater_than", "- เลือกประเภทข่าว");
     $this->form_validation->set_message("required", "- กรอกหัวข้อข่าว");
     if ($this->form_validation->run() === true) {
         $this->_save_edit();
         redirect("admin/News");
         exit;
     } else {
         //get data news
         $query = $this->news->get_detail_by_id($news_id);
         $query = $query->row_array();
         if (count($query) > 0) {
             //get data news image
             $query_image = $this->newsimage->get_list_by_news_id($news_id);
             $query_image = $query_image->result_array();
             //set data
             $data = array();
             $data["dropdownlist_newstype"] = $this->newstype->get_list_for_dropdownlist();
             $data["value_newstype"] = $query["news_newstype_id"];
             $data["value_topic"] = $query["news_topic"];
             $data["value_detail"] = $query["news_detail"];
             $data["value_show_start_date"] = dateThaiFormatUn543FromDB($query["news_show_start_date"]);
             $data["value_show_end_date"] = dateThaiFormatUn543FromDB($query["news_show_end_date"]);
             $data["value_news_image"] = $query_image;
             $data["value_news_id"] = $news_id;
             //load view
             parent::setHeaderAdmin($this->lang->line("title_page_news_edit"));
             $this->load->view("admin/News/Add", $data);
             parent::setFooterAdmin();
         } else {
             redirect("admin/News");
         }
     }
 }
コード例 #2
0
ファイル: Holiday.php プロジェクト: KanexKane/hrsystem
	<div class="row">
		<div class="col s12 m8 offset-m2 l6 offset-l3 center-align">
			<table class="bordered highlight">
				<thead>
					<tr>
						<th>วันที่</th>
						<th>ชื่อวันหยุด</th>
					</tr>
				</thead>
				<tbody>
					<?php 
foreach ($query as $row) {
    ?>
						<tr>
							<td><?php 
    echo dateThaiFormatUn543FromDB($row["HDate"]);
    ?>
</td>
							<td><?php 
    echo $row["HName"];
    ?>
</td>
						</tr>
					<?php 
}
?>
				</tbody>
			</table>
		</div>
	</div>
</div>
コード例 #3
0
ファイル: Detail.php プロジェクト: KanexKane/hrsystem
">
			<label for="txtStartDate">วันที่ขอลา</label>
		</div>
		<div class="input-field col s2">
			<input readonly="true" type="text" id="txtStartTime" name="txtStartTime" value="<?php 
echo timeFormatNotSecond($leave_detail['LStartTime']);
?>
">
			<label for="txtStartTime">เวลา</label>
		</div>
		<div class="input-field col s2">
			&nbsp;
		</div>
		<div class="input-field col s3">
			<input readonly="true" type="text" id="txtEndDate" name="txtEndDate" value="<?php 
echo dateThaiFormatUn543FromDB($leave_detail['LEndDate']);
?>
">
			<label readonly="true" for="txtEndDate">ลาถึงวันที่</label>
		</div>
		<div class="input-field col s2">
			<input readonly="true" type="text" id="txtEndTime" name="txtEndTime" value="<?php 
echo timeFormatNotSecond($leave_detail['LEndTime']);
?>
">
			<label for="txtEndTime">เวลา</label>
		</div>
	</div>
</div>

<div class="row">
コード例 #4
0
ファイル: Employees.php プロジェクト: KanexKane/hrsystem
 public function Detail($empID)
 {
     if (!$this->acl->hasPermission("manage_employee")) {
         redirect("hr/Employees");
         exit;
     }
     $user_id = 0;
     $data = $this->setDefaultDataPage();
     $data["nowTitle"] = "แก้ไขข้อมูลพนักงาน";
     $data["FormUrl"] = site_url("hr/Employees/EditEmployee");
     $data["menu_sub_header"] = "Edit Employee";
     $data["menu_header_medium"] = "Edit / แก้ไขข้อมูลพนักงาน";
     $data["menu_header_small"] = "Edit / แก้ไขข้อมูลพนักงาน";
     $query = $this->employees->getDetailByEmpID($empID);
     if ($query->num_rows() > 0) {
         $query = $query->result_array();
         $query = $query[0];
         $user_id = $query["UserID"];
         $data["empID"] = $empID;
         $data['queryDepartment'] = $this->department->getListForDropdownlist();
         $data["empDepartmentID"] = $query['Emp_DepartmentID'];
         $data["empSectionID"] = $query["Emp_SectionID"];
         $data["empUnitID"] = $query["Emp_UnitID"];
         $data["empGroupID"] = $query["Emp_GroupID"];
         if ($data["empDepartmentID"] != 0) {
             $data["querySection"] = $this->section->getListForDropdownlist($data["empDepartmentID"]);
             if ($data["empSectionID"] != 0) {
                 $data["queryUnit"] = $this->unit->getListForDropdownlist($data["empSectionID"]);
                 if ($data["empUnitID"] != 0) {
                     $data["queryGroup"] = $this->group->getListForDropdownlist($data["empUnitID"]);
                 }
             }
         }
         $data['queryPosition'] = $this->position->getListForDropdownlist();
         $data['empPositionID'] = $query['Emp_PositionID'];
         //get headman
         //gen headman dropdown by department
         $query_headman = $this->empheadman->get_list_by_user_id($user_id);
         $headman_rows = $query_headman->num_rows();
         if ($headman_rows > 0) {
             $query_headman = $query_headman->result_array();
             for ($i = 0; $i < $headman_rows; $i++) {
                 $headman_level = $query_headman[$i]["eh_headman_level"];
                 $data["empHeadmanID_level_" . $query_headman[$i]["eh_headman_level"]] = $query_headman[$i]["eh_headman_user_id"];
                 if ($headman_level == 1) {
                     $data["queryHeadman_level_1"] = $this->get_list_headman($data["empSectionID"], $data["empID"]);
                 } else {
                     if ($headman_level == 2) {
                         $data["queryHeadman_level_2"] = $this->get_list_headman($data["empSectionID"], $data["empID"], $data["empHeadmanID_level_1"]);
                     } else {
                         $data["queryHeadman_level_3"] = $this->get_list_headman($data["empSectionID"], $data["empID"], $data["empHeadmanID_level_1"], $data["empHeadmanID_level_2"]);
                     }
                 }
             }
         } else {
             $data["queryHeadman_level_1"] = $this->get_list_headman($data["empSectionID"], $data["empID"]);
         }
         //dateThaiFormatFromDB is function from common_helper.
         $data['empStartWorkDate'] = dateThaiFormatUn543FromDB($query['EmpStartWorkDate']);
         $data['empSuccessTrialWorkDate'] = dateThaiFormatUn543FromDB($query['EmpSuccessTrialWorkDate']);
         $data['empSalary'] = $query['EmpSalary'];
         $data["empUsername"] = $query['Username'];
         $data["empPassword"] = $query['Password'];
         $data["empNameTitleThai"] = $query['EmpNameTitleThai'];
         $data["empFirstnameThai"] = $query['EmpFirstnameThai'];
         $data["empLastnameThai"] = $query['EmpLastnameThai'];
         $data["empNameTitleEnglish"] = $query['EmpNameTitleEnglish'];
         $data["empFirstnameEnglish"] = $query['EmpFirstnameEnglish'];
         $data["empLastnameEnglish"] = $query['EmpLastnameEnglish'];
         $data["empCallName"] = $query['EmpCallname'];
         $data["empTelePhone"] = $query['EmpTelephone'];
         $data["empMobilePhone"] = $query['EmpMobilePhone'];
         $data["empEmail"] = $query['EmpEmail'];
         $data["empBirthPlace"] = $query['EmpBirthPlace'];
         $data["empSex"] = $query['EmpSex'];
         $data["empHeight"] = $query['EmpHeight'];
         $data["empWeight"] = $query['EmpWeight'];
         $data["empBlood"] = $query['EmpBlood'];
         $data["empNationality"] = $query['EmpNationality'];
         $data["empRace"] = $query['EmpRace'];
         $data["empReligion"] = $query['EmpReligion'];
         $data["empMartialStatus"] = $query['Emp_MARSID'];
         $data["empMilitaryStatus"] = $query['EmpMilitaryStatus'];
         $data["empMilitaryReason"] = $query['EmpMilitaryReason'];
         $data["empNumberOfChildren"] = $query["EmpNumberOfChildren"];
         $data["empNumberOfBrother"] = $query["EmpNumberOfBrother"];
         $data["empIDCard"] = $query['EmpIDCard'];
         $data["empIDCardImg"] = $query['EmpIDCardImg'];
         $data["empAddressNumber"] = $query['EmpAddressNumber'];
         $data["empAddressMoo"] = $query['EmpAddressMoo'];
         $data["empAddressRoad"] = $query['EmpAddressRoad'];
         //bind dropdownlist district,amphur,province
         $data["empAddressProvince"] = $query['Emp_ProvinceID'];
         $data['queryAmphur'] = $this->amphur->getListForDropDown($data['empAddressProvince']);
         $data["empAddressAmphur"] = $query['Emp_AmphurID'];
         $data['queryDistrict'] = $this->district->getListForDropDown($data['empAddressProvince'], $data['empAddressAmphur']);
         $data["empAddressDistrict"] = $query['Emp_DistrictID'];
         $data['queryZipcode'] = $this->zipcode->getListForDropDown($data['empAddressProvince'], $data['empAddressAmphur'], $data['empAddressDistrict']);
         $data["empAddressZipcode"] = $query['Emp_ZipcodeID'];
         $data["empAddressImg"] = $query['EmpAddressImg'];
         $data["empPictureImg"] = $query['EmpPictureImg'];
         #### บุคคลอื่นที่ติดต่อได้ ####
         $data["empNameTitleFriend"] = $query['EmpFriendNameTitleThai'];
         $data["empFirstnameFriend"] = $query['EmpFriendFirstnameThai'];
         $data["empLastnameFriend"] = $query['EmpFriendLastnameThai'];
         $data["empAddressNumberFriend"] = $query['EmpFriendAddressNumber'];
         $data["empAddressMooFriend"] = $query['EmpFriendAddressMoo'];
         $data["empAddressRoadFriend"] = $query['EmpFriendAddressRoad'];
         $data["empAddressProvinceFriend"] = $query['EmpFriend_ProvinceID'];
         $data["empAddressAmphurFriend"] = $query['EmpFriend_AmphurID'];
         $data["empAddressDistrictFriend"] = $query['EmpFriend_DistrictID'];
         $data["empAddressZipcodeFriend"] = $query['EmpFriend_ZipcodeID'];
         if ($data['empAddressProvinceFriend'] != 0) {
             $data['queryAmphurFriend'] = $this->amphur->getListForDropDown($data['empAddressProvinceFriend']);
             $data['queryDistrictFriend'] = $this->district->getListForDropDown($data['empAddressProvinceFriend'], $data['empAddressAmphurFriend']);
             $data['queryZipcodeFriend'] = $this->zipcode->getListForDropDown($data['empAddressProvinceFriend'], $data['empAddressAmphurFriend'], $data['empAddressDistrictFriend']);
         }
         $data["empTelePhoneFriend"] = $query['EmpFriendTelephone'];
         $data["empMobilePhoneFriend"] = $query['EmpFriendMobilePhone'];
         #### ประวัติบิดา ####
         $data["empNameTitleFather"] = $query['EmpFatherNameTitleThai'];
         $data["empFirstnameFather"] = $query['EmpFatherFirstnameThai'];
         $data["empLastnameFather"] = $query['EmpFatherLastnameThai'];
         $data["empAddressNumberFather"] = $query['EmpFatherAddressNumber'];
         $data["empAddressMooFather"] = $query['EmpFatherAddressMoo'];
         $data["empAddressRoadFather"] = $query['EmpFatherAddressRoad'];
         $data["empAddressProvinceFather"] = $query['EmpFather_ProvinceID'];
         $data["empAddressAmphurFather"] = $query['EmpFather_AmphurID'];
         $data["empAddressDistrictFather"] = $query['EmpFather_DistrictID'];
         $data["empAddressZipcodeFather"] = $query['EmpFather_ZipcodeID'];
         if ($data['empAddressProvinceFather'] != 0) {
             $data['queryAmphurFather'] = $this->amphur->getListForDropDown($data['empAddressProvinceFather']);
             $data['queryDistrictFather'] = $this->district->getListForDropDown($data['empAddressProvinceFather'], $data['empAddressAmphurFather']);
             $data['queryZipcodeFather'] = $this->zipcode->getListForDropDown($data['empAddressProvinceFather'], $data['empAddressAmphurFather'], $data['empAddressDistrictFather']);
         }
         $data["empTelePhoneFather"] = $query['EmpFatherTelephone'];
         $data["empMobilePhoneFather"] = $query['EmpFatherMobilePhone'];
         #### ประวัติมารดา ####
         $data["empNameTitleMother"] = $query['EmpMotherNameTitleThai'];
         $data["empFirstnameMother"] = $query['EmpMotherFirstnameThai'];
         $data["empLastnameMother"] = $query['EmpMotherLastnameThai'];
         $data["empAddressNumberMother"] = $query['EmpMotherAddressNumber'];
         $data["empAddressMooMother"] = $query['EmpMotherAddressMoo'];
         $data["empAddressRoadMother"] = $query['EmpMotherAddressRoad'];
         $data["empAddressProvinceMother"] = $query['EmpMother_ProvinceID'];
         $data["empAddressAmphurMother"] = $query['EmpMother_AmphurID'];
         $data["empAddressDistrictMother"] = $query['EmpMother_DistrictID'];
         $data["empAddressZipcodeMother"] = $query['EmpMother_ZipcodeID'];
         if ($data['empAddressProvinceMother'] != 0) {
             $data['queryAmphurMother'] = $this->amphur->getListForDropDown($data['empAddressProvinceMother']);
             $data['queryDistrictMother'] = $this->district->getListForDropDown($data['empAddressProvinceMother'], $data['empAddressAmphurMother']);
             $data['queryZipcodeMother'] = $this->zipcode->getListForDropDown($data['empAddressProvinceMother'], $data['empAddressAmphurMother'], $data['empAddressDistrictMother']);
         }
         $data["empTelePhoneMother"] = $query['EmpMotherTelephone'];
         $data["empMobilePhoneMother"] = $query['EmpMotherMobilePhone'];
         #### ที่อยู่ตามทะเบียนบ้าน ####
         $data["empAddressNumberHouseReg"] = $query['EmpHouseRegAddressNumber'];
         $data["empAddressMooHouseReg"] = $query['EmpHouseRegAddressMoo'];
         $data["empAddressRoadHouseReg"] = $query['EmpHouseRegAddressRoad'];
         $data["empAddressProvinceHouseReg"] = $query['EmpHouseReg_ProvinceID'];
         $data["empAddressAmphurHouseReg"] = $query['EmpHouseReg_AmphurID'];
         $data["empAddressDistrictHouseReg"] = $query['EmpHouseReg_DistrictID'];
         $data["empAddressZipcodeHouseReg"] = $query['EmpHouseReg_ZipcodeID'];
         if ($data['empAddressProvinceHouseReg'] != 0) {
             $data['queryAmphurHouseReg'] = $this->amphur->getListForDropDown($data['empAddressProvinceHouseReg']);
             $data['queryDistrictHouseReg'] = $this->district->getListForDropDown($data['empAddressProvinceHouseReg'], $data['empAddressAmphurHouseReg']);
             $data['queryZipcodeHouseReg'] = $this->zipcode->getListForDropDown($data['empAddressProvinceHouseReg'], $data['empAddressAmphurHouseReg'], $data['empAddressDistrictHouseReg']);
         }
         #### เอกสารการสมัครงาน ####
         $data["empDocumentRegisterJobImg"] = $query['EmpDocRegisterJobImg'];
         #### วันเกิด ####
         $empBirthDay = $query['EmpBirthday'];
         if ($empBirthDay !== '0000-00-00' && $empBirthDay !== null) {
             $empBirthDay = array();
             $empBirthDay = explode('-', $query['EmpBirthday']);
             $data["birthDayDay"] = $empBirthDay[2];
             $data["birthDayMonth"] = $empBirthDay[1];
             $data["birthDayYear"] = $empBirthDay[0];
         }
         #### ธนาคาร ####
         $data["empBankID"] = $query['Emp_BankID'];
         $data["empBankType"] = $query['Emp_BankTypeID'];
         $data["empBankBranch"] = $query['EmpBankBranch'];
         $data["empBankNumber"] = $query['EmpBankNumber'];
         $data["empBankImg"] = $query['EmpBankImg'];
         #### ประวัติการทำงาน ####
         $query = $this->hiswork->get_list_by_user_id($user_id);
         $data["query_history_work"] = $query->result_array();
         #### ประวัติการศึกษา ####
         $query = $this->hisstudy->get_list_by_user_id($user_id);
         $data["query_history_study"] = $query->result_array();
         #### กะงาน ####
         $queryEmpShiftwork = $this->empshiftwork->getListByUserId($user_id);
         $data["queryEmpShiftwork"] = $queryEmpShiftwork->result_array();
     }
     parent::setHeader('รายละเอียดพนักงาน', "HR", FALSE, FALSE);
     $this->load->view("hr/Employee/Register", $data);
     parent::setFooter();
 }
コード例 #5
0
ファイル: Overtime.php プロジェクト: KanexKane/hrsystem
 public function edit($ot_id)
 {
     if ($_POST) {
         $this->_save($ot_id);
         exit;
     }
     $query = $this->ot->get_detail_by_id($ot_id)->row_array();
     if (count($query) > 0) {
         $data = array();
         $data["value_ot_date"] = dateThaiFormatUn543FromDB($query["wot_date"]);
         $data["value_ot_time_from"] = $query["wot_time_from"];
         $data["value_ot_time_to"] = $query["wot_time_to"];
         $data["value_ot_remark"] = $query["wot_remark"];
         parent::setHeader("แก้ไขใบขอทำงานล่วงเวลา", "OT");
         $this->load->view('worktime/ot_add', $data);
         parent::setFooter();
     }
 }
コード例 #6
0
ファイル: Holiday.php プロジェクト: KanexKane/hrsystem
 public function edit($hid)
 {
     //form validation
     $rules = array(array("field" => "input_name", "label" => "ชื่อวันหยุด", "rules" => "trim|required|max_length[200]"), array("field" => "input_date", "label" => "วันหยุด", "rules" => "trim|required"));
     $this->form_validation->set_rules($rules);
     $this->form_validation->set_message("max_length", "- ข้อความไม่เกิน 200 ตัวอักษร");
     $this->form_validation->set_message("required", "- กรอกหัวข้อข่าว");
     if ($this->form_validation->run() === TRUE) {
         $this->_save();
         redirect("hr/Holiday");
         exit;
     } else {
         $query = $this->holiday->get_detail_by_id($hid);
         $query = $query->row_array();
         $data = array();
         $data["value_name"] = $query["HName"];
         $data["value_desc"] = $query["HDesc"];
         $data["value_date"] = dateThaiFormatUn543FromDB($query["HDate"]);
         $data["value_hid"] = $hid;
         parent::setHeader("แก้ไขวันหยุด", "HR");
         $this->load->view("hr/Holiday/add", $data);
         parent::setFooter();
     }
 }
コード例 #7
0
ファイル: Leave.php プロジェクト: KanexKane/hrsystem
 public function edit($userID, $leaveID)
 {
     $this->load->model("Configuration_Model", "configuration");
     $this->load->model("LeaveQuota_Model", "leavequota");
     $query = $this->leave->getDetail($this->user_id, $leaveID);
     $query = $query->row_array();
     $leaveTypeID = $query["L_LTID"];
     $data = array();
     $data['pagetype'] = 'edit';
     if ($query["L_WFID"] == 11) {
         $data['pagetype'] = 'editdoc';
     }
     $data["FormUrl"] = site_url("Leave/save");
     $data["leaveID"] = $query["LID"];
     $data["empID"] = $this->emp_id;
     $data["userID"] = $this->user_id;
     $data["nowTitle"] = "แก้ไขใบลา";
     $data["title"] = $data["nowTitle"];
     $data["ddlLeaveType"] = $this->leavetype->getListForDropDown();
     $data["vddlLeaveType"] = $query["L_LTID"];
     $data["queryEmployee"] = getEmployeeDetail($data["empID"]);
     $queryLeaveType = $this->leavetype->getDetailByID($leaveTypeID)->result_array();
     $queryLeaveType = $queryLeaveType[0];
     $queryQuota = $this->leavequota->getQuota($this->user_id, $leaveTypeID)->result_array();
     $queryQuota = $queryQuota[0];
     $quotaDetail = "<p>คุณมีสิทธิ์ในการลาได้ทั้งหมด " . $queryQuota["LQQuota"] . " วัน";
     $quotaDetail .= "<br/>คุณใช้สิทธิ์ในการลาไปแล้ว " . $queryQuota["LQUsedDay"] . " วัน " . $queryQuota["LQUsedHour"] . " ชั่วโมง</p>";
     $data["vdetailLeave"] = $queryLeaveType["LTDesc"] . $quotaDetail;
     $data["vleaveBecause"] = $query["LBecause"];
     $queryWork = $this->configuration->getWorkTimeStartTimeEnd()->result_array();
     $data["workTimeStart"] = $queryWork[0]["CFValue"];
     $data["workTimeEnd"] = $queryWork[1]["CFValue"];
     $queryWork = $this->configuration->getWorkDateStartDateEnd()->result_array();
     $data["workDateStart"] = $queryWork[0]["CFValue"];
     $data["workDateEnd"] = $queryWork[1]["CFValue"];
     //ที่ใช้แตกต่างกับอันอื่นเพราะเป็นหน้าข้างในต่างหาก ไม่เหมือนพวกหน้ารายการ
     $data["vworkDateStart"] = dateThaiFormatUn543FromDB($query["LStartDate"]);
     $data["vworkDateEnd"] = dateThaiFormatUn543FromDB($query["LEndDate"]);
     $data["vworkTimeStart"] = timeFormatNotSecond($query["LStartTime"]);
     $data["vworkTimeEnd"] = timeFormatNotSecond($query["LEndTime"]);
     //get leave documents
     $query = $this->leavedoc->get_list_by_leave_id($leaveID);
     $data["query_leave_doc"] = $query->result_array();
     parent::setHeader('แก้ไขใบลา', "Leave");
     $this->load->view("Leave/Add", $data);
     parent::setFooter();
 }