/**
  * 更新立项数据
  * @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;
     }
 }