public function copy()
{
$rent_no_from = $this->input->post('rent_no_from');
$rent_from = $this->customer_rent_model->getCustomerRentByRentNo($rent_no_from);
$rent_no_to = $this->input->post('rent_no_to');
$rent_to = $this->customer_rent_model->getCustomerRentByRentNo($rent_no_to);
if ($rent_to) {
$this->customer_rent_model->copyRule($rent_from['customer_rent_id'], $rent_to['customer_rent_id']);
output_success();
} else {
output_error('填写的合同编号不存在');
}
}
public function delete()
{
$file_id = (int) $this->input->get_post('file_ids');
$file = $this->file_upload_model->getFile($file_id);
if ($file['import_status'] == 1) {
output_error('导入成功的文件不能删除');
}
$file_dir = './upload/excel/' . date('Ym', strtotime($file['created_at'])) . '/';
$file_path = FCPATH . $file_dir . $file['file_save_name'];
$tempName = explode('.', $file['file_save_name']);
$err_file = FCPATH . $file_dir . $tempName[0] . '_error.csv';
$this->file_upload_model->delete($file_id);
if (file_exists($err_file)) {
unlink($err_file);
}
if (file_exists($file_path)) {
unlink($file_path);
}
output_success();
}
public function upload()
{
$config['upload_path'] = './upload/excel/' . date('Ym') . '/';
$config['allowed_types'] = 'xlsx|xls|cvs';
$config['file_name'] = 'upload_' . date('YmdHis') . rand(0, 9) . rand(0, 9) . rand(0, 9);
$config['max_size'] = 20480;
$config['file_ext_tolower'] = TRUE;
if (!is_dir($config['upload_path'])) {
mkdir($config['upload_path']);
}
$this->load->library('upload', $config);
if (!$this->upload->do_upload('fileUpload')) {
$error = array('error' => $this->upload->display_errors());
print_r($error);
exit;
} else {
$fileInfo = $this->upload->data();
$fileData = array('file_name' => $fileInfo['client_name'], 'file_save_name' => $fileInfo['file_name'], 'file_size' => $fileInfo['file_size'], 'admin_id' => $this->admin_id);
$this->file_upload_model->addFile($fileData);
$this->file_save_path = FCPATH . $config['upload_path'] . $fileData['file_save_name'];
$data = $this->validateExcel($this->file_save_path);
if ($data) {
$num = $this->customer_number_model->importData($data);
output_success();
}
}
exit;
}
if ($db->AutoExecute("community_members", $community, "INSERT")) {
if ($SKIP_EMAIL_NOTIFICATION) {
output_success("[Row " . $row_count . "]\tSuccessfully added username [" . $user["username"] . "] and skipped e-mail notification.");
} else {
do {
$hash = generate_hash();
} while ($db->GetRow("SELECT `id` FROM `" . AUTH_DATABASE . "`.`password_reset` WHERE `hash` = " . $db->qstr($hash)));
if ($db->AutoExecute(AUTH_DATABASE . ".password_reset", array("ip" => "127.0.0.1", "date" => time(), "user_id" => $proxy_id, "hash" => $hash, "complete" => 0), "INSERT")) {
$notification_search = array("%firstname%", "%lastname%", "%username%", "%password_reset_url%", "%application_url%", "%application_name%", "%community_name%", "%community_url%");
$notification_replace = array(stripslashes($user["firstname"]), stripslashes($user["lastname"]), stripslashes($user["username"]), PASSWORD_RESET_URL . "?hash=" . rawurlencode($proxy_id . ":" . $hash), ENTRADA_URL, APPLICATION_NAME, $community_info["community_title"], COMMUNITY_URL . $community_info["community_url"]);
$message = str_ireplace($notification_search, $notification_replace, $NEW_GUEST_NOTIFICATION);
if ($SEND_ADMIN_NOTIFICATION) {
$user["email"] = $AGENT_CONTACTS["administrator"]["email"];
}
if (@mail($user["email"], "New User Account: " . APPLICATION_NAME, $message, "From: \"" . $AGENT_CONTACTS["administrator"]["name"] . "\" <" . $AGENT_CONTACTS["administrator"]["email"] . ">\nReply-To: \"" . $AGENT_CONTACTS["administrator"]["name"] . "\" <" . $AGENT_CONTACTS["administrator"]["email"] . ">")) {
output_success("[Row " . $row_count . "]\tSuccessfully added username [" . $user["username"] . "] and sent e-mail notification to [" . $user["email"] . "].");
} else {
output_error("[Row " . $row_count . "]\tAdded username [" . $user["username"] . "] to the database, but could not send e-mail notification to [" . $user["email"] . "].");
}
} else {
output_error("[Row " . $row_count . "]\tAdded username [" . $user["username"] . "] to the database, but could not insert password reset entry into password_reset table. Database said: " . $db->ErrorMsg());
}
}
} else {
output_error("[Row " . $row_count . "]\tUnable to insert community_members record for proxy_id [" . $proxy_id . "] and application_id [" . AUTH_APP_ID . "]. Database said: " . $db->ErrorMsg());
}
} else {
output_error("[Row " . $row_count . "]\tUnable to insert user_access record for proxy_id [" . $proxy_id . "] and application_id [" . AUTH_APP_ID . "]. Database said: " . $db->ErrorMsg());
}
} else {
output_error("[Row " . $row_count . "]\tUnable to insert user_data record for staff / student number [" . $user["number"] . "]. Database said: " . $db->ErrorMsg());
/**
* This function creates a new gallery based on the one being copied.
*
* @param ADONewConnection $db
* @param int $old_community_id
* @param int $old_gallery_page_id
* @param int $new_community_id
* @param int $new_parent_id
* @param int $proxy_id
* @return array(int, int) on success and 0 on failure.
*/
function create_gallery($db, $old_community_id, $old_gallery_page_id, $new_community_id, $new_parent_id, $proxy_id)
{
$query = "\tSELECT *\n\t\t\tFROM " . DATABASE_NAME . ".`community_galleries`\n\t\t\tWHERE `community_id` = " . $old_community_id . "\n\t\t\tAND `cpage_id` = " . $old_gallery_page_id;
$community_gallery_arr = $db->GetRow($query);
//echo "\nQUERY: " . $query;
if ($community_gallery_arr) {
$time = time();
$gallery = array();
$gallery["community_id"] = $new_community_id;
$gallery["cpage_id"] = $new_parent_id;
$gallery["gallery_title"] = "Image Gallery";
$gallery["gallery_description"] = "Image Gallery";
$gallery["gallery_cgphoto_id"] = 0;
$gallery["gallery_order"] = $community_gallery_arr["gallery_order"];
$gallery["gallery_active"] = $community_gallery_arr["gallery_active"];
$gallery["admin_notifications"] = $community_gallery_arr["admin_notifications"];
$gallery["allow_public_read"] = $community_gallery_arr["allow_public_read"];
$gallery["allow_public_upload"] = $community_gallery_arr["allow_public_upload"];
$gallery["allow_public_comment"] = $community_gallery_arr["allow_public_comment"];
$gallery["allow_troll_read"] = $community_gallery_arr["allow_troll_read"];
$gallery["allow_troll_upload"] = $community_gallery_arr["allow_troll_upload"];
$gallery["allow_troll_comment"] = $community_gallery_arr["allow_troll_comment"];
$gallery["allow_member_read"] = $community_gallery_arr["allow_member_read"];
$gallery["allow_member_upload"] = $community_gallery_arr["allow_member_upload"];
$gallery["allow_member_comment"] = $community_gallery_arr["allow_member_comment"];
$gallery["release_date"] = $time;
$gallery["release_until"] = 0;
$gallery["updated_date"] = $time;
$gallery["updated_by"] = $proxy_id;
$db->AutoExecute("" . DATABASE_NAME . ".community_galleries", $gallery, "INSERT");
$new_gallery_id = $db->Insert_Id();
output_success("Created new gallery with id: " . $new_gallery_id);
return array("new_gallery_id" => $new_gallery_id, "old_gallery_id" => $community_gallery_arr["cgallery_id"]);
} else {
output_error("Community Gallery not found.");
return 0;
}
}
public function copyProvinceRule()
{
$customer_rent_id = $this->input->get_post('customer_rent_id');
$province_code_from = $this->input->get_post('province_code_from');
$province_code_to = $this->input->get_post('province_code_to');
//清空旧数据
$rule_to = $this->customer_express_rule_model->getOneByRent($customer_rent_id, $province_code_to);
$this->customer_express_rule_item_model->deleteByRuleID($rule_to['rule_id']);
$this->customer_express_rule_model->delete($rule_to['rule_id']);
$rule_from = $this->customer_express_rule_model->getOneByRent($customer_rent_id, $province_code_from);
$rule_to = $rule_from;
unset($rule_to['rule_id']);
$rule_to['province_code'] = $province_code_to;
$new_rule_id = $this->customer_express_rule_model->add($rule_to);
$rule_item_from = $this->customer_express_rule_item_model->getItems($rule_from['rule_id']);
foreach ($rule_item_from as $rule_item) {
unset($rule_item['item_id']);
$rule_item['rule_id'] = $new_rule_id;
$this->customer_express_rule_item_model->add($rule_item);
}
output_success();
}
public function delete()
{
if ($this->checkCondition() == FALSE) {
output_error('条件不足，不能执行该操作');
}
if ($this->input->post('tracking_number_ids')) {
$tracking_number_ids = explode(',', $this->input->post('tracking_number_ids'));
$tracking_numbers = $this->tracking_number_model->getTrackingNumberByIDS($tracking_number_ids);
} else {
$data = array('arrive_time_start' => $this->input->get_post('arrive_time_start'), 'arrive_time_end' => $this->input->get_post('arrive_time_end'), 'filter' => objectToArray(json_decode($this->input->get_post('filter'))));
$tracking_numbers = $this->tracking_number_model->getTrackingNumbers($data);
}
$delete_total = 0;
foreach ($tracking_numbers as $tracking_number) {
$result = $this->tracking_number_model->delete($tracking_number['tracking_number_id']);
if ($result) {
$delete_total++;
}
}
output_success('成功', $delete_total);
}
function set_module_page_permissions($db, $community_id, $module_id, $allow_member_view, $allow_public_view, $allow_troll_view)
{
$query = "SELECT * FROM " . DATABASE_NAME . ".`communities_modules` WHERE `module_id` = " . $db->qstr($module_id) . " AND `module_active` = '1'";
$module_info = $db->GetRow($query);
$module_shortname = "";
if ($module_info) {
$module_shortname = $module_info["module_shortname"];
if ($db->AutoExecute("" . DATABASE_NAME . ".`community_pages`", array("allow_member_view" => 0, "allow_public_view" => 0, "allow_troll_view" => 0, "updated_date" => time(), "updated_by" => 5440), "UPDATE", "`community_id` = " . $db->qstr($community_id) . " AND page_type = " . $db->qstr($module_shortname))) {
output_success("Permission set to allow Admin access only.");
} else {
output_error("Failed to create the module page.");
}
} else {
output_error("Module does not exist.");
}
}
