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();
}
