<?php
add_action('wp_ajax_account_activity_load_list_deal', 'account_activity_load_list_deal');
function account_activity_load_list_deal() {
$current_user_id = get_current_user_id();
if( !isset( $_POST['token']) or !wp_verify_nonce($_POST['token'],AT_NONCE_KEY.'ajax-nonce'.$current_user_id ) ) die("error");
global $bj_controller;
$model = $bj_controller->Model("business");
$list_deal = $model->activity_load_deal_id(5);
if(!empty($list_deal)){
$deal_model = $bj_controller->Model("deal");
foreach ($list_deal as $value) {
$deal_detail = $deal_model->get_deal_detail($value["deal_id"]);
echo '<div class="col-6">';
get_template_part("framework/views/deal/item","",$deal_detail);
echo '</div>';
}
}else{
echo '<p class="p-3">'.__("No data","umm").'</p>';
}
wp_die();
}
add_action('wp_ajax_account_activity_get_tab_number', 'account_activity_get_tab_number');
function account_activity_get_tab_number() {
$current_user_id = get_current_user_id();
if( !isset( $_POST['token']) or !wp_verify_nonce($_POST['token'],AT_NONCE_KEY.'ajax-nonce'.$current_user_id ) ) die("error");
if(!isset($_POST["type"]) or !in_array($_POST["type"],["activity","business"])) die("error");
global $bj_controller, $wpdb;
$return = array(
"deal" => 0,
"event" => 0
);
if($_POST["type"] == "activity"){
$list_deal = $bj_controller->Model("business")->activity_load_deal_id(10000);
if(!empty($list_deal)) $return["deal"] = count($list_deal);
}else{
$list_business_arr = $bj_controller->Model("business")->get_list_business_by_user_id($current_user_id);
if(!empty($list_business_arr)) {
$arr = [];
foreach ($list_business_arr as $value) {
$arr[] = $value["id"];
}
$table = $wpdb->prefix."bj_business_deal";
$business_id_arr = implode("','",$arr);
$list_deal = $wpdb->get_results ( " SELECT * FROM {$table} WHERE business_id IN ('{$business_id_arr}') ORDER BY id DESC" ,ARRAY_A);
if(!empty($list_deal)) $return["deal"] = count($list_deal);
};
}
die(json_encode($return));
}
<?php
class BJ_deal_Model {
private $table_business_deal = 'bj_business_deal';
public function get_deal_detail($deal_id) {
global $wpdb;
$table = $wpdb->prefix . $this->table_business_deal;
$result = $wpdb->get_results($wpdb->prepare(" SELECT * FROM {$table} WHERE id = %d", $deal_id), ARRAY_A);
if (!empty($result)) {
return $result[0];
}
}
public function deal_get_list_user_id_saved($deal_id) {
global $wpdb;
$table = $wpdb->prefix . "bj_business_deal_saved";
$result = $wpdb->get_results($wpdb->prepare(" SELECT user_id FROM {$table} WHERE deal_id = %d ", $deal_id), ARRAY_A);
$arr = [];
if (!empty($result)) {
foreach ($result as $value) {
$arr[] = $value["user_id"];
}
}
return $arr;
}
}
<?php
class BJ_business_Model{
private $table_business = 'bj_business';
public function activity_load_deal_id($number = 20,$offset = 0){
$current_user_id = get_current_user_id();
global $wpdb;
$table = $wpdb->prefix."bj_business_deal_saved";
$result = $wpdb->get_results ( $wpdb->prepare(" SELECT deal_id FROM {$table} WHERE user_id = %d ORDER BY id DESC LIMIT %d,%d",$current_user_id,$offset,$number) ,ARRAY_A);
if(!empty($result)) return $result;
}
public function get_list_business_by_user_id($user_id){
global $wpdb;
$table = $wpdb->prefix.$this->table_business;
$result = $wpdb->get_results ( $wpdb->prepare(" SELECT * FROM {$table} WHERE user_id = %d ORDER BY id DESC",$user_id) ,ARRAY_A);
if(!empty($result)) return $result;
}
}// end class
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 27, 2022 at 09:43 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `wordpress8`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_bj_business`
--
CREATE TABLE `wp_bj_business` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`phone` varchar(15) NOT NULL,
`description` text NOT NULL,
`open_hour` varchar(255) NOT NULL,
`province` varchar(5) NOT NULL,
`district` varchar(5) NOT NULL,
`ward` varchar(7) NOT NULL,
`street` varchar(255) NOT NULL,
`price_from` int(11) NOT NULL,
`price_to` int(11) NOT NULL,
`category_id` int(4) NOT NULL,
`website_link` varchar(255) NOT NULL,
`facebook_link` varchar(255) NOT NULL,
`images` varchar(255) NOT NULL,
`rate` int(1) NOT NULL,
`n_o_rate` int(8) NOT NULL,
`saved` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `wp_bj_business`
--
INSERT INTO `wp_bj_business` (`id`, `user_id`, `name`, `phone`, `description`, `open_hour`, `province`, `district`, `ward`, `street`, `price_from`, `price_to`, `category_id`, `website_link`, `facebook_link`, `images`, `rate`, `n_o_rate`, `saved`) VALUES
(1, 2, 'Kiwooza Planet', '0123456789', 'Description: We buy clothes. To update scientific information and new recommendations for optimal...', '[[\"mon\",\"Monday\",\"08:00\",\"21:00\"],[\"tue\",\"Tuesday\",\"08:00\",\"21:00\"],[\"wed\",\"Wednesday\",\"08:00\",\"21:00\"],[\"thu\",\"Thursday\",\"08:00\",\"21:00\"],[\"fri\",\"Friday\",\"08:00\",\"21:00\"]]', '79', '760', '26734', 'Nguyễn Xí', 200000, 400000, 4, 'Kiwooza.com', '#', '[4,5]', 0, 0, 0),
(2, 2, 'Kiwooza Planet 02', '0367676128', 'Description: We buy clothes. To update scientific information and new recommendations for optimal...', '[[\"wed\",\"Wednesday\",\"08:00\",\"21:00\"],[\"thu\",\"Thursday\",\"08:00\",\"21:00\"]]', '01', '001', '00004', '128 Nguyễn Đình Chiểu', 300000, 900000, 3, '#', '#', '[6]', 5, 1, 0),
(3, 2, 'Add from app', '0123456789', 'Description ', '[[\"mon\",\"Monday\",\"08:00\",\"21:00\"],[\"tue\",\"Tuesday\",\"08:00\",\"21:00\"],[\"wed\",\"Wednesday\",\"08:00\",\"21:00\"],[\"thu\",\"Thursday\",\"08:00\",\"21:00\"],[\"fri\",\"Friday\",\"08:00\",\"21:00\"]]', '79', '769', '26815', 'Vo van ngan', 120000, 500000, 1, '#', '#', '[7]', 0, 0, 0),
(4, 2, 'Landmark 81', '0356214413', 'Tòa nhà cao nhất Việt Nam The Landmark 81 của Tập đoàn Vingroup', '[[\"mon\",\"Monday\",\"07:30\",\"22:00\"],[\"tue\",\"Tuesday\",\"08:00\",\"21:00\"],[\"wed\",\"Wednesday\",\"08:00\",\"21:00\"],[\"thu\",\"Thursday\",\"08:00\",\"21:00\"],[\"fri\",\"Friday\",\"08:00\",\"21:00\"]]', '79', '765', '26956', '208 Nguyễn Hữu Cảnh', 100000, 900000, 1, 'landmark.com', 'facebook.com/landmark', '[8,9,10]', 4, 4, 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `wp_bj_business`
--
ALTER TABLE `wp_bj_business`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `wp_bj_business`
--
ALTER TABLE `wp_bj_business`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 27, 2022 at 09:46 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `wordpress8`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_bj_business_deal_saved`
--
CREATE TABLE `wp_bj_business_deal_saved` (
`id` int(11) NOT NULL,
`deal_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `wp_bj_business_deal_saved`
--
INSERT INTO `wp_bj_business_deal_saved` (`id`, `deal_id`, `user_id`) VALUES
(5, 1, 2),
(10, 3, 2);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `wp_bj_business_deal_saved`
--
ALTER TABLE `wp_bj_business_deal_saved`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `wp_bj_business_deal_saved`
--
ALTER TABLE `wp_bj_business_deal_saved`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;img
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 27, 2022 at 09:48 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `wordpress8`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_bj_business_deal`
--
CREATE TABLE `wp_bj_business_deal` (
`id` int(11) NOT NULL,
`business_id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`date_from` date NOT NULL,
`date_to` date NOT NULL,
`quantity` int(7) NOT NULL,
`images` varchar(255) NOT NULL,
`saved` int(5) NOT NULL,
`district` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `wp_bj_business_deal`
--
INSERT INTO `wp_bj_business_deal` (`id`, `business_id`, `title`, `description`, `date_from`, `date_to`, `quantity`, `images`, `saved`, `district`) VALUES
(1, 4, '10% Sale Off ', 'We buy clothes. To update scientific information and new recomm-endations for optimal management of elderly patients; ', '2022-02-16', '2022-02-20', 10, '[11,12,13]', 1, ''),
(2, 2, 'Kiwiooza 10% Sale Off', 'Kiwiooza 10% Sale Off For All Orders', '2022-02-26', '2022-02-28', 100, '[14,15]', 0, ''),
(3, 4, 'flower', 'nice flower', '2022-02-19', '2022-02-19', 12, '[16]', 1, '765'),
(4, 2, 'test', '123', '2022-02-21', '2022-02-24', 19, '[25]', 0, '001');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `wp_bj_business_deal`
--
ALTER TABLE `wp_bj_business_deal`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `wp_bj_business_deal`
--
ALTER TABLE `wp_bj_business_deal`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
<?php
class BJ_directory_Model{
private $table_business = 'bj_business';
public function get_business_detail($business_id){
global $wpdb;
$table = $wpdb->prefix.$this->table_business;
$result = $wpdb->get_results ( $wpdb->prepare(" SELECT * FROM {$table} WHERE id = %d",$business_id) ,ARRAY_A);
if(!empty($result)) return $result[0];
}
}
