public static function add($info) { $insert_field = Staff::$INSERT_FIELD; $insert_data = array(); foreach ($insert_field as $item) { $insert_data[$item] = $info[$item]; } $dbResult = DB::insert(Staff::$TABLE)->set($insert_data)->execute(); }
public static function update_content($data) { $type = $data['type']; $content = $data['content']; $dbResult = DB::select('id')->from('recruitment')->where('type', $type)->execute(); $id = $dbResult->as_array(); if (empty($id)) { DB::insert('recruitment')->set(array('name' => $type, 'content' => 'N' . 'init data ', 'type' => $type))->execute(); } $query = "\n UPDATE recruitment\n SET\n content = N'{$content}'\n WHERE\n type = '{$type}'\n "; $dbResult = DB::query($query)->execute(); return $dbResult; }
public static function update_content($data) { $faculty = $data['faculty']; $name = $data['type']; $content = $data['content']; $dbResult = DB::select('id')->from('admissions_faculty')->where('name', $name)->and_where('faculty_id', $faculty)->execute(); $id = $dbResult->as_array(); if (empty($id)) { DB::insert('admissions_faculty')->set(array('name' => $name, 'faculty_id' => $faculty, 'content' => 'N' . 'init data '))->execute(); } $query = "\n UPDATE admissions_faculty\n SET\n content = N'{$content}'\n WHERE\n faculty_id = '{$faculty}'\n and\n name = '{$name}'\n "; $dbResult = DB::query($query)->execute(); return $dbResult; }
public function createNew($storyObj) { try { $dbObj = DB::insert($this->TABLE)->set($storyObj); $dbResult = $dbObj->execute(); if ($dbResult[1] != 1) { return false; } else { return true; } } catch (\Exception $e) { CError::dbLog($e); return false; } }
public static function insert($props) { try { $query = DB::insert(static::$_table_name)->columns(static::$_properties); foreach ($props as $prop) { $query->values($prop); } if ($query->execute()) { return true; } } catch (Exception $e) { Log::write('ERROR', $e->getMessage()); return false; } return false; }
public static function add($info) { $insert_field = Department::$INSERT_FIELD; $insert_data = array(); foreach ($insert_field as $item) { $insert_data[$item] = $info[$item]; } $dbResult = DB::insert(Department::$TABLE)->set($insert_data)->execute(); if ($dbResult[1] == 1) { $retData['ErrorCode'] = 1; $retData['ErrorMsg'] = 'Success!'; } else { $retData['ErrorCode'] = -1; $retData['ErrorMsg'] = 'Unknow error!'; } return $retData; }
public static function add($post_object) { try { $dbResult = DB::insert(self::$TABLE)->set($post_object)->execute(); $error = array(); if ($dbResult[1] == 1) { $error['ErrorCode'] = 1; $error['ErrorMsg'] = 'Success with PostID = ' . $dbResult[0]; } else { $error['ErrorCode'] = -1; $error['ErrorMsg'] = 'Unknow error'; } return $error; } catch (\Exception $e) { return 1; } }
/** * @author dangbc <*****@*****.**> * save data plan */ public function save_plan($current_date, $data_post = array()) { try { \Fuel\Core\DB::start_transaction(); $delete = \Fuel\Core\DB::query('DELETE FROM plan where start_date = :start_date')->bind('start_date', $current_date)->execute(); $plan = \Fuel\Core\DB::insert(self::$_table_name)->columns(array('start_date', 'area_id', 'job_cost', 'expenses', 'created_at', 'updated_at')); foreach ($data_post['area_id'] as $k => $v) { $plan->values(array($current_date, $k, $data_post['job_cost'][$k] == '' ? 0 : $data_post['job_cost'][$k], $data_post['expenses'][$k] == '' ? 0 : $data_post['expenses'][$k], date('Y-m-d h:s'), date('Y-m-d h:s'))); } if (!$plan->execute()) { \Fuel\Core\DB::rollback_transaction(); return false; } \Fuel\Core\DB::commit_transaction(); return true; } catch (Exception $ex) { \Fuel\Core\DB::rollback_transaction(); return false; } }
public static function add_to_lecturer($lecturer_info) { $dbResult = DB::insert(Lecturer::$TABLE_DETAILS)->set($lecturer_info)->execute(); }