Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once ("sql.php");
- $db = new DB();
- if( isset($name) ) {
- define('query','?'.$_SERVER['QUERY_STRING']);
- $menuPage = $db->alone_data_where("menu","name",$name);
- $file = $menuPage->file;
- if(isset($_POST["action"])){
- $table = $_POST["table"];
- $action = $_POST["action"];
- unset($_POST["table"]);
- unset($_POST["action"]);
- switch ($action) {
- case 'add':
- if($file == 'config'){
- $_POST["file"] = 'content';
- $_POST["name"] = 'none';
- }
- $sql = "INSERT INTO `".dbPrefix."$table`(";
- foreach($_POST as $key=>$get){
- $sql.= "`".$key."`,";
- }
- $sql.= "`title`) VALUES (";
- foreach($_POST as $key=>$get){
- $sql.= "'".$get."',";
- }
- $sql.= "'None');";
- if($db->execute_sql($sql)){
- $success = "Thêm thành công !";
- }else{
- echo $sql;
- }
- break;
- case 'del':
- $value = $_POST["value"];
- $sql = "";
- $sql.= "DELETE FROM `".dbPrefix."$table` WHERE `id` = '$value'; ";
- switch ($table) {
- case 'menu':
- $allListMenuChild = array();
- $allListMenuChild = $db->allListMenuChild($value,$allListMenuChild);
- foreach($allListMenuChild as $menu){
- if($menu->id !== 0 && $menu->id !== '0' && $menu->id !== ''){
- $sql.="DELETE FROM `".dbPrefix."menu` WHERE `menu_parent` = '$menu->id'; ";
- $sql.="DELETE FROM `".dbPrefix."data` WHERE `menu` = '$menu->id'; ";
- }
- }
- break;
- case 'data':
- $sql.="DELETE FROM `".dbPrefix."data` WHERE `data_parent` = '$value'; ";
- break;
- }
- if($db->execute_sql($sql)){
- $success = "Xóa thành công !";
- }else{
- echo $sql;
- }
- break;
- }
- }else if(count($_POST)){
- $timeNow = '-'.renameTitle(timeNow());
- if(isset($id)){
- $idPost = $id;
- }else if(isset($idList)){
- $idPost = $idList;
- }else{
- $idPost = $menuPage->id;
- }
- $target_dir = "../upload/";
- switch ($file) {
- case 'config':
- if(isset($_POST["listMenu"]) && count($_POST["listMenu"])){
- $sql = "";
- foreach($_POST["listMenu"] as $key=>$menu){
- $menu["name"] = renameTitle($menu["title"]);
- $db->updateRow('menu',$menu,'id',$key);
- }
- }
- $check = $array = [];
- $dataPage = $db->list_data('page');
- foreach($dataPage as $data){
- $check[$data->name] = $data->content;
- }
- foreach($_POST as $key=>$post){
- if(isset($check[$key])){
- $array[$key] = $post;
- }
- }
- if(isset($_FILES)){
- foreach($_FILES as $key=>$f){
- if(($f["name"]) !== "" ){
- $vlFile = explode(".",$f["name"]);
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- $array[$key] = $vl;
- move_uploaded_file($f["tmp_name"],$target_dir.$vl);
- }
- }
- }
- if($db->updateTable('page',$array,'content','name')){
- $success = "Lưu thành công !";
- }
- break;
- /*case 'show-news':
- case 'show-products':*/
- case 'post':
- case 'design':
- $array = array();
- foreach ($_POST as $key=>$post) {
- $array[$key] = $post;
- }
- if(count($array)){
- $array["time"] = timeNow();
- if($db->insertData('data',$array)){
- $success = "Gửi yêu cầu thành công !";
- }
- }
- break;
- }
- if(isset($id)){
- $_POST["time"] = timeNow();
- }
- if(isset($_FILES["img"])){
- $f = $_FILES["img"];
- $vlFile = explode(".",$f["name"]);
- if(count($vlFile) > 1){
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- if(move_uploaded_file($f["tmp_name"], $target_dir.$vl)){
- $_POST["img"] = $vl;
- }
- }
- }
- if(isset($_FILES["file"])){
- $f = $_FILES["file"];
- $vlFile = explode(".",$f["name"]);
- if(count($vlFile) > 1){
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- if(move_uploaded_file($f["tmp_name"], $target_dir.$vl)){
- $_POST["file"] = $vl;
- }
- }
- }
- if(isset($_POST["listData"])){
- $sql = "";
- foreach($_POST["listData"] as $key=>$data){
- $db->updateRow('data',$data,'id',$key);
- }
- }
- if(isset($_FILES["listData"])){
- foreach($_FILES["listData"]["name"] as $key=>$f){
- if($_FILES["listData"]["name"][$key] !== '' ){
- $vlFile = explode(".",$_FILES["listData"]["name"][$key]);
- if(count($vlFile) > 1){
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- if(move_uploaded_file($_FILES["listData"]["tmp_name"][$key], $target_dir.$vl)){
- $data["img"] = $vl;
- $db->updateRow('data',$data,'id',$key);
- }
- }
- }
- }
- }
- if( (isset($menuPage) && isset($_POST["content"]) && !isset($idList) && !isset($id)) || (isset($_POST['content']) && $idList == $menuPage->id)){
- if($db->updateRow("menu",$_POST,'id',$menuPage->id)){
- $success = "Lưu thành công !";
- }
- }
- if(isset($_POST["table"])){
- if($db->updateRow($_POST["table"],$_POST,'id',$_POST["id"])){
- $success = "Lưu thành công !";
- }
- }
- if(isset($_POST["images"][0]) && count($_POST["images"])){
- foreach($_POST["images"] as $images){
- $type = $images;
- if(isset($_FILES[$type])){
- foreach($_FILES[$type]["name"] as $key=>$vl){
- if($vl !== ""){
- $vlFile = explode(".",$vl);
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- if(move_uploaded_file($_FILES[$type]["tmp_name"][$key], $target_dir.$vl)){
- $db->insertImage($idPost,$type,$vl);
- }
- }
- }
- }
- }
- }
- if(isset($_FILES["slideData"])){
- foreach($_FILES["slideData"]["name"] as $key=>$vl){
- if($vl !== ""){
- $vlFile = explode(".",$vl);
- $vl = renameTitle($vlFile[0]).$timeNow.".".$vlFile[1];
- if(move_uploaded_file($_FILES["slideData"]["tmp_name"][$key], $target_dir.$vl)){
- $db->insertImageData($idPost,'slide',$vl);
- }
- }
- }
- }
- }
- $menuPage = $db->alone_data_where("menu","name",$name);
- if (isset($id)) {
- $page = $db->alone_data_where("data","id",$id);
- $update["view"] = $page->view + 1;
- $db->updateRow("data",$update,'id',$id);
- $idMenu = $page->menu;
- }else if(isset($idList)){
- $page = $db->alone_data_where("menu","id",$idList);
- $idMenu = $page->id;
- }else{
- $idMenu = $menuPage->id;
- }
- }
- $password = $db->alone_data_where("page","name","password");
- $password = $password->content;
- $listMenu = $db->list_data_where_where_order("menu","menu_parent",0,'hide',0,'pos','ASC');
- $listMenuAdmin = $db->list_data_where_order("menu","menu_parent",0,'pos','ASC');
- $listPage = $db->list_data("page");
- $infoPage = new stdClass();
- foreach ($listPage as $vl) {
- $key = $vl->name;
- $infoPage->$key = $vl->content;
- }
- if(isset($page)){
- $title = $page->title;
- $image = $page->img;
- $des = $infoPage->des;
- if(isset($page->price)){
- $des = $page->price;
- }
- }else if(isset($menuPage)){
- $title = $menuPage->title;
- if($menuPage->file == 'home'){
- $title = $infoPage->title;
- }
- $image = $infoPage->logo;
- $des = $infoPage->des;
- }
- $menuShop = $db->alone_data_where("menu","file","shop");
- $menuMap = $db->alone_data_where("menu","file","map");
- $menuHome = $db->alone_data_where("menu","file","home");
- $menuSearch = $db->alone_data_where("menu","file","search");
- $menuPost = $db->alone_data_where("menu","file","post");
- $menuProduct = $db->alone_data_where("menu","file","show-products");
- $menuNews = $db->alone_data_where("menu","name","tin-tuc");
- $menuDesign = $db->alone_data_where("menu","file","design");
- $menuUser = $db->alone_data_where("menu","file","user");
- $menuContact = $db->alone_data_where("menu","file","contact");
- $list = new stdClass;
- foreach($config->showListImageAdmin as $key=>$listImage){
- $list->$key = $db->list_data_where_where_order("data","menu",$menuHome->id,'type',$key,'pos','ASC');
- }
- if(isset($menuPage)){
- $menuFile = $menuPage->file;
- if(isset($config->showIdListAdmin->$menuFile)){
- $configMenu = $config->showIdListAdmin->$menuFile;
- }
- }
- ?>
Add Comment
Please, Sign In to add comment