/** * 締切日時指定スケジュール一覧インスタンス生成 * * @param string $datetime_from 範囲開始日時 * @param string $datetime_to 範囲終了日時 * @return array ACSScheduleインスタンスの配列 */ function &get_schedule_instance_list_by_closing_datetime($datetime_from, $datetime_to) { $where = "schedule_closing_datetime >= " . "'" . ACSLib::convert_timestamp_to_pg_date($datetime_from) . "'" . " AND schedule_closing_datetime <= " . "'" . ACSLib::convert_timestamp_to_pg_date($datetime_to) . "'"; return ACSSchedule::get_schedule_instance_list($where); }
/** * ルートフォルダ挿入 * * @param $community_id */ static function insert_root_folder($community_id) { $folder_row = array(); $timestamp = ACSLib::convert_timestamp_to_pg_date(); $folder_row['folder_id'] = ACSDB::get_next_seq('folder_id_seq'); $folder_row['community_id'] = $community_id; $folder_row['folder_name'] = ACSMsg::get_mdmsg(__FILE__, 'M001'); $folder_row['comment'] = ""; $folder_row['parent_folder_id'] = ""; $folder_row['entry_user_community_id'] = $community_id; $folder_row['entry_date'] = $timestamp; $folder_row['update_user_community_id'] = $community_id; $folder_row['update_date'] = $timestamp; $folder_row['open_level_code'] = ""; ACSDB::_do_query("BEGIN"); $ret = ACSFolderModel::insert_folder($folder_row); if (!$ret) { ACSDB::_do_query("ROLLBACK"); return $ret; } ACSDB::_do_query("COMMIT"); return $ret; }
/** * インスタンス取得(履歴更新アップロード用) * * @param $upload_file_info_row $_FILES['new_file'] * @param $owner_community_id 対象となるコミュニティID * @param $acs_user_community_id アップロードしたユーザコミュニティID * @param $file_id 既存ファイルの更新時のファイルID */ static function get_upload_file_info_instance_for_update($upload_file_info_row, $owner_community_id, $acs_user_community_id, $file_id) { $file_info_row = array(); /* 新file_id取得 (server_file_name用) */ $new_file_id = ACSFileInfoModel::get_next_file_id_seq(); /* display_file_name */ if (!ini_get('mbstring.encoding_translation')) { $display_file_name = mb_convert_encoding($upload_file_info_row['name'], mb_internal_encoding(), mb_http_output()); } else { $display_file_name = $upload_file_info_row['name']; } /* server_file_name 作成 */ $server_file_name = ACSFile::get_upload_file_save_file_name($owner_community_id, $new_file_id); /* thumbnail_server_file_name 作成 */ $thumbnail_server_file_name = ACSFile::get_thumbnail_save_file_name($owner_community_id, $new_file_id); /* 作成日 */ $filemtime = filemtime($upload_file_info_row['tmp_name']); // insert 用にフォーマットする $entry_date = ACSLib::convert_timestamp_to_pg_date($filemtime); /* 更新日 */ $update_date = $entry_date; $file_info_row['file_id'] = $file_id; $file_info_row['owner_community_id'] = $owner_community_id; $file_info_row['display_file_name'] = $display_file_name; $file_info_row['server_file_name'] = $server_file_name; $file_info_row['thumbnail_server_file_name'] = $thumbnail_server_file_name; $file_info_row['mime_type'] = $upload_file_info_row['type']; $file_info_row['file_size'] = $upload_file_info_row['size']; $file_info_row['entry_user_community_id'] = $acs_user_community_id; $file_info_row['entry_date'] = $entry_date; $file_info_row['update_user_community_id'] = $acs_user_community_id; $file_info_row['update_date'] = $update_date; $file_info_row['upload_temp_file_name'] = $upload_file_info_row['tmp_name']; $file_obj = new ACSFile($file_info_row); return $file_obj; }
/** * フォルダ情報変更 * * @param $input_folder_row * * @return $ret */ function update_folder($input_folder_row) { $acs_user_info_row = $this->get_acs_user_info_row(); $acs_user_community_id = $acs_user_info_row['user_community_id']; $folder_row['folder_name'] = $input_folder_row['folder_name']; $folder_row['comment'] = $input_folder_row['comment']; $folder_row['update_user_community_id'] = $acs_user_community_id; $folder_row['update_date'] = ACSLib::convert_timestamp_to_pg_date(); $folder_row['open_level_code'] = $input_folder_row['open_level_code']; $trusted_community_id_array = $input_folder_row['trusted_community_id_array']; $ret = ACSFolderModel::update_folder_info($this->get_folder_id(), $folder_row, $trusted_community_id_array); return $ret; }