File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/workflow/models/Workflow_model.php
Back
<?php Class Workflow_model extends CI_Model{ ///////////by Jack function getForms_2() { //$this->db->select('id,title'); //return $this->db->get('form')->result_array(); $workflows ="SELECT `form`.`id`,`form`.`title`,`wf_form_workflow`.`wid`,`wf_form_workflow`.`fid` FROM `form` LEFT JOIN `wf_form_workflow` ON `wf_form_workflow`.`fid` =`form`.`id` where `wf_form_workflow`.`enable`!=0 order by `form`.`id` "; $workflows = $this->db->query($workflows); return $workflows->result_array(); } function getWorkflows() { //return $this->db->get('wf_form_workflow')->result_array(); $workflows ="SELECT wf_form_workflow.*,wf_workflow.title as wftitle,form.title as ftitle FROM `wf_form_workflow` INNER JOIN `form` ON `form`.`id`=`wf_form_workflow`.`fid` INNER JOIN `wf_workflow` ON `wf_workflow`.`id`=`wf_form_workflow`.`wid` where `wf_form_workflow`.`enable`!=0"; $workflows = $this->db->query($workflows); return $workflows->result_array(); } function getWorkflowForms() { $workflows ="SELECT wf_form_workflow.*, wf_workflow.title,wf_workflow.urgent_days,form.title as ftitle FROM `wf_form_workflow` INNER JOIN `form` ON `form`.`id`=`wf_form_workflow`.`fid` INNER JOIN wf_workflow ON `wf_form_workflow`.`wid`=`wf_workflow`.`id` where `wf_form_workflow`.`enable`!=0"; $workflows = $this->db->query($workflows); // print_r($workflows->result_array());die; return $workflows->result_array(); } function getForms() { $workflows ="SELECT `form`.`id`,`form`.`title`,`wf_form_workflow`.`fid` FROM `form` LEFT JOIN `wf_form_workflow` ON `wf_form_workflow`.`fid` =`form`.`id` WHERE `wf_form_workflow`.`fid` is NULL order by `form`.`id` "; $workflows = $this->db->query($workflows); return $workflows->result_array(); } function getFormsEditworkflow($id) { $workflows ="SELECT `form`.`id`,`form`.`title`,`wf_form_workflow`.`fid` FROM `form` LEFT JOIN `wf_form_workflow` ON `wf_form_workflow`.`fid` =`form`.`id` WHERE `wf_form_workflow`.`fid` is NULL"; $workflows = $this->db->query($workflows); $forms=$workflows->result_array(); $workflows ="SELECT `form`.`id`,`form`.`title`,`wf_form_workflow`.`fid` FROM `form` LEFT JOIN `wf_form_workflow` ON `wf_form_workflow`.`fid` =`form`.`id` WHERE `wf_form_workflow`.`wid` =$id"; $workflows = $this->db->query($workflows); $workflowforms=$workflows->result_array(); return array_merge($forms, $workflowforms); } function getWorkflow($id = 0) { return $this->db->get_where('wf_workflow',array('id' => $id))->row_array(); } function addWorkflow($title,$urgent,$form,$workflow) { $data=array("title"=>$title,"urgent_days"=>$urgent,"workflow"=> json_encode($workflow)); $this->db->insert('wf_workflow',$data); $wid=$this->db->insert_id(); foreach($form as $key=>$value) { $data=array('fid'=>$value,'wid'=>$wid); $this->db->insert('wf_form_workflow',$data); } return true; } function editWorkflow($title,$urgent,$form,$workflow,$id) { $data=array("title"=>$title,"urgent_days"=>$urgent,"workflow"=> json_encode($workflow)); $this->db->update('wf_workflow',$data,array('id'=>$id)); $wid=$id; $this->db->delete('wf_form_workflow',array('wid' => $id)); foreach($form as $key=>$value) { $data=array('fid'=>$value,'wid'=>$id); $this->db->insert('wf_form_workflow',$data); } return true; } function deleteWorkflow($id) { $this->db->delete('wf_form_workflow',array('wid' => $id)); return $this->db->delete('wf_workflow',array('id' => $id)); } }
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.42 |
proxy
|
phpinfo
|
Settings