/**
* @author Thuanth6589 <*****@*****.**>
* delete media
* @param $media_id
* @return bool
*/
public function delete_media($media_id)
{
$media = Model_Mmedia::find_by_pk($media_id);
if ($media) {
try {
$media_in_job = Model_Job::count('job_id', false, array(array('media_list', 'like', '%,' . $media_id . ',%')));
$media_in_order = Model_Orders::count('order_id', false, array(array('media_list', 'like', '%,' . $media_id . ',%')));
if ($media_in_job || $media_in_order) {
return false;
}
\Fuel\Core\DB::start_transaction();
$post = new Model_Mpost();
$delete_post = $post->delete_by_media($media_id);
if (!isset($delete_post)) {
\Fuel\Core\DB::rollback_transaction();
return false;
}
if ($media->delete() != 1) {
\Fuel\Core\DB::rollback_transaction();
return false;
}
\Fuel\Core\DB::commit_transaction();
return true;
} catch (Exception $e) {
\Fuel\Core\DB::rollback_transaction();
}
}
return false;
}
public function action_upload_img()
{
$order_id = \Fuel\Core\Input::post('order_id');
$model_order = \Model_Orders::find_by_pk($order_id);
if (!$model_order) {
return 'failed';
}
$data = array('image_content' => base64_decode(\Fuel\Core\Input::post('content_image', null)), 'width' => \Fuel\Core\Input::post('width', null), 'height' => \Fuel\Core\Input::post('height', null), 'mine_type' => \Fuel\Core\Input::post('mine_type', null));
$obj_order = new \Model_Orders();
if ($res = $obj_order->order_update($data, $order_id)) {
\Fuel\Core\Session::set_flash('success', '媒体画像を登録しました。');
} else {
\Fuel\Core\Session::set_flash('error', '媒体画像登録は失敗しました。');
}
return new \Response($res, 200, array());
}
public function orderIsPay($order_id)
{
$row = Model_Orders::get($order_id);
if (!is_array($row)) {
return;
//ERROR
}
$user = Model_Users::getUser($row['owner_id']);
$percent = Model_Percentes::getPercentRow($user);
$percent = $percent['percent'];
$receiveMoney = floatval($row['price']) * floatval($percent) / 100;
$db = JO_Db::getDefaultAdapter();
$db->update('orders', array('paid_datetime' => new JO_Db_Expr('NOW()'), 'receive' => $receiveMoney), array('id = ?' => (int) $order_id));
$db->update(Model_Users::getPrefixDB() . 'users', array('earning' => new JO_Db_Expr('earning+' . $receiveMoney), 'total' => new JO_Db_Expr('total+' . $receiveMoney), 'sold' => new JO_Db_Expr('sold+' . $row['price']), 'sales' => new JO_Db_Expr('sales+1')), array('user_id = ?' => $row['owner_id']));
$you = Model_Users::getUser($row['user_id']);
#CHECK REFERAL
if ($you['referal_id'] != '0') {
$row['order_id'] = $order_id;
self::referalMoney($row, $you);
}
$db->update(Model_Users::getPrefixDB() . 'users', array('buy' => new JO_Db_Expr('buy+1')), array('user_id = ?' => $row['user_id']));
$toinsert = array('sales' => new JO_Db_Expr('sales+1'), 'earning' => new JO_Db_Expr('earning+' . $row['price']));
#UPDATE ITEM
if ($row['extended'] == 'true') {
$db->update('users', array('items' => new JO_Db_Expr('items-1')), array('user_id = ?' => $row['owner_id']));
$toinsert['status'] = 'extended_buy';
}
$db->update('items', $toinsert, array('id = ?' => $row['item_id']));
return true;
}
public function action_index()
{
$model = array();
$counter = 0;
if (isset($_COOKIE["order_id"])) {
$orders = new Model_Orders();
$order_data = $orders->getOrder($_COOKIE["order_id"]);
if (isset($order_data['items'])) {
foreach ($order_data['items'] as $item_id => $item) {
$counter += $item['cnt'];
}
}
$model['items_count'] = $counter;
} else {
$model['items_count'] = 0;
}
Resources::add_scripts(array("js/classes/LexFormValidator.js", "js/classes/helpers.js", "js/classes/LexCookie.js", "js/classes/LexCart.js", "js/modules/cart/cart.js"), get_class());
Resources::add_styles(array("css/modules/cart/default.less"), get_class());
return $this->set_template('widgets/cart/button.php')->render($model)->body();
}
public function action_orders($data)
{
// id пользователя
$user_id = Auth::instance()->get_user()->id;
$model_orders = new Model_Orders();
// Поиск заказов пользователя
$orders = $model_orders->getOrders(array(array("user_id", "=", $user_id)));
$replace_val_by_id = function ($id, $val_arr, $table_val_name) {
$res = "";
foreach ($val_arr as $key => $val) {
if ($id == $val["id"]) {
$res = $val[$table_val_name];
break;
}
}
return $res;
};
$delivery_types = $model_orders->getDeliveryTypes();
$payment_types = $model_orders->getPaymentTypes();
$delivery_points = $model_orders->getDeliveryPoints();
$delivery_times = $model_orders->getDeliveryTimes();
$order_statuses = $model_orders->getOrderStatuses();
foreach ($orders as $key => $order) {
$items = Arr::get($model_orders->getOrder($order["id"]), "items");
// Есть товары
if ($items) {
// --- Замена id параметров на человекочитаемые -------------------------------------------------------
$orders[$key]["delivery_type"] = $replace_val_by_id($order["delivery_type"], $delivery_types, "title");
$orders[$key]["payment_type"] = $replace_val_by_id($order["payment_type"], $payment_types, "title");
$orders[$key]["delivery_point"] = $replace_val_by_id($order["delivery_point"], $delivery_points, "title");
$orders[$key]["delivery_time"] = $replace_val_by_id($order["delivery_time"], $delivery_times, "title");
$orders[$key]["status"] = $replace_val_by_id($order["status"], $order_statuses, "title");
// --- /Замена id параметров на человекочитаемые ------------------------------------------------------
//if ($order["id"] == $_COOKIE["order_id"])
//$orders[$key]["tr_style"] = ' style="background-color:#ccc;"';
$orders[$key]["href"] = "/user/cabinet/order/?id=" . $order["id"];
$orders[$key]["all_price"] = number_format($model_orders->get_all_price($order["id"]), 0, '', ' ') . ' руб.';
} else {
// удаляем заказ из таблицы
unset($orders[$key]);
}
}
$model = array("orders" => $orders);
return self::render('user/cabinet/orders.php', $model, "response");
}
public function action_index()
{
if (isset($_POST['status'])) {
$orders = new Model_Orders();
$orders->finishOrder($_POST);
Controller::redirect('/admin/orders');
}
$orders = new Model_Orders();
$order_id = $this->request->param('id');
$model = array('user' => $this->user, 'errors' => $this->errors, 'messages' => $this->messages);
$model = array();
// Все заказы
if ($order_id == null) {
$filter = Arr::get($_GET, "filter", "");
/*
1 - Новый - new
2 - Ожидает - wait
3 - Перезвонить - call
4 - Принят - ok
5 - Отказ - fail
6 - Завершён - success
Брошенная корзина - drop
*/
switch ($filter) {
// Из архива
case "archive":
$items = DB::select()->from("orders")->where("archive", "=", 1)->execute()->as_array();
break;
// Новые
// Новые
case "new":
$items = DB::select()->from("orders")->where("status", "=", 1)->execute()->as_array();
break;
// Ожидает
// Ожидает
case "wait":
$items = DB::select()->from("orders")->where("status", "=", 2)->execute()->as_array();
break;
// Перезвонить
// Перезвонить
case "call":
$items = DB::select()->from("orders")->where("status", "=", 3)->execute()->as_array();
break;
// Принят
// Принят
case "ok":
$items = DB::select()->from("orders")->where("status", "=", 4)->execute()->as_array();
break;
// Отказ
// Отказ
case "fail":
$items = DB::select()->from("orders")->where("status", "=", 5)->execute()->as_array();
break;
// Завершён
// Завершён
case "success":
$items = DB::select()->from("orders")->where("status", "=", 6)->execute()->as_array();
break;
// Брошенная корзина
// Брошенная корзина
case "drop":
$items = DB::select()->from("orders")->where("time", "<", time() - 3600)->execute()->as_array();
break;
default:
$items = $orders->getOrders();
break;
}
//$model['orders'] = $orders->getOrders();
$model['orders'] = $items;
$template = 'admin/admOrders';
// Конкретный заказ
} else {
$order_id = $this->request->param('id');
//$data['orders'] = $orders->getOrders();
$template = 'admin/admOrder';
$order_data = $orders->getOrder($order_id);
$model['order_id'] = $order_id;
$model['order_data'] = $order_data;
$model['items'] = array();
$all_price = 0;
// Есть товары
if (isset($order_data['items'])) {
foreach ($order_data['items'] as $item_id => $item) {
array_push($model['items'], array('id' => $item_id, 'name' => $item['name'], 'img' => $item['photos'][0]['value'], 'count' => $item['cnt'], 'price' => number_format($item['price'], 0, '', ' ') . ' руб.'));
$all_price += (int) $item['price'] * (int) $item['cnt'];
}
$model['all_price'] = number_format($all_price, 0, '', ' ');
// Нет товаров
} else {
}
}
$this->template->content = View::factory($template, $model);
}
<div class="alert alert-success"><?php
echo $message;
?>
</div>
<?php
}
?>
<?php
}
?>
<!-- ERROR BOXES -->
<!-- <table id="order_table"></table> -->
<?php
$orders_model = new Model_Orders();
$delivery_types = $orders_model->getDeliveryTypes();
$payment_types = $orders_model->getPaymentTypes();
$delivery_points = $orders_model->getDeliveryPoints();
$delivery_times = $orders_model->getDeliveryTimes();
$order_statuses = $orders_model->getOrderStatuses();
$orders[$order_id] = $order_data;
$status = '';
$status .= '<select name="status">';
foreach ($order_statuses as $order_status) {
$selected = $order_status["id"] == $order_data["status"] ? "selected" : "";
$status .= '<option value="' . $order_status['id'] . '" ' . $selected . '>' . $order_status['title'] . '</option>';
}
$status .= '</select>';
$orders[$order_id]['status'] = $status;
// Адрес
/**
* @author Thuanth6589
* @return Response
*/
public function action_check_order()
{
$order_id = Input::post('order_id', 0);
$result = array('message' => false);
if (\Model_Orders::find_by_pk($order_id)) {
$result = array('message' => true);
}
return Response::forge(json_encode($result));
}
public function csv_statementAction()
{
$this->setInvokeArg('noViewRenderer', true);
if (JO_Session::get('user_id')) {
$data = array();
$statements = Model_Orders::getStatement(JO_Session::get('user_id'));
if ($statements) {
$month = $statements[0]['month'];
$data[] = array(ucfirst($this->translate('Date')), $this->translate('Type'), $this->translate('Amount'), $this->translate('Details'));
$st = array();
$cnt = count($statements);
for ($i = 0; $i < $cnt; $i++) {
if ($statements[$i]['type'] == 'deposit') {
$statements[$i]['price'] = WM_Currency::normalize($statements[$i]['price']);
$statements[$i]['details'] = $this->translate('Deposit money');
} elseif ($statements[$i]['type'] == 'withdraw') {
$statements[$i]['price'] = WM_Currency::normalize(-$statements[$i]['price']);
$statements[$i]['details'] = $this->translate('Earning money');
} elseif ($statements[$i]['type'] == 'order') {
if ($statements[$i]['user_id'] == JO_Session::get('user_id')) {
$statements[$i]['type'] = $this->translate('buy');
$statements[$i]['price'] = WM_Currency::normalize($statements[$i]['price']);
} else {
$statements[$i]['type'] = $this->translate('sale');
$statements[$i]['price'] = WM_Currency::normalize($statements[$i]['receive']);
}
$statements[$i]['details'] = $statements[$i]['item_name'];
} elseif ($statements[$i]['type'] == 'referrals') {
if ($statements[$i]['item_name'] == 1) {
$statements[$i]['details'] = $this->translate('Referral / deposit');
} else {
$statements[$i]['details'] = $this->translate('Referral / sale');
}
$statements[$i]['price'] = WM_Currency::normalize($statements[$i]['price']);
} elseif ($statements[$i]['type'] == 'membership') {
$statements[$i]['price'] = WM_Currency::format($statements[$i]['price']);
$statements[$i]['details'] = $this->translate('Membership money');
}
$st[] = array($statements[$i]['day'], $statements[$i]['type'], $statements[$i]['price'], $statements[$i]['details']);
if (isset($statements[$i + 1]['month']) && $month != $statements[$i + 1]['month']) {
$st[] = array('month' => $statements[$i]['month']);
$month = $statements[$i + 1]['month'];
} elseif ($i == $cnt - 1) {
$st[] = array('month' => $statements[$i]['month']);
}
}
}
$st = array_reverse($st);
$data = array_merge($data, $st);
$csv = new Helper_CSVWriter($data);
$csv->headers(JO_Session::get('firstname') . '_' . JO_Session::get('lastname') . '_' . $this->translate('Statement'));
$csv->output();
}
die;
}
public function indexAction()
{
$request = $this->getRequest();
$this->view->base_url = $request->getBaseUrl();
#LINKS FOR HEAD PARTS IN BOX
$this->view->finance_href = $request->getModule() . '/reports/';
$this->view->sales_href = $request->getModule() . '/orders/';
$this->view->users_href = $request->getModule() . '/users/';
$this->view->approval_href = $request->getModule() . '/queueitems/';
$this->view->queue_href = $request->getModule() . '/queueupdateditems/';
$this->view->contacts_href = $request->getModule() . '/contacts/';
$this->view->gainpayingup_href = $request->getModule() . '/gainpayingup/';
$this->view->tags_href = $request->getModule() . '/tags/?filter_visible=false';
#LOAD ORDERS COUNT
$this->view->total = Model_Orders::getSalesStatus();
if ($this->view->total) {
$this->view->total['total_f'] = WM_Currency::format($this->view->total['total']);
}
$ref = Model_Orders::getSalesStatus(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ", 'referal');
$sales = Model_Orders::getSalesStatus(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ");
if ($sales) {
if ($ref) {
$sales['referal'] = $ref['receive'];
} else {
$sales['referal'] = 0;
}
$sales['win'] = floatval($sales['total']) - floatval($sales['receive']) - floatval($sales['referal']);
$sales['total_f'] = WM_Currency::format($sales['total']);
$sales['receive_f'] = WM_Currency::format($sales['receive']);
$sales['referal_f'] = WM_Currency::format($sales['referal']);
$sales['win_f'] = WM_Currency::format($sales['win']);
}
$this->view->sales = $sales;
unset($ref);
$ref = Model_Orders::getSalesStatus("", 'referal');
$sales = Model_Orders::getSalesStatus("");
if ($sales) {
if ($ref) {
$sales['referal'] = $ref['receive'];
} else {
$sales['referal'] = 0;
}
$sales['win'] = floatval($sales['total']) - floatval($sales['receive']) - floatval($sales['referal']);
$sales['total_f'] = WM_Currency::format($sales['total']);
$sales['receive_f'] = WM_Currency::format($sales['receive']);
$sales['referal_f'] = WM_Currency::format($sales['referal']);
$sales['win_f'] = WM_Currency::format($sales['win']);
}
$this->view->sales2 = $sales;
unset($ref);
#LOAD USERS COUNT
$this->view->users = array();
$this->view->users['month'] = Model_Users::getUsersCount(" `register_datetime` > '" . date('Y-m') . "-01 00:00:00' AND `status` = 'activate' ");
$this->view->users['total'] = Model_Users::getUsersCount(" `status` = 'activate' ");
$this->view->topAuthors = array();
$topAuthors = Model_Users::getAll(0, 5, " `status` = 'activate' ", "`sales` DESC");
if ($topAuthors) {
$percentsClass = new Model_Percents();
foreach ($topAuthors as $user) {
$user['deposit'] = WM_Currency::format($user['deposit']);
$user['earning'] = WM_Currency::format($user['earning']);
$user['total'] = WM_Currency::format($user['total']);
$user['sold'] = WM_Currency::format($user['sold']);
$user['referal_money'] = WM_Currency::format($user['referal_money']);
$comision = $percentsClass->getPercentRow($user['user_id']);
$user['commission'] = round($comision['percent']);
$user['sum'] = Model_Balance::getTotalUserBalanceByType($user['user_id']);
$user['web_profit'] = WM_Currency::format($user['web_profit']);
$user['web_profit2'] = WM_Currency::format($user['web_profit2']);
$user['has_referral_sum'] = $user['referral_sum'];
$user['referral_sum'] = WM_Currency::format($user['referral_sum']);
$user['edit_href'] = $request->getModule() . '/users/edite/?id=' . $user['user_id'];
$user['balance_href'] = $request->getModule() . '/users/balance/?id=' . $user['user_id'];
$this->view->topAuthors[] = $user;
}
}
#LOAD WITHDRAW
$this->view->withdraw = array();
$this->view->withdraw['no'] = Model_Deposit::getWithdrawCount(" `paid` = 'false' AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ");
if ($this->view->withdraw['no']) {
$this->view->withdraw['no']['total_f'] = WM_Currency::format($this->view->withdraw['no']['total']);
}
$this->view->withdraw['paid'] = Model_Deposit::getWithdrawCount(" `paid` = 'true' AND `paid_datetime` > '" . date('Y-m') . "-01 00:00:00' ");
if ($this->view->withdraw['paid']) {
$this->view->withdraw['paid']['total_f'] = WM_Currency::format($this->view->withdraw['paid']['total']);
}
#LOAD THEMES
$this->view->items = Model_Items::getItems(array('filter_status' => 'queue', 'start' => 0, 'limit' => 5));
$this->view->updated_items = Model_Items::getItems(array('filter_update' => true, 'start' => 0, 'limit' => 5));
#LOAD LAST REQUEST
$this->view->contacts = array();
$contacts = Model_Contacts::getContacts(array('filter_answer_datetime' => '0000-00-00', 'start' => 0, 'limit' => 5));
if ($contacts) {
foreach ($contacts as $contact) {
$data = new JO_Date($contact['datetime'], 'dd MM yy');
$contact['datetime'] = $data->toString();
$contact['has_response'] = $contact['answer_datetime'] != '0000-00-00 00:00:00';
if ($contact['answer_datetime'] != '0000-00-00 00:00:00') {
$data = new JO_Date($contact['answer_datetime'], 'dd MM yy');
$contact['answer_datetime'] = $data->toString();
} else {
$contact['answer_datetime'] = '';
}
$this->view->contacts[] = $contact;
}
}
#Withdrawals
$this->view->withdraws = array();
$withdraws = Model_Users::getWithdraws(array('start' => 0, 'limit' => 5));
if ($withdraws) {
foreach ($withdraws as $withdraw) {
$withdraw['earning'] = WM_Currency::format($withdraw['earning']);
$date = new JO_Date($withdraw['datetime'], 'dd MM yy');
$withdraw['datetime'] = $date->toString();
if ($withdraw['paid'] == 'true') {
$date = new JO_Date($withdraw['paid_datetime'], 'dd MM yy');
$withdraw['paid_datetime'] = $date->toString();
} else {
$withdraw['paid_datetime'] = '';
}
$withdraw['amount'] = WM_Currency::format($withdraw['amount']);
$this->view->withdraws[] = $withdraw;
}
}
#TAGS NO ACTIVE
$this->view->tags = Model_Tags::getTags(array('filter_visible' => 'false', 'start' => 0, 'limit' => 20));
#DRAW GRAPHCS
$referal_sum = Model_Orders::getSalesStatusByDay(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ", 'referal');
$sales_sum = Model_Orders::getSalesStatusByDay(" AND `datetime` > '" . date('Y-m') . "-01 00:00:00' ");
$referal_money = array();
$sales_money = array();
$user_money = array();
$win_money = array();
$sales_num = array();
$referal_num = array();
$days = array();
// for($i=1; $i<= date('t'); $i++) {
// if(isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)])) {
// $referal_money[] = number_format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], 2, '.', '');
// } else {
// $referal_money[] = 0;
// }
// if(isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)])) {
// $sales_money[] = number_format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'], 2, '.', '');
// $user_money[] = number_format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], 2, '.', '');
// if(isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'])) {
// $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'];
// }
// if(!isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])) {
// $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = 0;
// }
// $sales_num[] = $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['num'];
// $win_money[] = number_format( floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal']), 2, '.', '');
// } else {
// $sales_money[] = 0;
// $user_money[] = 0;
// $win_money[] = 0;
// $sales_num[] = 0;
// }
// $days[] = $i;
// }
for ($i = 1; $i <= date('t'); $i++) {
if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)])) {
$referal_money[] = array(WM_Currency::format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']), (double) WM_Currency::format($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], '', '', false));
} else {
$referal_money[] = array(WM_Currency::format(0), 0);
}
if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['num'])) {
$referal_num[] = array($i, $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['num']);
} else {
$referal_num[] = array($i, 0);
}
if (isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)])) {
$sales_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total']), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'], '', '', false));
$user_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'], '', '', false));
if (isset($referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'])) {
$sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = $referal_sum[date("Y-m-") . sprintf('%02d', $i)]['receive'];
}
if (!isset($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])) {
$sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'] = 0;
}
$sales_num[] = array($i, $sales_sum[date("Y-m-") . sprintf('%02d', $i)]['num']);
$win_money[] = array(WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'] - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal'])), (double) WM_Currency::format($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['total'] - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['receive']) - floatval($sales_sum[date("Y-m-") . sprintf('%02d', $i)]['referal']), '', '', false));
} else {
$sales_money[] = array(WM_Currency::format(0), 0);
$user_money[] = array(WM_Currency::format(0), 0);
$win_money[] = array(WM_Currency::format(0), 0);
$sales_num[] = array($i, 0);
}
$days[] = $i;
}
$new_array = array();
$new_array[] = array('name' => $this->translate('Total'), 'data' => $sales_money);
$new_array[] = array('name' => $this->translate('User\'s profit'), 'data' => $user_money);
$new_array[] = array('name' => $this->translate('Net total'), 'data' => $win_money);
$new_array[] = array('name' => $this->translate('Referent'), 'data' => $referal_money);
$new_array2 = array();
$new_array2[] = array('name' => $this->translate('Referent'), 'data' => $referal_num);
$new_array2[] = array('name' => $this->translate('Sales'), 'data' => $sales_num);
$this->view->finance_array = JO_Json::encode($new_array);
$this->view->sales_array = JO_Json::encode($new_array2);
$this->view->days = JO_Json::encode($days);
$this->view->currency = WM_Currency::getCurrency();
}
public function liveSearchAction()
{
$this->noViewRenderer();
$request = $this->getRequest();
$type = $request->getQuery('filter');
$json = array();
switch ($type) {
case 'item':
$items = Model_Orders::getAll(array('start' => 0, 'limit' => 100, 'filter_name' => $request->getQuery('term')));
if ($items) {
$cache = array();
foreach ($items as $item) {
if (!isset($cache[$item['item_name']])) {
$json[] = array('id' => $item['id'], 'label' => $item['item_name'], 'value' => $item['item_name']);
$cache[$item['item_name']] = true;
}
}
}
break;
case 'user':
$users = Model_Users::getUsers(array('start' => 0, 'limit' => 100, 'filter_username' => $request->getQuery('term')));
if ($users) {
$cache = array();
foreach ($users as $user) {
if (!isset($cache[$user['username']])) {
$json[] = array('id' => $user['user_id'], 'label' => $user['username'], 'value' => $user['username']);
$cache[$user['username']] = true;
}
}
}
break;
case 'tags':
$tags = Model_Tags::getTags(array('start' => 0, 'limit' => 100, 'filter_name' => $request->getQuery('term')));
if ($tags) {
$cache = array();
foreach ($tags as $tag) {
if (!isset($cache[$tag['name']])) {
$json[] = array('id' => $tag['id'], 'label' => $tag['name'], 'value' => $tag['name']);
$cache[$tag['name']] = true;
}
}
}
break;
}
$response = $this->getResponse();
$response->addHeader('Cache-Control: no-cache, must-revalidate');
$response->addHeader('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
$response->addHeader('Content-type: application/json');
echo JO_Json::encode($json);
}
public function action_del_order()
{
$order_id = \Input::get('order_id');
$model = \Model_Orders::find_by_pk($order_id);
if (!$model) {
\Response::redirect('job/orders?lost=true');
}
$result = 'error';
$message = '削除に失敗しました。';
if ($model->delete()) {
$result = 'success';
$message = '削除しました。';
}
\Session::set_flash($result, $message);
$return_url_search = \Cookie::get('return_url_search');
if ($return_url_search) {
return \Fuel\Core\Response::redirect($return_url_search);
}
return \Response::redirect('job/orders');
}
public function commentsAction()
{
$request = $this->getRequest();
$this->view->currency = WM_Currency::getCurrency();
$itemID = $request->getRequest('comments');
$item = Model_Items::get($itemID);
if (!is_array($item) || $item['status'] == 'deleted' || JO_Session::get('username') && $item['status'] == 'unapproved' && $item['user_id'] != $_SESSION['user']['user_id'] || $item['status'] == 'queue' || $item['status'] == 'extended_buy') {
return $this->forward('error', 'error404');
}
$this->view->item_link = WM_Router::create($request->getBaseUrl() . '?controller=items&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
$faqs_data = Model_Faq::getAll($itemID);
if (JO_Session::get('user_id') == $item['user_id'] || $faqs_data) {
$this->view->faq_link = WM_Router::create($request->getBaseUrl() . '?controller=items&action=faq&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
}
if (JO_Session::get('user_id') == $item['user_id']) {
$this->view->edit_link = WM_Router::create($request->getBaseUrl() . '?controller=items&action=edit&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
$this->view->delete_link = WM_Router::create($request->getBaseUrl() . '?controller=items&action=delete&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
}
$this->view->comment_link = WM_Router::create($request->getBaseUrl() . '?controller=items&action=comments&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
JO_Session::set('redirect', $this->view->comment_link);
if (JO_Session::get('msg_success')) {
$this->view->msg_success = JO_Session::get('msg_success');
JO_Session::clear('msg_success');
}
if (JO_Session::get('msg_error')) {
$this->view->msg_error = JO_Session::get('msg_error');
JO_Session::clear('msg_error');
}
$user = $item['user'] = Model_Users::getUser($item['user_id']);
$this->view->crumbs = array(array('name' => $this->translate('Home'), 'href' => $request->getBaseUrl()), array('name' => $this->translate('Portfolio'), 'href' => WM_Router::create($request->getBaseUrl() . '?controller=users&username='******'username']))), array('name' => $item['name'], 'href' => $this->view->item_link), array('name' => $this->translate('Comments')));
$model_images = new Model_Images();
$filter = '';
if ($request->getRequest('filter')) {
$filter = ' AND items_comments.id = ' . (int) $request->getRequest('filter');
}
$bayers = Model_Orders::getBayers($itemID);
$comments = Model_Comments::getAll(0, 0, "item_id = '" . (int) $itemID . "' AND reply_to = 0" . $filter, true);
$this->view->smiles = Model_Smiles::getSmilesImages();
$this->view->comments = array();
if ($comments) {
$bbcode_parser = new WM_BBCode_Parser();
$bbcode_parser->loadDefaultCodes();
foreach ($comments as $comment) {
if ($comment['avatar']) {
$comment['avatar'] = $model_images->resize($comment['avatar'], JO_Registry::forceGet('user_avatar_width'), JO_Registry::forceGet('user_avatar_height'), true);
} else {
$comment['avatar'] = 'data/themes/images/noavatar.png';
}
$bbcode_parser->parse($comment['comment']);
$comment['comment'] = Model_Comments::replaceEmoticons($bbcode_parser->getAsHtml());
$comment['badges'] = Helper_Author::userBadges(Model_Users::getUser($comment['owner_id']));
$comment['datetime'] = WM_Date::format($comment['datetime'], 'dd M yy', true);
$comment['is_buy'] = $bayers && in_array($comment['user_id'], $bayers);
$comment['userhref'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=index&username='******'username']));
$comment['reporthref'] = WM_Router::create($request->getBaseUrl() . '?controller=items&action=report/' . $comment['id']);
$comment['replyhref'] = WM_Router::create($request->getBaseUrl() . '?controller=items&action=reply&c_id=' . $comment['id']);
foreach ($comment['reply'] as $key => $reply) {
if ($comment['reply'][$key]['avatar']) {
$comment['reply'][$key]['avatar'] = $model_images->resize($comment['reply'][$key]['avatar'], 50, 50, true);
} else {
$comment['reply'][$key]['avatar'] = 'data/themes/images/small_noavatar.png';
}
$bbcode_parser->parse($comment['reply'][$key]['comment']);
$comment['reply'][$key]['comment'] = Model_Comments::replaceEmoticons($bbcode_parser->getAsHtml());
$comment['reply'][$key]['badges'] = Helper_Author::userBadges(Model_Users::getUser($comment['reply'][$key]['owner_id']));
$comment['reply'][$key]['datetime'] = WM_Date::format($reply['datetime'], 'dd M yy', true);
$comment['reply'][$key]['is_buy'] = $bayers && in_array($reply['user_id'], $bayers);
$comment['reply'][$key]['userhref'] = WM_Router::create($request->getBaseUrl() . '?controller=users&action=index&username='******'reply'][$key]['username']));
$comment['reply'][$key]['reporthref'] = WM_Router::create($request->getBaseUrl() . '?controller=items&action=report/' . $comment['reply'][$key]['id']);
}
$this->view->comments[] = $comment;
}
}
$this->view->add_comment_link = WM_Router::create($request->getBaseUrl() . '?controller=items&action=add_comment&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
$this->getLayout()->meta_title = $item['name'];
$this->getLayout()->meta_description = substr(strip_tags(html_entity_decode($item['description'], ENT_QUOTES, 'utf-8')), 0, 255);
$this->view->item = $item;
$this->view->user = $user;
$this->view->children = array();
$this->view->children['rightside'] = 'items/rightside';
$this->view->children['header_part'] = 'layout/header_part';
$this->view->children['footer_part'] = 'layout/footer_part';
}
/**
* @author Thuanth6589 <*****@*****.**>
* delete data
* @param $user_id
* @return bool
*/
public function delete_data($user_id)
{
try {
if (Model_Orders::count('order_id', false, array(array('author_user_id', '=', $user_id))) || Model_Orders::count('order_id', false, array(array('interview_user_id', '=', $user_id))) || Model_Orders::count('order_id', false, array(array('agreement_user_id', '=', $user_id))) || Model_Orders::count('order_id', false, array(array('training_user_id', '=', $user_id)))) {
return false;
}
$user = static::find_by_pk($user_id);
if ($user) {
return $user->delete();
}
} catch (Exception $e) {
return false;
}
}
public function action_index()
{
$all_price = 0;
$model = array('items' => array());
if (isset($_COOKIE["order_id"])) {
$order_id = $_COOKIE["order_id"];
$orders = new Model_Orders();
$order_data = $orders->getOrder($order_id);
// Есть товары
if (isset($order_data['items'])) {
foreach ($order_data['items'] as $item_id => $item) {
$item_arr = array('id' => $item_id, 'name' => $item['name'], 'count' => $item['cnt'], 'price' => number_format($item['price'], 0, '', ' ') . ' руб.');
$item_arr["img"] = "/images3/img/noimg.png";
if (isset($item['photos'])) {
if (count($item['photos'])) {
$item_arr["img"] = $item['photos'][0]['value'];
}
}
array_push($model['items'], $item_arr);
$all_price += $item['price'] * $item['cnt'];
}
$model['visible_items_header'] = 'block';
$model['visible_fixed_panel'] = 'block';
$model['visible_empty_basket'] = 'none';
$model['col_size'] = 'col-sm-9';
$model['all_price'] = number_format($all_price, 0, '', ' ');
// Нет товаров
} else {
$model['visible_items_header'] = 'none';
$model['visible_fixed_panel'] = 'none';
$model['visible_empty_basket'] = 'block';
$model['col_size'] = 'col-sm-12';
}
// Нет активного заказа
} else {
$model['visible_items_header'] = 'none';
$model['visible_fixed_panel'] = 'none';
$model['visible_empty_basket'] = 'block';
$model['col_size'] = 'col-sm-12';
}
// Подключение шаблона
$this->set_template('widgets/w_cartpage.php')->render($model)->body();
}
public function itemFormAction()
{
$this->view->order_info = Model_Orders::get(JO_Session::get('order_id'));
if (!$this->view->order_info) {
return;
}
$this->view->currency = WM_Currency::getCurrency();
if (JO_Registry::forceGet('paypal_sandbox_mode')) {
$this->view->url = 'https://www.sandbox.paypal.com/cgi-bin/webscr';
} else {
$this->view->url = 'https://www.paypal.com/cgi-bin/webscr';
}
$this->view->paypal_email = JO_Registry::forceGet('paypal_email');
$this->view->return = WM_Router::create($this->getRequest()->getBaseUrl() . '?module=' . $this->view->order_info['module'] . '&controller=items&action=success_payment');
$this->view->notify_url = WM_Router::create($this->getRequest()->getBaseUrl() . '?module=' . $this->view->order_info['module'] . '&controller=payments_paypal&action=callback_item');
$this->view->cancel_return = WM_Router::create($this->getRequest()->getBaseUrl() . '?module=' . $this->view->order_info['module'] . '&controller=items&item_id=' . $this->view->order_info['item_id'] . '&name=' . WM_Router::clearName($this->view->order_info['name']));
$this->view->email = JO_Session::get('email');
$this->view->first_name = JO_Session::get('firstname');
$this->view->last_name = JO_Session::get('lastname');
}
public function _where($filter = array())
{
$is_where = DB::select('person.*', DB::expr('person.name as p_name'), 'employment.contact_result', 'employment.review_date', 'employment.classification', 'employment.adoption_result', 'employment.registration_expiration', 'employment.rank', 'employment.register_date', 'employment.contract_date', 'employment.contract_result', 'employment.hire_date', 'employment.work_confirmation', 'employment.employee_code', 'employment.code_registration_date', 'm_ss.ss_name', 'm_partner.branch_name', 'job.job_id', DB::expr('m_group.name as g_name'), 'm_partner.department_id', 'm_user.name', 'sssale.sale_name', 'sssale.sale_type', array('m_group.name', 'm_group_name'), array('sssale2.sale_name', 'job_sale_name'), array('m_ss2.ss_name', 'job_ss_name'))->from('person')->join('job', 'LEFT')->on('job.job_id', '=', 'person.job_id');
$is_where->join('sssale', 'LEFT')->on('person.sssale_id', '=', 'sssale.sssale_id');
$is_where->join('m_ss', 'LEFT')->on('m_ss.ss_id', '=', 'sssale.ss_id');
$is_where->join('m_partner', 'LEFT')->on('m_partner.partner_code', '=', 'm_ss.partner_code');
$is_where->join('m_group', 'LEFT')->on('m_partner.m_group_id', '=', 'm_group.m_group_id');
$is_where->join('employment', 'LEFT')->on('employment.person_id', '=', 'person.person_id');
$is_where->join('m_user', 'LEFT')->on('m_partner.user_id', '=', 'm_user.user_id');
$is_where->join(array('sssale', 'sssale2'), 'LEFT')->on('job.sssale_id', '=', 'sssale2.sssale_id');
$is_where->join(array('m_ss', 'm_ss2'), 'LEFT')->on('sssale2.ss_id', '=', 'm_ss2.ss_id');
$is_where->order_by('person_id', 'desc');
$is_where->group_by('person_id');
if (isset($filter['addr1']) && $filter['addr1'] != '') {
$is_where->and_where('person.addr1', 'like', '%' . $filter['addr1'] . '%');
}
if (isset($filter['addr2']) && $filter['addr2'] != '') {
$arr_addr = array_filter(preg_split('/\\s|\\s+| /', trim($filter['addr2'])));
$is_where->and_where_open();
$is_where->and_where_open();
foreach ($arr_addr as $k => $v) {
$is_where->where(\Fuel\Core\DB::expr('CONCAT(person.addr2, person.addr3)'), 'like', '%' . $v . '%');
}
$is_where->and_where_close();
$is_where->and_where_close();
}
if (isset($filter['status']) && $filter['status'] != '') {
$is_where->where('person.status', '=', $filter['status']);
}
if (isset($filter['email']) && $filter['email'] != '') {
$is_where->and_where_open();
$is_where->where('mail_addr1', 'LIKE', '%' . $filter['email'] . '%')->or_where('mail_addr2', 'LIKE', '%' . $filter['email'] . '%');
$is_where->and_where_close();
}
if (isset($filter['name']) && $filter['name'] != '') {
$is_where->and_where_open();
$is_where->where('person.name', 'LIKE', '%' . $filter['name'] . '%');
$is_where->or_where('person.name_kana', 'LIKE', '%' . $filter['name'] . '%');
$is_where->and_where_close();
}
if (isset($filter['phone']) && $filter['phone'] != '') {
$is_where->and_where_open();
$is_where->where('person.tel', 'LIKE', '%' . $filter['phone'] . '%')->or_where('person.mobile', 'LIKE', '%' . $filter['phone'] . '%');
$is_where->and_where_close();
}
if (isset($filter['group_id']) && $filter['group_id'] != '') {
$is_where->and_where_open();
$is_where->where('m_partner.m_group_id', '=', $filter['group_id']);
$is_where->and_where_close();
}
if (isset($filter['partner_code']) && $filter['partner_code'] != '') {
$is_where->and_where_open();
$is_where->where('m_ss.partner_code', '=', $filter['partner_code']);
$is_where->and_where_close();
}
if (isset($filter['ss_id']) && $filter['ss_id'] != '') {
$is_where->and_where_open();
$is_where->where('sssale.ss_id', '=', $filter['ss_id']);
$is_where->and_where_close();
}
if (isset($filter['ss_name']) && $filter['ss_name'] != '') {
$is_where->and_where_open();
$is_where->where('ss_name', 'LIKE', '%' . $filter['ss_name'] . '%');
$is_where->and_where_close();
}
if (isset($filter['branch_name']) && $filter['branch_name'] != '') {
$is_where->and_where_open();
$is_where->where('branch_name', 'LIKE', '%' . $filter['branch_name'] . '%');
$is_where->and_where_close();
}
if (isset($filter['to_date']) && $filter['to_date'] != '') {
$filter_date = strtotime($filter['to_date']) + 86399;
$date_to = date('Y-m-d H:i:s', $filter_date);
}
if (isset($filter['from_date']) && isset($filter['to_date']) && $filter['from_date'] != '' && $filter['to_date'] == '') {
$is_where->and_where_open();
$is_where->where('application_date', '>=', $filter['from_date']);
$is_where->and_where_close();
}
if (isset($filter['to_date']) && $filter['from_date'] == '' && $filter['to_date'] != '') {
$is_where->and_where_open();
$is_where->and_where('application_date', '<=', $date_to);
$is_where->and_where_close();
}
if (isset($filter['from_date']) && $filter['from_date'] != '' && $filter['to_date'] != '') {
$is_where->and_where_open();
$is_where->where('application_date', '>=', $filter['from_date']);
$is_where->and_where('application_date', '<=', $date_to);
$is_where->and_where_close();
}
if (isset($filter['gender']) && $filter['gender'] != '') {
$is_where->and_where_open();
$is_where->where('gender', 'IN', $filter['gender']);
$is_where->and_where_close();
}
if (isset($filter['age_from']) && $filter['age_from'] != '' && $filter['age_to'] != '' && isset($filter['age_to'])) {
$is_where->and_where_open();
$is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '>=', $filter['age_from']);
$is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '<=', $filter['age_to']);
$is_where->and_where_close();
} elseif (isset($filter['age_from']) && $filter['age_from'] != '' && $filter['age_to'] == '') {
$is_where->and_where_open();
$is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '>=', $filter['age_from']);
$is_where->and_where_close();
} elseif (isset($filter['age_to']) && $filter['age_to'] != '' && $filter['age_from'] == '') {
$is_where->and_where_open();
$is_where->where(DB::expr("DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d'))"), '<=', $filter['age_to']);
$is_where->and_where_close();
}
$datas = array();
for ($i = 1; $i <= 3; $i++) {
$datas['license' . $i] = '';
if (isset($filter['license' . $i])) {
$is_where->and_where_open();
foreach ($filter['license' . $i] as $key => $value) {
$datas['license' . $i] .= ',' . $value;
}
if (isset($datas['license' . $i]) && $datas['license' . $i] != '') {
$x = explode(',', $datas['license' . $i]);
unset($x[0]);
foreach ($x as $key => $value) {
$is_where->or_where(DB::expr('FIND_IN_SET("' . $value . '",license' . $i . ')'));
}
}
$is_where->and_where_close();
}
}
if (isset($filter['review_result']) && $filter['review_result'] != '') {
$is_where->and_where_open();
if (isset($filter['review_result'][0]) && !isset($filter['review_result'][1])) {
$is_where->where('review_result', '=', 1);
} elseif (!isset($filter['review_result'][0]) && isset($filter['review_result'][1])) {
$is_where->where('review_result', '<>', 1);
$is_where->or_where('review_result', 'is', null);
} else {
$is_where->where(DB::expr(1, '=', 1));
}
$is_where->and_where_close();
}
if (isset($filter['rank']) && $filter['rank'] != '') {
$is_where->and_where_open();
$is_where->where('rank', 'IN', $filter['rank']);
$is_where->and_where_close();
}
if (isset($filter['contract_result']) && $filter['contract_result'] != '') {
$is_where->and_where_open();
$is_where->where('contract_result', 'IN', $filter['contract_result']);
$is_where->and_where_close();
}
if (isset($filter['adoption_result']) && $filter['adoption_result'] != '') {
$is_where->and_where_open();
$is_where->where('adoption_result', 'IN', $filter['adoption_result']);
$is_where->and_where_close();
}
if (isset($filter['user_id']) && $filter['user_id'] != '') {
$is_where->and_where_open();
$is_where->where('m_partner.user_id', '=', $filter['user_id']);
$is_where->and_where_close();
}
if (isset($filter['department']) && $filter['department'] != '' && $filter['user_id'] == '') {
$list_user_id = array();
$model_user = new \Model_Muser();
$list_users = $model_user->get_list_user_by_departmentid($filter['department']);
foreach ($list_users as $key => $val) {
$list_user_id[] = $val['user_id'];
}
if (count($list_user_id)) {
$is_where->and_where_open();
$is_where->where('m_partner.user_id', 'in', $list_user_id);
$is_where->and_where_close();
}
}
if (isset($filter['media_name']) && $filter['media_name'] != '') {
$model_m_media = new \Model_Mmedia();
$model_m_post = new \Model_Mpost();
$model_order = new \Model_Orders();
$media_id_list = $model_m_media->get_media_id_list_by_name($filter['media_name']);
if (count($media_id_list) == 0) {
$is_where->and_where_open();
$is_where->where('person.order_id', '=', '-1');
$is_where->and_where_close();
return $is_where;
}
foreach ($media_id_list as $key => $value) {
$media_id_list[$key] = $value['m_media_id'];
}
$post_id_list = $model_m_post->get_list_post_id($media_id_list);
if (count($post_id_list) == 0) {
$is_where->and_where_open();
$is_where->where('person.order_id', '=', '-1');
$is_where->and_where_close();
return $is_where;
}
foreach ($post_id_list as $key => $value) {
$post_id_list[$key] = $value['post_id'];
}
$order_id_list = $model_order->get_order_id_list($post_id_list);
if (count($order_id_list) == 0) {
$is_where->and_where_open();
$is_where->where('person.order_id', '=', '-1');
$is_where->and_where_close();
return $is_where;
}
foreach ($order_id_list as $key => $value) {
$order_id_list[$key] = $value['order_id'];
}
$is_where->and_where_open();
$is_where->where('person.order_id', 'in', $order_id_list);
$is_where->and_where_close();
}
if (isset($filter['job_id']) && !empty($filter['job_id'])) {
$is_where->where('person.job_id', '=', $filter['job_id']);
}
if (isset($filter['order_id']) && $filter['order_id']) {
$is_where->where('person.order_id', '=', $filter['order_id']);
}
if (isset($filter['array_person'])) {
$filter['array_person'] = empty($filter['array_person']) ? array(0) : $filter['array_person'];
$is_where->where('person.person_id', 'in', $filter['array_person']);
}
if (isset($filter['reprinted_via']) && $filter['reprinted_via']) {
$is_where->where('person.reprinted_via', '=', $filter['reprinted_via']);
}
if (isset($filter['sale_type']) && $filter['sale_type']) {
$sql = 'select sssale_id from sssale where sale_type = ' . $filter['sale_type'];
$rs = \Fuel\Core\DB::query($sql)->execute();
$sssale_id = [-1];
foreach ($rs as $item) {
$sssale_id[] = $item['sssale_id'];
}
$is_where->where('person.sssale_id', 'in', $sssale_id);
}
if (isset($filter['limit'])) {
$is_where->limit($filter['limit']);
}
if (isset($filter['offset'])) {
$is_where->offset($filter['offset']);
}
return $is_where;
}
public function action_cart()
{
/* Добавление товара в корзину
$data:
$item_id* - id товара
$item_count* - кол-во товара
$order_id - id заказа
*/
$methods['add_item'] = function ($data) {
PC::debug($data, 'add item data');
$model_orders = new Model_Orders();
$materials = new Model_Material('groups');
// Добавление товара к существующему заказу
if (isset($data['order_id'])) {
PC::debug(1, 1);
$res = $model_orders->addGood(Arr::get($data, 'order_id'), Arr::get($data, 'item_id'), Arr::get($data, 'item_count'));
} else {
PC::debug(2, 1);
$item_count = Arr::get($data, 'item_count');
$res = $model_orders->newOrder(Arr::get($data, 'item_id'), $item_count);
$new_count = $item_count;
}
$material = $materials->getMaterial(Arr::get($data, 'item_id'));
$fields = $materials->getFields2(Arr::get($data, 'item_id'), TRUE);
$catalog = new Model_Category('tree');
$categoryId = $materials->getTreeIdByMid(Arr::get($data, 'item_id'));
$parents = $catalog->getParents($categoryId);
$node = '';
foreach ($parents as $parent) {
if ($parent['level'] > 1 && $parent['url'] != 'glavnaya') {
$node .= $parent['url'] . '/';
}
}
$itemdata = $model_orders->getOrderCount(Arr::get($data, 'order_id'), Arr::get($data, 'item_id'));
$item[Arr::get($data, 'item_id')] = array_merge($material, $fields);
if (isset($new_count)) {
$item[Arr::get($data, 'item_id')]['cnt'] = $new_count;
} else {
$item[Arr::get($data, 'item_id')]['cnt'] = $itemdata['cnt'];
}
$item[Arr::get($data, 'item_id')]['node'] = $node;
return array('order_id' => $res, 'item' => $item);
};
/* Удаление товара из корзины
$data:
$order_id* - id заказа
$item_id* - id товара
$item_count* - кол-во товара
*/
$methods['del_item'] = function ($data) {
$model_orders = new Model_Orders();
extract($data);
// Удаление товара из корзины
$res = $model_orders->deleteItem(Arr::get($data, 'order_id'), Arr::get($data, 'item_id'), Arr::get($data, 'item_count'));
return $res;
};
/* Получение информации о заказе
$data:
$order_id* - id заказа
*/
$mathods['get_order'] = function ($data) {
$model_orders = new Model_Orders();
$order_data = $model_orders->getOrder($data['order_id']);
return $order_data;
};
/* Удаление заказа
$data:
$order_id* - id заказа
*/
$mathods['del_order'] = function ($data) {
PC::debug($data, 'del_order');
$model_orders = new Model_Orders();
$res = $model_orders->deleteOrder($data['order_id']);
return $res;
};
/* Получение информации о заказе
$data:
$order_id* - id заказа
*/
$methods['get_items'] = function ($data) {
$model_orders = new Model_Orders();
//extract($data);
$res = $model_orders->getOrder(Arr::get($data, 'order_id', ''));
return $res;
};
$data = Arr::get($_POST, 'data', '');
if ($data == '') {
$data = Arr::get($_GET, 'data', '');
}
extract(json_decode($data, true));
$res = false;
if (isset($methods[$method])) {
$res = $methods[$method]($data);
PC::debug($res, 'Ajax: "' . $method . '"');
}
exit(json_encode($res));
}
public function action_index()
{
$data = array();
$model_par = new \Model_Mpartner();
$model_ss = new \Model_Mss();
$model_job = new \Model_Job();
$model_or = new \Model_Orders();
$m_user = new Model_Muser();
$m_person = new Model_Person();
$data['m_partner'] = $model_par->count_data(array('status' => 1));
$data['m_ss'] = $model_ss->count_data(array('status' => '0'));
$data['job'] = $model_job->count_data();
$data['or'] = count($model_or->get_all_order_list(null, null, array('unapproved' => '0')));
$data['person_inactive'] = $m_person->count_data(array('status' => '0'));
$this->template->title = 'UOS求人システム';
$this->template->content = View::forge('default/top', $data);
$user_info = \Fuel\Core\Session::get('login_info');
$division = $user_info['division_type'];
$department_id = $user_info['department_id'];
if ($division == 2) {
$data['count_partner'] = $model_par->count_data(array('department_id' => $department_id, 'status' => '1'));
$data['count_ss'] = $model_ss->count_data(array('department_id' => $department_id, 'status' => '0'));
$data['count_job'] = $model_job->count_job_department_id(array('department_id' => $department_id, 'status' => '0'));
$data['count_order'] = count($model_or->get_all_order_list(null, null, array('department_id' => $department_id, 'unapproved' => '0')));
$data['list_user'] = $m_user->get_data(array('department_id' => $department_id, 'order_by_time' => 1));
$data['link_partner'] = \Fuel\Core\Uri::base() . 'master/partners?department_id=' . $department_id . '&status=1';
$data['link_ss'] = \Fuel\Core\Uri::base() . 'master/sslist?department_id=' . $department_id . '&status=0';
$data['link_job'] = \Fuel\Core\Uri::base() . 'job/jobs?department_id=' . $department_id . '&status=0';
$data['link_order'] = \Fuel\Core\Uri::base() . 'job/orders?department_id=' . $department_id . '&unapproved=0&flag=1';
$array_user = array();
foreach ($data['list_user'] as $user) {
$array_user[] = $user->user_id;
}
$list_person = $m_person->get_person_division_2($array_user);
foreach ($list_person as $person) {
foreach ($array_user as $k => $v) {
if ($person['interview_user_id'] == $v || $person['agreement_user_id'] == $v || $person['training_user_id'] == $v || $person['partner_user_id'] == $v) {
if ($person['contact_result'] == 0) {
$data['count'][$v]['contact_result'] = isset($data['count'][$v]['contact_result']) ? $data['count'][$v]['contact_result'] + 1 : 1;
}
if ($person['review_date'] == '') {
$data['count'][$v]['review_date'] = isset($data['count'][$v]['review_date']) ? $data['count'][$v]['review_date'] + 1 : 1;
}
if ($person['review_result'] == 0) {
$data['count'][$v]['review_result'] = isset($data['count'][$v]['review_result']) ? $data['count'][$v]['review_result'] + 1 : 1;
}
if ($person['adoption_result'] == 0) {
$data['count'][$v]['adoption_result'] = isset($data['count'][$v]['adoption_result']) ? $data['count'][$v]['adoption_result'] + 1 : 1;
}
if ($person['contract_date'] == '') {
$data['count'][$v]['contract_date'] = isset($data['count'][$v]['contract_date']) ? $data['count'][$v]['contract_date'] + 1 : 1;
}
if ($person['contract_result'] == 0) {
$data['count'][$v]['contract_result'] = isset($data['count'][$v]['contract_result']) ? $data['count'][$v]['contract_result'] + 1 : 1;
}
if ($person['hire_date'] == '') {
$data['count'][$v]['hire_date'] = isset($data['count'][$v]['hire_date']) ? $data['count'][$v]['hire_date'] + 1 : 1;
}
if ($person['employee_code'] == '') {
$data['count'][$v]['employee_code'] = isset($data['count'][$v]['employee_code']) ? $data['count'][$v]['employee_code'] + 1 : 1;
}
if ($person['work_confirmation'] == 0) {
$data['count'][$v]['work_confirmation'] = isset($data['count'][$v]['work_confirmation']) ? $data['count'][$v]['work_confirmation'] + 1 : 1;
}
}
}
}
$data['pagination'] = \Uospagination::forge('pagination', array('pagination_url' => Uri::base() . '?division=2', 'total_items' => count($data['list_user']), 'per_page' => \Constants::$default_limit_pagination, 'num_links' => \Constants::$default_num_links, 'uri_segment' => 'page', 'show_last' => true));
$this->template->content = View::forge('default/division2', $data);
} elseif ($division == 3) {
$this->division3();
} else {
$this->template->content = View::forge('default/top', $data);
}
}
/**
* @author Bui Dang <*****@*****.**>
* @params: send data edit presenter
*/
public static function edit($step = null, $type = null, $id = null, $id_label = null)
{
$p_partner = new \Model_Mpartner();
$p_mss = new \Model_Mss();
$p_sssale_id = new \Model_Sssale();
if ($order_id = \Fuel\Core\Input::get('order_id') and \Fuel\Core\Uri::current() == \Fuel\Core\Uri::base() . 'job/person') {
$sssale_id_order = Model_Orders::find_by_pk($order_id)->agreement_type;
if (!isset($order_id) or $order_id != 0) {
$ss_id_order = Model_Orders::find_by_pk($order_id)->ss_id;
}
}
switch ($step) {
case 2:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$partner_code = $id;
$label_partner_code = $id_label;
if (isset($id_label)) {
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_partner = \Model_Mpartner::find_by_pk($partner_code)) {
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_id = array('m_group_id' => $group_id, 'partner_code' => $partner_code);
$arr_edit = array('edit_partner' => $arr_edit_partner);
}
return array_merge($arr_id, $arr_edit, $label_arr_id);
break;
case 3:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$label_ss_id = $id_label;
$ss_id = $id;
if (!isset($type) || $type == '') {
return false;
}
if (isset($id_label)) {
$label_partner_code = \Model_Mss::find_by_pk($label_ss_id)->partner_code;
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_ss_id' => $label_ss_id, 'label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_ss = \Model_Mss::find_by_pk($ss_id) and $m_group = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$partner_code = $m_ss->partner_code;
$group_id = $m_group->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_id = array('ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id);
}
return array_merge($label_arr_id, $arr_id, $arr_edit);
break;
case 4:
$label_arr_id = array();
$arr_id = array();
$arr_edit = array();
$sssale_id = $id;
if (!isset($sssale_id) and isset($sssale_id_order) and $sssale_id_order != 0) {
$sssale_id = $sssale_id_order;
}
$label_sssale_id = $id_label;
if (!isset($type) || $type == '') {
return false;
}
if (isset($id_label)) {
$label_ss_id = \Model_Sssale::find_by_pk($label_sssale_id)->ss_id;
$label_partner_code = \Model_Mss::find_by_pk($label_ss_id)->partner_code;
$label_group_id = Model_Mpartner::find_by_pk($label_partner_code)->m_group_id;
$label_arr_id = array('label_sssale_id' => $label_sssale_id, 'label_ss_id' => $label_ss_id, 'label_m_group_id' => $label_group_id, 'label_partner_code' => $label_partner_code);
}
if ($m_ss_sale = \Model_Sssale::find_by_pk($sssale_id) and $m_ss = \Model_Mss::find_by_pk($m_ss_sale->ss_id) and $m_partner = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$ss_id = $m_ss_sale->ss_id;
$partner_code = $m_ss->partner_code;
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_edit_ss_sale = $p_sssale_id->get_sssale_ss($ss_id);
$arr_id = array('sssale_id' => $sssale_id, 'ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id, 'edit_ss_sale' => $arr_edit_ss_sale);
} else {
if (isset($ss_id_order) and $m_ss = \Model_Mss::find_by_pk($ss_id_order) and $m_partner = \Model_Mpartner::find_by_pk($m_ss->partner_code)) {
$ss_id = $ss_id_order;
$partner_code = $m_ss->partner_code;
$group_id = $m_partner->m_group_id;
$arr_edit_partner = $p_partner->get_partner_group($group_id, $type);
$arr_edit_ss_id = $p_mss->get_ss_partner($partner_code);
$arr_edit_ss_sale = $p_sssale_id->get_sssale_ss($ss_id);
$arr_id = array('sssale_id' => $sssale_id, 'ss_id' => $ss_id, 'partner_code' => $partner_code, 'm_group_id' => $group_id);
$arr_edit = array('edit_partner' => $arr_edit_partner, 'edit_ss_id' => $arr_edit_ss_id, 'edit_ss_sale' => $arr_edit_ss_sale);
}
}
return array_merge($label_arr_id, $arr_id, $arr_edit);
break;
default:
return false;
break;
}
}
public function get_division_3()
{
$data = array('sssale_list' => array(), 'person_list' => array(), 'employment_list' => array());
$user_info = \Fuel\Core\Session::get('login_info');
$order_obj = new Model_Orders();
$partner_obj = new Model_Mpartner();
$mss_obj = new Model_Mss();
$person_obj = new Model_Person();
$employment_obj = new Model_Employment();
$sssale_obj = new Model_Sssale();
$list_order_id = array();
$list_sssale_id = array();
$order_list = $order_obj->get_list_oders_login($user_info['user_id']);
/*where 1*/
if (count($order_list)) {
foreach ($order_list as $row) {
$list_order_id[] = $row['order_id'];
}
}
/*where 2*/
$list_partner_code = array();
$list_ss_id = array();
$partner_list = $partner_obj->get_list_partner_login($user_info['user_id']);
if (count($partner_list)) {
foreach ($partner_list as $row) {
$list_partner_code[] = $row['partner_code'];
}
}
if (count($list_partner_code)) {
$mss_list = $mss_obj->get_all_ss_by_list_partner_code($list_partner_code);
$mss_list_id = '';
$sssale_array = array();
if (count($mss_list)) {
foreach ($mss_list as $row) {
$mss_list_id .= $row['ss_id'] . ',';
$ss_array_list[$row['ss_id']] = $row['ss_name'];
}
$sssale_list = $sssale_obj->get_list_sssale('ss_id IN (' . trim($mss_list_id, ',') . ')');
foreach ($sssale_list as $row) {
$list_sssale_id[] = $row['sssale_id'];
}
}
}
$person_list = $person_obj->get_person_division_3($list_sssale_id, $list_order_id);
$list_person_id = array();
if (count($person_list)) {
$list_sssale_id = array();
foreach ($person_list as $row) {
$list_person_id[] = $row['person_id'];
$list_sssale_id[] = (int) $row['sssale_id'];
}
$list_employment = $employment_obj->get_list_data($list_person_id);
$list_sssale_of_person = $sssale_obj->get_list_sssale('sssale_id IN (' . implode(',', $list_sssale_id) . ')');
$list_employment_array = array();
$list_sssale = array();
foreach ($list_employment as $row) {
$list_employment_array[$row['person_id']] = $row;
}
$list_ss_id = array();
$list_sssale_of_ss = array();
foreach ($list_sssale_of_person as $row) {
$list_ss_id[] = (int) $row['ss_id'];
$list_sssale_of_ss[$row['sssale_id']] = (int) $row['ss_id'];
}
$list_ss_of_person = $mss_obj->get_list_ss('ss_id IN (' . implode(',', $list_ss_id) . ')');
$list_ss_name = array();
foreach ($list_ss_of_person as $row) {
$list_ss_name[$row['ss_id']] = $row['ss_name'];
}
$list_person_ss_name = array();
foreach ($list_sssale_of_ss as $sssale_id => $ss_id) {
$list_person_ss_name[$sssale_id] = $list_ss_name[$ss_id];
}
$data['person_list'] = $person_list;
$data['sssale_list'] = $list_person_ss_name;
$data['employment_list'] = $list_employment_array;
}
return $data;
}
public function get_remaining_cost($apply_date, $list_ss, $ss_id, $order = array())
{
//get ss_info
$ss_info = \Model_Mss::find_by_pk($ss_id);
//get list ss by partner_code
$list_ss_primary = array();
if ($ss_info) {
$model_mss = new \Model_Mss();
$partner = \Model_Mpartner::find_by_pk($ss_info->partner_code);
if ($partner) {
$department_id = $partner->department_id;
}
$list_ss_partner_code = $model_mss->get_list_all_ss(array('partner_code' => $ss_info->partner_code));
if ($list_ss_partner_code) {
$list_ss_primary = array_column($list_ss_partner_code, 'ss_id');
}
}
$department_id = isset($partner->department_id) ? $partner->department_id : '';
//get price for order
$cost_of_order = 0;
if ($order) {
$check = true;
if ($order['status'] == 2) {
$check = false;
}
if ($order['status'] == 2 && $order['action'] == 'copy') {
$check = true;
}
if ($check == true) {
$cost_of_order = \Model_Orders::cost_of_order($order, $list_ss_primary, true);
}
}
//get list orders by list_ss_id
$list_orders = \Model_Orders::get_list_order_in_listss($list_ss_primary, $apply_date);
$total_price = 0;
foreach ($list_orders as $key => $value) {
$total_price = $total_price + \Model_Orders::cost_of_order($value, $list_ss_primary, true);
}
//get plan job_cost
$job_cost = \Model_Plan::get_info_by_startdate($apply_date, $department_id);
$remaining_cost = $job_cost - $total_price - $cost_of_order;
return $remaining_cost;
}
