/**
* 締切日時指定スケジュール一覧インスタンス生成
*
* @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;
}
