static function delete_images($id)
{
$row = DB::select('item_image', 'id=' . $id);
if ($row) {
if ($row['root_id']) {
//Ảnh gốc
DB::delete('item_image', 'root_id=' . $row['root_id']);
} else {
DB::delete('item_image', 'id=' . $id);
}
//update memcache IMG
$sql = "SELECT item_id FROM item_image WHERE (id = {$id} OR root_id = {$id}) " . (User::have_permit(ADMIN_IMAGE) ? '' : " AND user_id=" . User::id());
$re = DB::query($sql);
if ($re) {
$item = mysql_fetch_assoc($re);
if ($item["item_id"]) {
require_once ROOT_PATH . 'core/Item.php';
Item::get_item_images($item["item_id"], 1);
}
}
//update memcache IMG
if ($row['img_url']) {
if (DB::query("UPDATE item SET img_url='' WHERE img_url='" . $row['img_url'] . "'") && MEMCACHE_ON) {
$sql = "SELECT * FROM item WHERE img_url = '{$row['img_url']}'";
$re = DB::query($sql);
while ($item_memcache = mysql_fetch_assoc($re)) {
$item_memcache['img_server'] = 0;
$item_memcache['img_url'] = '';
AZMemcache::do_put("item:" . $item_memcache['id'], $item_memcache);
}
}
AZLib::ftp_image_delete_file($row['img_url'], $row['img_server']);
}
}
}
function on_submit()
{
if (!User::is_block()) {
$file_name = strtolower($_FILES['avatar_url']['name']);
$upload_path = AZLib::folderUpload(User::id(), 'avatar');
$max_upload_file_size = 2 * 1024 * 1024;
$file_ext = AZLib::getExtension(strtolower($file_name));
$new_path = '';
if ($file_name && in_array($file_ext, array('.jpg', '.jpeg', '.gif', '.png')) && filesize($_FILES['avatar_url']['tmp_name']) < $max_upload_file_size) {
if (AZLib::ftp_check_dir($upload_path, true, IMAGE_SERVER_NO)) {
if (User::$current->data['avatar_url'] != '') {
@AZLib::ftp_image_delete_file(User::$current->data['avatar_url'], User::$current->data['img_server']);
}
$new_path = $upload_path . date("YmdHis", TIME_NOW) . '_' . substr(AZLib::make_safe_name(basename($file_name, $file_ext)), 0, 36) . $file_ext;
@AZLib::ftp_image_put_file($new_path, $_FILES['avatar_url']['tmp_name'], IMAGE_SERVER_NO);
}
}
$phone_verify = User::$current->data['phone_verify'];
$this->update_user($new_path, $phone_verify, IMAGE_SERVER_NO);
//đang làm dở
User::getUser(User::id(), true);
echo '<script>document.location.href="' . WEB_ROOT . AZRewrite::formatUrl('?page=personal&cmd=edit_user&action=success_edit_user') . '"</script>';
} else {
$this->setFormError('', "Tài khoản của bạn hiện đang bị khóa, bạn không thể thực hiện chức năng này!");
}
}
function gallery_bulk_delete()
{
//Xoá nhiều ảnh
$arrIDs = explode(',', Url::get('ids'));
$return = 'fail';
if (count($arrIDs)) {
foreach ($arrIDs as $imgID) {
$image = DB::select('item_image', 'id=' . $imgID . (User::have_permit(ADMIN_IMAGE) ? '' : ' AND user_id=' . User::id()));
if ($image) {
if ($image['img_url']) {
AZLib::ftp_image_delete_file($image['img_url'], $image['img_server']);
//Xoá ảnh gốc
//DB::query("UPDATE item SET img_url='' WHERE img_url='{$image['img_url']}' AND status IN(1,2) " . (User::have_permit(ADMIN_IMAGE) ? '' : ' AND user_id=' . User::id()));
}
//get Item_id
$sql = "SELECT item_id FROM item_image WHERE (id = {$imgID} OR root_id = {$imgID}) " . (User::have_permit(ADMIN_IMAGE) ? '' : " AND user_id=" . User::id());
$re = DB::query($sql);
if ($re) {
$item = mysql_fetch_assoc($re);
if ($item["item_id"]) {
require_once ROOT_PATH . 'core/Item.php';
Item::get_item_images($item["item_id"], 1);
}
}
DB::delete('item_image', '(id=' . $imgID . ' OR root_id=' . $imgID . ')' . (User::have_permit(ADMIN_IMAGE) ? '' : ' AND user_id=' . User::id()));
$return = 'success';
}
}
}
echo $return;
exit;
}
function UserAdmin($row)
{
define('BAN_NICK_DATE', 7);
CGlobal::$website_title = 'Quản lý thành viên';
Module::Module($row);
if (User::have_permit(ADMIN_USER)) {
switch (Url::get('cmd')) {
case 'lockdie':
//Khoá vĩnh viễn
$id = (int) Url::get('id', 0);
if ($id) {
$user = User::getUser($id);
if ($user) {
DB::update('user', array('block_time' => -1), 'id=' . $id);
DB::insert('user_lock', array('time' => TIME_NOW, 'user_id' => $id, 'user_name' => $user['user_name'], 'type' => 3, 'admin_id' => User::id(), 'admin_name' => User::user_name()));
User::getUser($id, 0, 1);
}
}
Url::redirect_url(Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac')));
break;
case 'delete':
Item::delete_item(Url::get('id'));
Url::redirect_url(Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), "cmd=item_list"));
break;
case 'del_cache':
$id = (int) Url::get('id', 0);
if ($id) {
User::getUser($id, 0, 1);
}
Url::redirect_url(Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac')));
break;
case 'del_avatar':
$user = DB::select('user', (int) Url::get('id'));
if ($user) {
if ($user['avatar_url']) {
AZLib::ftp_image_delete_file($user['avatar_url'], $user['img_server']);
DB::update('user', array('avatar_url' => '', 'img_server' => 0), 'id=' . $user['id']);
User::getUser($user['id'], 0, 1);
}
}
Url::redirect_url(Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac')));
break;
case 'item_list':
require_once 'forms/item_list.php';
$this->add_form(new ItemListForm());
break;
case 'user_log':
require_once 'forms/user_log.php';
$this->add_form(new UserLogForm());
break;
case 'detail':
require_once 'forms/UserDetail.php';
$this->add_form(new UserDetailForm());
break;
case 'add':
require_once 'forms/UserAdd.php';
$this->add_form(new UserAddForm());
break;
case 'edit':
require_once 'forms/UserEdit.php';
$this->add_form(new UserEditForm());
break;
default:
require_once 'forms/UserAdmin.php';
$this->add_form(new ListUserAdminForm());
break;
}
} else {
Url::access_denied();
}
}
function on_submit()
{
$submit = Url::get('submit');
$submitLogo = Url::get('submitLogo');
if ($submit == 'Cập nhật') {
if (User::is_admin()) {
$status = (int) Url::get('status', 0);
$b_background_file = DATA_PATH . "b_background.gif";
if (isset($_FILES['b_background']) && $_FILES['b_background']['error'] == 0) {
$file_ext = strtolower(AZLib::getExtension($_FILES['b_background']['name']));
if (in_array($file_ext, array('.jpg', '.jpeg', '.png', '.gif'))) {
if (getimagesize($_FILES['b_background']['tmp_name'])) {
if (!move_uploaded_file($_FILES['b_background']['tmp_name'], $b_background_file)) {
$this->setFormError('b_background', 'Không up load được Body Background!');
return;
}
} else {
$this->setFormError('b_background', 'Sai định dạng Body Background!');
return;
}
} else {
$this->setFormError('b_background', 'Body Background chỉ chấp nhận các định dạng file .jpg, .jpeg, .gif, .png!');
return;
}
}
if (isset(CGlobal::$configs['event_on'])) {
DB::update('configs', array("conf_val" => $status), "conf_key='event_on'");
} else {
DB::insert('configs', array("conf_key" => 'event_on', "conf_val" => $status));
}
AZLib::get_config(0, 1);
}
if (isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER']) {
$referer = $_SERVER['HTTP_REFERER'];
} else {
$referer = $_SERVER['REQUEST_URI'];
}
Url::redirect_url($referer);
}
if (User::have_permit(ADMIN_LOGO) && $submitLogo) {
$id = (int) Url::get('logoID', 0);
$cmd = Url::get('logoCmd');
if ($cmd == 'delete') {
if ($id) {
$record = DB::select('website_logo', 'id=' . $id);
}
AZLib::ftp_image_delete_file($record['image'], $record['img_server']);
$sql = 'delete FROM website_logo WHERE id = ' . $id;
DB::query($sql);
AZLib::getWebsiteLogo(1);
} else {
$logo = array();
$start_date = Url::get('logoStartDate', 0);
$end_date = Url::get('logoEndDate', 0);
if ($id) {
$logo = DB::fetch("SELECT * FROM website_logo WHERE id = {$id}");
}
$logo['title'] = Url::get('logoTitle');
if (!isset($logo['img_server'])) {
$logo['img_server'] = IMAGE_SERVER_NO;
}
if (!$cmd) {
$logo['username'] = User::$current->data['user_name'];
}
if ($start_date) {
$date_arr = explode("-", $start_date);
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$logo['start_date'] = mktime(0, 0, 0, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]);
}
} else {
$logo['start_date'] = 0;
}
if ($end_date) {
$date_arr = explode("-", $end_date);
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$logo['end_date'] = mktime(23, 59, 59, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]);
}
} else {
$logo['end_date'] = 0;
}
if (Url::get('logoActive', 0)) {
DB::query("UPDATE website_logo SET status = 0");
$logo['status'] = 1;
} else {
$logo['status'] = 0;
}
//Gen image unique name
$img = $_FILES['uploadLogo']['name'];
$img = explode('.', $img);
$img = array_pop($img);
$mini = microtime(TRUE);
$img = $mini . '.' . $img;
if ($_FILES['uploadLogo']['tmp_name']) {
if ($cmd == 'edit') {
//sửa
AZLib::ftp_image_delete_file('logo/' . $img, $logo['img_server']);
}
if (AZLib::ftp_check_dir('logo/', TRUE, IMAGE_SERVER_NO)) {
$file_name = 'logo/' . $img;
$sourceName = $_FILES['uploadLogo']['tmp_name'];
AZLib::ftp_image_put_file($file_name, $sourceName, IMAGE_SERVER_NO);
$logo['image'] = $file_name;
}
}
if (!$this->errNum && isset($logo['image']) && $logo['image']) {
if ($cmd == 'edit') {
DB::update('website_logo', $logo, 'id=' . $id);
} else {
$id = DB::insert('website_logo', $logo);
}
AZLib::getWebsiteLogo(1);
}
}
}
}
function on_submit()
{
$gfsubmit = Url::get("gfsubmit");
if ($gfsubmit) {
$fgroup_id = (int) implode(array_keys($gfsubmit));
if ($fgroup_id) {
$fgroup = DB::select("filter_group", "id={$fgroup_id}");
if ($fgroup) {
$gf_name = Url::get('gf_name');
$gf_pos = Url::get('gf_pos');
if (isset($gf_name[$fgroup_id], $gf_pos[$fgroup_id]) && $gf_name[$fgroup_id] && $gf_pos[$fgroup_id]) {
$gf_name = $gf_name[$fgroup_id];
$gf_pos = $gf_pos[$fgroup_id];
if ($fgroup['name'] != $gf_name || $fgroup['pos'] != $gf_pos) {
$max_pos = (int) DB::fetch("SELECT max(pos) AS max_pos FROM filter_group", 'max_pos', 0);
if ($gf_pos > $max_pos) {
$gf_pos = $max_pos;
} elseif ($gf_pos <= 0) {
$gf_pos = $fgroup['pos'];
}
DB::update('filter_group', array("name" => $gf_name, "pos" => $gf_pos), "id={$fgroup_id}");
if (DB::select('filter_group', "pos={$gf_pos} AND id!={$fgroup_id}")) {
DB::query("UPDATE filter_group SET pos=pos+1 WHERE pos>={$gf_pos} AND pos<={$fgroup['pos']} AND id!={$fgroup_id}");
}
AZLib::getFilters(1);
}
}
}
}
Url::redirect_current(array('cmd', 'id'));
}
$submit = Url::get("submit");
if ($submit == "Thêm nhóm thuộc tính") {
$gfilter_name = Url::get('gfilter_name');
$gfilter_pos = Url::get('gfilter_pos');
if ($gfilter_name != '' && $gfilter_pos) {
$gfilter_group = array('name' => $gfilter_name, 'catids' => $this->cat['id'], 'pos' => $gfilter_pos);
$max_pos = (int) DB::fetch("SELECT max(pos) AS max_pos FROM filter_group", 'max_pos', 0);
if ($gfilter_pos > $max_pos || $gfilter_pos <= 0) {
$gfilter_pos = $max_pos + 1;
}
$gfilter_group['pos'] = $gfilter_pos;
$id = DB::insert('filter_group', $gfilter_group);
if ($id && DB::select('filter_group', 'pos="' . $gfilter_pos . '" AND id!=' . $id)) {
DB::query('UPDATE filter_group SET pos=pos+1 WHERE pos>=' . $gfilter_pos . ' AND id!=' . $id);
}
}
AZLib::getFilters(1);
Url::redirect_current(array('cmd', 'id'));
}
$name = Url::get('name');
$brief_name = Url::get('brief_name');
$keywords = Url::get('keywords');
$description = Url::get('description');
$parent_id = Url::get('parent_id');
$zoneids = Url::get('zoneids');
$ref_id = Url::get('ref_id');
$status = Url::get('status', 'HIDE');
$position = Url::get('position');
$tag_search = Url::get('tag_search');
$price_str = trim(Url::get('price_str'));
$recomend = trim(Url::get('recomend'));
if ($price_str) {
function check_price_str($price)
{
return Url::cdouble(trim($price));
}
$price_ar = array_unique(array_map('check_price_str', explode(",", $price_str)));
$price_str = '';
if ($price_ar) {
asort($price_ar);
foreach ($price_ar as $price) {
if ($price > 0) {
$price_str .= ($price_str != '' ? ',' : '') . $price;
}
}
}
}
$this->checkFormInput('Tên Danh mục', 'name', $name, 'str', true, '', 1, 255);
$this->checkFormInput('Tên vắn tắt', 'brief_name', $brief_name, 'str', false, '', 1, 255);
//$this->checkFormInput('Từ khoá','keywords',$keywords,'str',false,'',0,20);
$this->checkFormInput('Mô tả', 'description', $description, 'str', false, '', 0, 250);
if (Url::get('cmd') == 'edit' && $this->cat['parent_id'] == 0 && $parent_id && DB::select("category", 'parent_id=' . $this->cat['id'])) {
$this->setFormError("parent_id", 'Không thể chuyển "Danh mục có danh mục con" thành một "Danh mục con" của "Danh mục khác" được!');
}
if (!$this->errNum) {
$new_row = array('name' => $name, 'brief_name' => $brief_name ? $brief_name : $name, 'keywords' => AZLib::word_limit($keywords, 20, ''), 'description' => $description, 'parent_id' => $parent_id, 'ref_id' => $ref_id, 'status' => $status, 'tag_search' => $tag_search, 'img_server' => IMAGE_SERVER_NO, 'price_str' => $price_str, 'recomend' => $recomend);
if (Url::get('cmd') == 'edit') {
if ($position > 0 && $position != $this->cat['position']) {
$max_pos = (int) DB::fetch("SELECT max(position) AS max_pos FROM category WHERE parent_id=" . $parent_id, 'max_pos');
if ($position > $max_pos) {
$position = $max_pos + 1;
}
$new_row['position'] = $position;
} else {
$position = $this->cat['position'];
}
$id = $this->cat['id'];
DB::update('category', $new_row, 'id=' . $this->cat['id']);
/*if($this->cat['parent_id']==0 && $parent_id){
DB::update('category', array('parent_id'=>0),'parent_id='.$this->cat['parent_id']);
}*/
} else {
$max_pos = (int) DB::fetch("SELECT max(position) AS max_pos FROM category WHERE parent_id=" . $parent_id, 'max_pos');
if ($position > $max_pos || $position == 0) {
$position = $max_pos + 1;
}
$new_row['position'] = $position;
$id = DB::insert('category', $new_row);
}
if ($_FILES['cat_image']['tmp_name']) {
if (Url::get('cmd') == 'edit') {
AZLib::ftp_image_delete_file('category/' . $this->cat['id'] . '.gif', $this->cat['img_server']);
}
/*if(AZLib::ftp_image_connect(IMAGE_SERVER_NO)){
if(!AZLib::ftp_check_dir('category/',true,IMAGE_SERVER_NO)){
break ;
}
$file_name ='category/'.$id.'.gif';
$sourceName =$_FILES['cat_image']['tmp_name'];
AZLib::ftp_image_put_file($file_name,$sourceName,IMAGE_SERVER_NO);
//@fopen('http://'.IMAGE_PATH.'?del_cat=1',"r");
}*/
if (AZLib::ftp_check_dir('category/', true, IMAGE_SERVER_NO)) {
$file_name = 'category/' . $id . '.gif';
$sourceName = $_FILES['cat_image']['tmp_name'];
AZLib::ftp_image_put_file($file_name, $sourceName, IMAGE_SERVER_NO);
//@fopen('http://'.IMAGE_PATH.'?del_cat=1',"r");
}
}
if ($id && DB::select('category', 'position="' . $position . '" AND id!="' . $id . '" AND parent_id="' . $parent_id . '"')) {
DB::query('UPDATE category SET position=position+1 WHERE position>=' . $position . ' AND position<=' . $this->cat['position'] . ' AND parent_id="' . $parent_id . '" AND id!=' . $id);
}
$all_zones = $this->zones;
$sql_inset = "";
if ($zoneids) {
foreach ($zoneids as $zoneid) {
if (isset($all_zones[$zoneid])) {
unset($all_zones[$zoneid]);
} else {
$sql_inset .= ($sql_inset != '' ? ',' : '') . "({$zoneid},{$id})";
}
}
}
if ($sql_inset) {
$sql_inset = "INSERT INTO category_zone_cat (zoneid, catid) VALUES " . $sql_inset;
DB::query($sql_inset);
}
if ($all_zones) {
$zoneids = implode(",", array_keys($all_zones));
if ($zoneids) {
DB::query("DELETE FROM category_zone_cat WHERE catid={$id} AND zoneid IN({$zoneids})");
}
}
//AZLib::del_cache_zone_cat();
AZLib::getCats(1, true);
if (Url::get('cmd') == 'edit' && $this->cat['parent_id'] != $parent_id) {
//đổi danh mục cha => cập nhật lại tin
$catid = $this->cat['id'];
$level_1 = 0;
$level_2 = 0;
if ($parent_id) {
if (CGlobal::$allCategories[$parent_id]['parent_id']) {
$level_1 = CGlobal::$allCategories[$parent_id]['parent_id'];
$level_2 = $parent_id;
} else {
$level_1 = $parent_id;
$level_2 = $catid;
}
} else {
$level_1 = $catid;
$level_2 = 0;
}
DB::update("item", array("level_1_catid" => $level_1, "level_2_catid" => $level_2), "category_id={$catid}");
if (MEMCACHE_ON) {
AZMemcache::clear();
}
}
if ($this->cat) {
Url::redirect_current();
} else {
Url::redirect_current(array('cmd'));
}
}
}
function fn_get_avatar_ya()
{
$avatar_id = Url::get('yahoo_id');
if (!User::is_login()) {
echo 'not_login';
exit;
} elseif ($avatar_id == '') {
echo "empty";
exit;
} else {
if (User::is_block()) {
echo "unsuccess";
exit;
}
if (User::$current->data['avatar_url'] != '') {
@AZLib::ftp_image_delete_file(User::$current->data['avatar_url']);
}
$avatar_url = AZLib::get_yahoo_avatar($avatar_id, User::id(), IMAGE_SERVER_NO);
if (DB::query('UPDATE user SET avatar_url="' . $avatar_url . '", img_server=' . IMAGE_SERVER_NO . ' WHERE id="' . User::id() . '"')) {
User::updateUserCache(User::id());
echo '<img src="' . AZLib::getImageThumb($avatar_url, 100, 100, 0, IMAGE_SERVER_NO) . '" />';
exit;
} else {
echo "unsuccess";
exit;
}
}
}
function Category($row)
{
Module::Module($row);
if (User::have_permit(ADMIN_CATEGORY)) {
$cmd = Url::get('cmd');
$mod = Url::get('mod');
switch ($mod) {
case 'zone':
switch ($cmd) {
case 'delete':
// AZLib::del_cache_zone_cat();
$id = (int) Url::get('id', 0);
if ($id) {
$cat_zone = DB::select('category_zone', 'id=' . $id);
if ($cat_zone) {
DB::delete('category_zone', "id = {$cat_zone['id']}");
DB::delete('category_zone_cat', "zoneid = {$cat_zone['id']}");
}
AZLib::getCats(0, 1);
}
Url::redirect_current(array("mod"));
break;
case 'add':
case 'edit':
require_once 'forms/ZoneEdit.php';
$this->add_form(new ZoneEditForm());
break;
/*case 'move_zonecat_up':
case 'move_zonecat_down':
$id=(int)Url::get('id',0);
if($id){
$zonecat=DB::select('category_zone_cat','catid='.(int)Url::get('catid',0).' AND zoneid='.$id);
if($zonecat){
if($cmd=='move_zonecat_up'){
$nearest_zonecat=DB::select('category_zone_cat','position<'.$zonecat['position'].' AND zoneid='.$id.' ORDER BY position DESC');
}
else{
$nearest_zonecat=DB::select('category_zone_cat','position>'.$zonecat['position'].' AND zoneid='.$id.' ORDER BY position ASC');
}
if($nearest_zonecat){
// Vị trí của category trong zone đã được chuẩn hóa
DB::update('category_zone_cat',array('position'=>$nearest_zonecat['position']),'id='.$zonecat['id']);
DB::update('category_zone_cat',array('position'=>$zonecat['position']),'id='.$nearest_zonecat['id']);
}
else
{
//Vị trí không chuẩn, vị trí tiếp theo bằng đúng vị trí của category hiện tại
$nearest_zonecat=DB::select('category_zone_cat','position='.$zonecat['position'].' AND catid<>'.$zonecat['catid'].' AND zoneid='.$id.' ORDER BY position ASC');
if($nearest_zonecat){
if($cmd=='move_zonecat_up')
{
$zonecat['position']++;
}
elseif($zonecat['position'] > 0)
{
$zonecat['position']--;
}
DB::update('category_zone_cat',array('position'=>$zonecat['position']),'id='.$nearest_zonecat['id']);
}
}
}
}
Url::redirect_current(array('mod'=>'zone','cmd'=>'edit','id'=>$id));
break;*/
/*case 'move_zonecat_up':
case 'move_zonecat_down':
$id=(int)Url::get('id',0);
if($id){
$zonecat=DB::select('category_zone_cat','catid='.(int)Url::get('catid',0).' AND zoneid='.$id);
if($zonecat){
if($cmd=='move_zonecat_up'){
$nearest_zonecat=DB::select('category_zone_cat','position<'.$zonecat['position'].' AND zoneid='.$id.' ORDER BY position DESC');
}
else{
$nearest_zonecat=DB::select('category_zone_cat','position>'.$zonecat['position'].' AND zoneid='.$id.' ORDER BY position ASC');
}
if($nearest_zonecat){
// Vị trí của category trong zone đã được chuẩn hóa
DB::update('category_zone_cat',array('position'=>$nearest_zonecat['position']),'id='.$zonecat['id']);
DB::update('category_zone_cat',array('position'=>$zonecat['position']),'id='.$nearest_zonecat['id']);
}
else
{
//Vị trí không chuẩn, vị trí tiếp theo bằng đúng vị trí của category hiện tại
$nearest_zonecat=DB::select('category_zone_cat','position='.$zonecat['position'].' AND catid<>'.$zonecat['catid'].' AND zoneid='.$id.' ORDER BY position ASC');
if($nearest_zonecat){
if($cmd=='move_zonecat_up')
{
$zonecat['position']++;
}
elseif($zonecat['position'] > 0)
{
$zonecat['position']--;
}
DB::update('category_zone_cat',array('position'=>$zonecat['position']),'id='.$nearest_zonecat['id']);
}
}
}
}
Url::redirect_current(array('mod'=>'zone','cmd'=>'edit','id'=>$id));
break;*/
case 'move_up':
case 'move_down':
// AZLib::del_cache_zone_cat();
$id = (int) Url::get('id', 0);
if ($id) {
$cat_zone = DB::select('category_zone', 'id=' . $id);
if ($cat_zone) {
if ($cmd == 'move_up') {
$nearest_cat_zone = DB::select('category_zone', 'position<' . $cat_zone['position'] . ' ORDER BY position DESC');
} else {
$nearest_cat_zone = DB::select('category_zone', 'position>' . $cat_zone['position'] . ' ORDER BY position ASC');
}
if ($nearest_cat_zone) {
DB::update('category_zone', array('position' => $nearest_cat_zone['position']), 'id=' . $cat_zone['id']);
DB::update('category_zone', array('position' => $cat_zone['position']), 'id=' . $nearest_cat_zone['id']);
}
AZLib::getCats(0, 1);
}
}
Url::redirect_current(array("mod"));
break;
case 'show':
case 'hide':
//AZLib::del_cache_zone_cat();
$id = (int) Url::get('id', 0);
if ($id) {
$cat_zone = DB::select('category_zone', 'id=' . $id);
if ($cat_zone) {
if ($cmd == 'hide') {
$status = 0;
} else {
$status = 1;
}
DB::update('category_zone', array('status' => $status), "id={$id}");
AZLib::getCats(0, 1);
}
}
Url::redirect_current(array("mod"));
break;
default:
require_once 'forms/Zone.php';
$this->add_form(new ZoneForm());
}
break;
default:
switch ($cmd) {
case 'del_image':
$id = (int) Url::get('id', 0);
//Xoá file ảnh
if ($id) {
$cat = DB::select('category', "id={$id}");
if ($cat) {
AZLib::ftp_image_delete_file('category/' . $id . '.gif', $cat['img_server']);
//@fopen('http://'.IMAGE_PATH.'?del_cat=1',"r");//Xoá cache file ảnh
}
Url::redirect_current();
}
break;
case 'delete':
$selected_ids = Url::get('selected_ids');
if ($selected_ids) {
$ids = implode(',', $selected_ids);
if ($ids != '') {
// AZLib::del_cache_zone_cat();
DB::delete('category', 'id IN(' . $ids . ')');
}
AZLib::getCats(0, 1);
}
Url::redirect_current();
break;
case 'del_cache':
// AZLib::del_cache_zone_cat();
AZLib::getCats(0, 1);
Url::redirect_current();
break;
case 'add':
case 'edit':
require_once 'forms/CategoryEdit.php';
$this->add_form(new EditCategoryForm());
break;
case 'move_up':
case 'move_down':
$id = (int) Url::get('id', 0);
if ($id) {
$cat = DB::select('category', 'id=' . $id);
if ($cat) {
// AZLib::del_cache_zone_cat();
if ($cmd == 'move_up') {
$nearest_cat = DB::select('category', 'position<' . $cat['position'] . ' AND parent_id=' . $cat['parent_id'] . ' ORDER BY position DESC');
} else {
$nearest_cat = DB::select('category', 'position>' . $cat['position'] . ' AND parent_id=' . $cat['parent_id'] . ' ORDER BY position ASC');
}
if ($nearest_cat) {
DB::update('category', array('position' => $nearest_cat['position']), 'id=' . $cat['id']);
DB::update('category', array('position' => $cat['position']), 'id=' . $nearest_cat['id']);
}
AZLib::getCats(0, 1);
}
}
Url::redirect_current();
break;
case 'set_home':
case 'show':
case 'hide':
$id = (int) Url::get('id', 0);
if ($id) {
$cat = DB::select('category', 'id=' . $id);
if ($cat) {
// AZLib::del_cache_zone_cat();
if ($cmd == 'set_home') {
$status = 'HOME';
} elseif ($cmd == 'hide') {
$status = 'HIDE';
} else {
$status = 'SHOW';
}
DB::update('category', array('status' => $status), "id={$id}");
AZLib::getCats(0, 1);
}
}
Url::redirect_current();
break;
case 'validated':
case 'un_validated':
$id = (int) Url::get('id', 0);
if ($id) {
$cat = DB::select('category', 'id=' . $id);
if ($cat) {
if ($cmd == 'validated') {
$must_validated = 1;
} elseif ($cmd == 'hide') {
$must_validated = 0;
}
if ($cat['parent_id']) {
DB::update('category', array('must_validated' => $must_validated), "id={$id}");
} else {
DB::update('category', array('must_validated' => $must_validated), "parent_id={$id} OR id={$id}");
}
AZLib::getCats(0, 1);
}
}
Url::redirect_current();
break;
case 'phone_verified':
case 'un_phone_verified':
$id = (int) Url::get('id', 0);
if ($id) {
$cat = DB::select('category', 'id=' . $id);
if ($cat) {
if ($cmd == 'phone_verified') {
$must_phone_verified = 1;
} elseif ($cmd == 'hide') {
$must_phone_verified = 0;
}
if ($cat['parent_id']) {
DB::update('category', array('must_phone_verified' => $must_phone_verified), "id={$id}");
} else {
DB::update('category', array('must_phone_verified' => $must_phone_verified), "parent_id={$id} OR id={$id}");
}
AZLib::getCats(0, 1);
}
}
Url::redirect_current();
break;
case 'optimize':
$this->optimize();
AZLib::getCats(0, 1);
Url::redirect_current();
break;
case 'filter':
require_once 'forms/Filter.php';
$this->add_form(new FilterForm());
break;
case 'filter_list':
require_once 'forms/FilterList.php';
$this->add_form(new FilterListForm());
break;
case '':
require_once 'forms/Category.php';
$this->add_form(new ListCategoryForm());
break;
default:
Url::redirect_current();
break;
}
break;
}
} else {
Url::access_denied();
}
}
function on_submit()
{
if (User::is_admin()) {
if (Url::get('cmd') == 'delete') {
$id = (int) Url::get('id', 0);
if ($id) {
$record = DB::select('adv_banner', 'id=' . $id);
}
AZLib::ftp_image_delete_file($record['img'], $record['img_server']);
$sql = 'delete FROM adv_banner WHERE id = ' . $id;
DB::query($sql);
AZLib::getAdvBanners(1);
} else {
$this->banner['title'] = Url::get('title');
$this->banner['link'] = Url::get('link');
$zones = Url::get('zones');
$blank = Url::get('blank');
$is_home = Url::get('is_home');
$this->banner['is_home'] = $is_home;
$this->banner['blank'] = $blank;
$start_date = Url::get('advStartDate', 0);
$end_date = Url::get('advEndDate', 0);
if ($start_date) {
$date_arr = explode("-", $start_date);
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$this->banner['start_date'] = mktime(0, 0, 0, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]);
}
} else {
$this->banner['start_date'] = 0;
}
if ($end_date) {
$date_arr = explode("-", $end_date);
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$this->banner['end_date'] = mktime(23, 59, 59, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]);
}
} else {
$this->banner['end_date'] = 0;
}
if ($zones) {
if (is_array($zones)) {
$this->banner['zones'] = implode(',', $zones);
}
}
/* $catids = Url::get('catids');
if($catids)
{
if(is_array($catids)) $this->banner['catids'] = implode(',',$catids);
} */
if (Url::get('cmd') == '') {
$this->banner['username'] = User::$current->data['user_name'];
$this->banner['c_time'] = strtotime("now");
}
$this->banner['m_username'] = User::$current->data['user_name'];
$this->banner['m_time'] = strtotime("now");
//Gen image unique name
$img = $_FILES['img']['name'];
$img = explode('.', $img);
$img = array_pop($img);
$mini = microtime(true);
$img = $mini . '.' . $img;
if ($_FILES['img']['tmp_name']) {
if (Url::get('cmd') == 'edit') {
//sửa
AZLib::ftp_image_delete_file('items/adv_banner/' . $img, $this->banner['img_server']);
}
if (AZLib::ftp_check_dir('items/adv_banner/', true, IMAGE_SERVER_NO)) {
$file_name = 'items/adv_banner/' . $img;
$sourceName = $_FILES['img']['tmp_name'];
AZLib::ftp_image_put_file($file_name, $sourceName, IMAGE_SERVER_NO);
$this->banner['img'] = $file_name;
}
}
if (!$this->errNum) {
if (Url::get('cmd') == 'edit') {
$id = (int) Url::get('id', 0);
DB::update('adv_banner', $this->banner, 'id=' . $id);
} else {
$id = DB::insert('adv_banner', $this->banner);
}
AZLib::getAdvBanners(1);
}
}
}
}
function on_submit()
{
$news_catid = Url::get('news_catid', 0);
if (!$news_catid) {
$this->setFormError('news_catid', "Bạn chưa chọn Danh mục cho Sản phẩm!");
} else {
$news_category = DB::select('news_categories', 'id=' . $news_catid);
if (!$news_category) {
$this->setFormError('news_catid', "Danh mục không tồn tại, mời bạn chọn Danh mục khác!");
}
}
$title = Url::get('title');
$brief = Url::get('brief', '');
$content = Url::get('content', '');
$hot = Url::get('hot', 0);
$focus = Url::get('focus', 0);
$status = Url::get('status', 0);
$image_title = Url::get('image_title');
/*if($image_title=='')
$image_title = AznetLib::convert_utf8_to_sms(AznetLib::subString($title,0,30,true));*/
$pen_name = Url::get('pen_name');
$source = Url::get('source', '');
$get_source = Url::get('get_source', 0);
$this->checkFormInput('Tiêu đề tin', "title", $title, 'str', true, '', 1, 255);
$this->checkFormInput('Nội dung tóm tắt', "brief", $brief, 'str', true);
$this->checkFormInput('Tiêu đề ảnh', "image_title", $image_title, 'str', false, '', 1, 100);
$this->checkFormInput('Nội dung tin', "content", $content, 'str', true);
if (!$this->errNum) {
$news_image = array("name" => $this->news['image'], "img_server" => $this->news['img_server'], "title" => addslashes($image_title));
if (isset($_FILES['main_image']) && $_FILES['main_image']['error'] == 0) {
if ($_FILES['main_image']['name'] && getimagesize($_FILES['main_image']['tmp_name'])) {
$file_ext = AZLib::getExtension($_FILES['main_image']['name']);
if (in_array($file_ext, array('.jpg', '.jpeg', '.gif', '.png'))) {
if ($_FILES['main_image']['size'] <= Item::MAX_UPLOAD_SIZE) {
$news_image = array("name" => $this->news['image'], "img_server" => $this->news['img_server'], "title" => addslashes($image_title), 'time_create' => TIME_NOW, 'news_id' => $this->news['id'], 'username' => User::user_name());
$uploadPath = AZLib::folderUpload(User::id(), "news");
$file_name = $uploadPath . date("YmdHis", TIME_NOW) . '_' . substr(AZLib::make_safe_name(basename(strtolower($_FILES['main_image']['name']), $file_ext)), 0, 36) . $file_ext;
if (AZLib::ftp_check_dir($uploadPath) && AZLib::ftp_image_put_file($file_name, $_FILES['main_image']['tmp_name'], IMAGE_SERVER_NO)) {
$news_image['name'] = $file_name;
$news_image['img_server'] = IMAGE_SERVER_NO;
$image_id = DB::insert('news_image', $news_image);
if ($image_id) {
if ($this->news['image'] != '') {
AZLib::ftp_image_delete_file($this->news['name'], $this->news['img_server']);
DB::delete("news_image", "news_id = " . $this->news['id'] . " AND id!= {$image_id}");
}
} else {
$this->setFormError('image', "Không cập nhật được <b>Ảnh đại diện</b>!");
return;
}
} else {
$this->setFormError('image', "Không upload được <b>Ảnh đại diện</b>!");
return;
}
} else {
$this->setFormError('image', "Dung lượng ảnh quá lớn, dung lượng ảnh phải < 1 MB!");
return;
}
} else {
$this->setFormError('image', "Ảnh không đúng định dạng, chỉ chấp nhận các file .jpg, .jpeg, .gif, .png !");
return;
}
} else {
$this->setFormError('image', "Lỗi <b>Ảnh đại diện</b>!");
return;
}
}
if ($get_source) {
//require_once('includes/news.php');
//$content=News::convertContent(addslashes($content),$this->news['id']);
}
if ($brief == '') {
$brief = AznetLib::subString($content, 0, 300, true);
}
if (DB::update('news', array('news_catid' => $news_catid, 'title' => addslashes($title), 'brief' => addslashes($brief), 'content' => addslashes($content), 'image' => $news_image['name'], 'image_title' => $news_image['title'], 'img_server' => $news_image['img_server'], 'status' => $status, 'pen_name' => addslashes($pen_name), 'source' => addslashes($source), 'get_source' => $get_source, 'time_modify' => TIME_NOW, 'user_modify' => User::user_name(), 'hot' => $hot, 'focus' => $focus), "id=" . $this->news['id'], __LINE__ . __FILE__)) {
if (Url::get('href')) {
Url::redirect_url(urldecode(Url::get('href')));
} else {
Url::redirect_current();
}
}
$this->setFormError('title', "Không sửa được tin, mời bạn thử lại!");
}
}
