/**
* 日報登録編集
*
* @param
*/
function editDailyReport($sql_flg, $staff_id, $holiday_flg, $title, $comment, $sort_order, $year, $month, $date, $term_id)
{
$date = changeYYMMDD($year, $date);
if ($sql_flg == 'insert') {
$param = array("staff_id" => $staff_id, "term_id" => $term_id['id'], "holiday_flg" => $holiday_flg, "title" => $title, "comment" => $comment, "sort_order" => $sort_order);
$sql = "INSERT INTO t_report (staff_id, term_id, holiday_flg, title, comment, sort_order)" . " VALUES(:staff_id, :term_id, :holiday_flg, :title, :comment, :sort_order)";
} elseif ($sql_flg == 'update') {
$param = array("staff_id" => $staff_id, "term_id" => $term_id['id'], "holiday_flg" => $holiday_flg, "title" => $title, "comment" => $comment, "sort_order" => $sort_order);
$sql = 'UPDATE t_report re INNER JOIN m_term te ON re.term_id = te.id' . ' SET re.title = :title, re.`comment` = :comment, re.sort_order = :sort_order, re.holiday_flg = :holiday_flg, re.update_date = NOW()' . ' WHERE re.staff_id = :staff_id AND re.term_id = :term_id AND re.sort_order = :sort_order';
// $sql = 'UPDATE t_report re INNER JOIN m_term te ON re.term_id = te.id'
// .' SET re.title = :title, re.`comment` = :comment, re.sort_order = :sort_order, re.holiday_flg = :holiday_flg, re.update_date = NOW()'
// .' WHERE re.staff_id = :staff_id AND re.term_id = :term_id AND te.`year` = :year AND te.`month` = :month and re.sort_order = :sort_order';
}
// データベースに接続する
$conn = DbControl::getInstance();
$conn->dbConnect(DbControl::MASTER_DB)->beginTransaction();
// クエリを実行する
$res = $conn->dbExecute(DbControl::MASTER_DB, $sql, $param);
//正しい応答があればコミット（書き込み確定）
if ($res) {
$conn->commit(DbControl::MASTER_DB);
//誤った応答があればロールバック（取り消し）
} else {
$conn->rollback(DbControl::MASTER_DB);
}
// データベースを切断する
$conn->dbClose(DbControl::MASTER_DB);
if ($res) {
return true;
} else {
return false;
}
}
}
if (isset($request['name'])) {
$param['name'] = $request['name'];
}
if (isset($request['staff_cd'])) {
$param['staff_cd'] = $request['staff_cd'];
}
$termid = false;
if (isset($request['submit'])) {
$button = key($request['submit']);
if (isset($request['weekDays'][$button])) {
$titleDay = $request['weekDays'][$button];
//TOPからの遷移
// $year = 2014;
// $titleDay = 0101;
$date = changeYYMMDD($year, $titleDay);
$year = getYear($date);
$month = getMonth($date);
$day = getDayYmd($date);
$termid = getTermId($date);
$param['target_date'] = $date;
$param['titleDay'] = $titleDay . '(' . $day . ')';
}
if (isset($request['title'][$button])) {
$param['title'] = $request['title'][$button];
}
if (isset($request['comment'][$button])) {
$param['comment'] = $request['comment'][$button];
}
if (isset($request['sort_order'][$button])) {
$param['sort_order'] = $request['sort_order'][$button];
