/** * 更新立项数据 * @param int $fid * @param string $borad * @param string $task */ public function update_data($info, $fid) { //------------------- $sql = "SELECT * FROM `tools_setup` WHERE id = {$fid}"; $query = $this->db->query($sql); $old_data = $query->result_array(); in_log('tools', array('tid' => $fid, 'ttype' => 'setup', 'title' => '更新立项', 'contents' => '更新立项信息', 'old_data' => serialize($old_data))); //------------------- unset($info['other']['name'][0]); unset($info['other']['value'][0]); $info['describ'] = str_replace("\n", "<br/>", $info['describ']); $info['background'] = str_replace("\n", "<br/>", $info['background']); $info['demand'] = str_replace("\n", "<br/>", $info['demand']); $info['meaning'] = str_replace("\n", "<br/>", $info['meaning']); //更新Borad $sql = "UPDATE `tools_setup` SET \n\t\t\t\tbname = '" . $info['bname'] . "'\n\t\t\t\t,describ='" . $info['describ'] . "'\n\t\t\t\t,background='" . $info['background'] . "'\n\t\t\t\t,demand='" . $info['demand'] . "'\n\t\t\t\t,meaning='" . $info['meaning'] . "'\n\t\t\t\t,other='" . addslashes(serialize($info['other'])) . "' \n\t\t\t\tWHERE id = {$fid}"; $this->db->query($sql); }
/** * 更新数据 * @param int $fid * @param string $borad * @param string $task */ public function update_data($bname, $meeting, $fid) { //------------------- $sql = "SELECT * FROM `tools_meeting` WHERE id = {$fid}"; $query = $this->db->query($sql); $old_data['meeting'] = $query->row_array(); $sql = "SELECT * FROM `tools_meeting_list` WHERE fid = {$fid}"; $query = $this->db->query($sql); $old_data['list'] = $query->result_array(); in_log('tools', array('tid' => $fid, 'ttype' => 'meeting', 'title' => '更新会议', 'contents' => '更新会议', 'old_data' => serialize($old_data))); //------------------- //更新plan $sql = "UPDATE `tools_meeting` SET bname = '" . $bname . "' WHERE id = {$fid}"; $this->db->query($sql); //更新Task $sql = "UPDATE `tools_meeting_list` SET is_del = '1' WHERE fid = {$fid}"; $this->db->query($sql); for ($i = 1; $i < count($meeting['id']); $i++) { if ($meeting['id'][$i]) { $sql = "UPDATE `tools_meeting_list` SET is_del = 0, \n\t\t\t\t\t\tmname = '" . $meeting['mname'][$i] . "'\n\t\t\t\t\t\t,begintime='" . $meeting['begintime'][$i] . "'\n\t\t\t\t\t\t,people='" . $meeting['people'][$i] . "'\n\t\t\t\t\t\t,info='" . $meeting['info'][$i] . "'\n\t\t\t\t\t\t,memo='" . $meeting['memo'][$i] . "'\n\t\t\t\tWHERE id = '" . $meeting['id'][$i] . "'"; } else { $sql = "INSERT INTO `tools_meeting_list` (fid,mname,begintime,people,info,memo) VALUES "; $sql .= "('" . $fid . "','" . $meeting['mname'][$i] . "','" . $meeting['begintime'][$i] . "','" . $meeting['people'][$i] . "','" . $meeting['info'][$i] . "','" . $meeting['memo'][$i] . "')"; } $this->db->query($sql); } }
/** * 更新任务剩余工作量 * @param unknown $tid * @param unknown $tdate * @param unknown $dwz * @param unknown $val * @return boolean|string */ public function update_task($tid, $tdate, $dwz, $val) { $sql = "SELECT id,workload,fid FROM `tools_tasks_list` WHERE id = '{$tid}'"; $query = $this->db->query($sql); $tdata = $query->row_array(); //------------------- $old_data = $tdata; in_log('tools', array('tid' => $tdata['fid'], 'ttype' => 'tasks', 'title' => '更新任务剩余工作量', 'contents' => '任务ID:' . $tid . ';时间:' . $tdate . ';剩余:' . $val, 'old_data' => serialize($old_data))); //------------------- //$tdata = $this->fetch_one($sql); if ($this->get_id($dwz, 'dwz') == $tdata['fid']) { if ($tdata['id'] > 0) { $workload = json_decode($tdata['workload'], true); $workload[$tdate] = $val; $workload = json_encode($workload); $sql = "UPDATE `tools_tasks_list` SET workload = '{$workload}' WHERE id = '{$tid}'"; $this->db->query($sql); return TRUE; } else { return "故事不存在!"; } } else { return "故事不存在!"; } }
/** * 添加单一文档 * @param int $fid * @param string $borad * @param string $task */ public function upload_docs($info, $fid, $dwz) { //-------------------- in_log('tools', array('tid' => $fid, 'ttype' => 'docs', 'title' => '上传文件', 'contents' => '上传文件(' . $info['fname'] . ')', 'old_data' => '')); //------------------- $sql = "INSERT INTO `tools_docs_list` (fid,fname,fsize,ftype,updatetime,dwz) \n\t\t\t\tvalues('" . $fid . "','" . $info['fname'] . "','" . $info['fsize'] . "','" . $info['ftype'] . "','" . $info['updatetime'] . "','" . $dwz . "')"; $this->db->query($sql); }
/** * 更新数据 * @param int $fid * @param string $borad * @param string $task */ public function update_data($plan, $task, $milestone, $fid) { //------------------- $sql = "SELECT * FROM `tools_plan` WHERE id = {$fid}"; $query = $this->db->query($sql); $old_data['plan'] = $query->row_array(); $sql = "SELECT * FROM `tools_plan_task` WHERE fid = {$fid}"; $query = $this->db->query($sql); $old_data['list'] = $query->result_array(); in_log('tools', array('tid' => $fid, 'ttype' => 'plan', 'title' => '更新计划', 'contents' => '更新计划', 'old_data' => serialize($old_data))); //------------------- //更新plan $sql = "UPDATE `tools_plan` SET bname = '" . $plan['bname'] . "',begintime='" . $plan['begintime'] . "',endtime='" . $plan['endtime'] . "',exceptdays='" . json_encode($plan['exceptdays']) . "' WHERE id = {$fid}"; $this->db->query($sql); //更新Task $sql = "UPDATE `tools_plan_task` SET is_del = '1' WHERE fid = {$fid}"; $this->db->query($sql); for ($i = 1; $i < count($task['id']); $i++) { if ($task['id'][$i]) { $sql = "UPDATE `tools_plan_task` SET is_del = 0, \n\t\t\t\t\t\ttitle = '" . $task['title'][$i] . "'\n\t\t\t\t\t\t,describ='" . $task['describ'][$i] . "'\n\t\t\t\t\t\t,owner='" . $task['owner'][$i] . "'\n\t\t\t\t\t\t,pdays='" . $task['pdays'][$i] . "'\n\t\t\t\t\t\t,expstrt='" . $task['expstrt'][$i] . "'\n\t\t\t\t\t\t,expendt='" . $task['expendt'][$i] . "'\n\t\t\t\tWHERE id = '" . $task['id'][$i] . "'"; } else { $sql = "INSERT INTO `tools_plan_task` (fid,title,describ,owner,pdays,expstrt,expendt) VALUES "; $sql .= "('" . $fid . "','" . $task['title'][$i] . "','" . $task['describ'][$i] . "','" . $task['owner'][$i] . "','" . $task['pdays'][$i] . "','" . $task['expstrt'][$i] . "','" . $task['expendt'][$i] . "')"; } $this->db->query($sql); } //更新Milestone $sql = "UPDATE `tools_plan_milestone` SET is_del = '1' WHERE fid = {$fid}"; //print_r($milestone); $this->db->query($sql); for ($i = 1; $i < count($milestone['id']); $i++) { if ($milestone['id'][$i]) { $sql = "UPDATE `tools_plan_milestone` SET is_del = 0,\n\t\t\t\t\t\ttitle = '" . $milestone['title'][$i] . "'\n\t\t\t\t\t\t,describ='" . $milestone['describ'][$i] . "'\n\t\t\t\t\t\t,timepoint='" . $milestone['timepoint'][$i] . "'\n\t\t\t\tWHERE id = '" . $milestone['id'][$i] . "'"; } else { $sql = "INSERT INTO `tools_plan_milestone` (fid,title,describ,timepoint) VALUES "; $sql .= "('" . $fid . "','" . $milestone['title'][$i] . "','" . $milestone['describ'][$i] . "','" . $milestone['timepoint'][$i] . "')"; } //echo $sql;die; $this->db->query($sql); //echo $sql; } }