public function getRub($price, $ConvCurrency)
{
if ($this->_glob['_curr'][$ConvCurrency]['RATE'] > 0) {
return round($price * $this->_glob['_curr'][$ConvCurrency]['RATE'], $this->_glob['_precision']);
}
return GetMessages('ERROR_CURRENCY');
}
function GetContent()
{
global $langmessage;
echo '<div id="gpx_content">';
echo GetMessages();
echo $this->contentBuffer;
echo '</div>';
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request, Absent $absentModel, Product $productModel)
{
if (!right('Alerts')) {
abort(404);
}
if (isset($_POST['save'])) {
//pr($_POST);
$currentAbsents = $absentModel->getAbsentsList();
foreach ($_POST['fields'] as $key => $element) {
//если стоит галка Выполенно
if (isset($element['done'])) {
//удаляем дату у товаров
$productModel->deleteAbsent($element['old_absent']);
//удаляем уведомление
$absentModel->deleteAbsent($element['old_absent']);
} else {
//если меняем дату уведомления
if ($element['new_absent'] != $element['old_absent']) {
//меняем дату у товаров
$productModel->changeAbsent($element['old_absent'], $element['new_absent']);
//если уведомление с такой датой уже есть
if ($currentAbsents->search($element['new_absent']) !== false) {
if (!empty($element['note'])) {
//меняем комментарий
$absentModel->updateAbsent($element['new_absent'], array('note' => $element['note']));
}
//удаляем старое уведомление
$absentModel->deleteAbsent($element['old_absent']);
} else {
//просто меняем дату и коммент
$absentModel->updateAbsent($element['old_absent'], array('absent' => $element['new_absent'], 'note' => $element['note']));
}
} else {
//если написан комментарий
if (!empty($element['note'])) {
//меняем комментарий
$absentModel->updateAbsent($element['new_absent'], array('note' => $element['note']));
}
}
}
}
$absents = $productModel->getAbsentsList();
$absentModel->addAbsentsList($absents);
Session::flash('message', GetMessages("SUCCESS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request, Note $noteModel, History $historyModel)
{
if (right('AddNewPublicNote')) {
if (strlen($_POST['notification']) > 0) {
$noteModel->addNote($_POST['notification']);
$historyModel->saveHistory('create_note');
Session::flash('message', GetMessages("ADD_NEW_NOTE_MESSAGE"));
return redirect()->route('note.index');
} else {
Session::flash('message', GetMessages("EMPTY_NOTE_MESSAGE"));
return redirect()->route('note.index');
}
} else {
Session::flash('message', GetMessages("NO_RIGHTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
/**
* Add the messages to the response
*
*/
static function Messages()
{
ob_start();
echo GetMessages(false);
$content = ob_get_clean();
if (!empty($content)) {
gpAjax::JsonDo('messages', '', $content);
}
}
function GetMessageArray($vm_folder, $vm_mailbox)
{
// Get all messages in a folder
// also convert the messages to MP3 during the loop
global $g_debug;
global $g_voicemail_context_path;
$arr = array();
// Get the paths set up
$voicemail_path = $g_voicemail_context_path . $vm_mailbox . "/" . $vm_folder . "/";
// Open the voicemail directory and look for files
if (is_dir($voicemail_path)) {
$dir = dir($voicemail_path);
// **********************************************************************
// Load the files for this directory, then sort (by Date)
// **********************************************************************
// Get an array of files and unix timestamp
$arr_vm_files = GetMessages($voicemail_path);
// Sort that array by the timestamp
SortByDate($arr_vm_files);
// Get the size of the array of files
$array_size = sizeof($arr_vm_files);
// If there are no files, show a message, otherwise show the header
if ($array_size > 0) {
// Loop through the array
for ($i = $array_size - 1; $i >= 0; $i--) {
// Get the file name
$file = $arr_vm_files[$i][0];
$loopcount = 0;
if ($file != "." && $file != "..") {
// We're looking for the txt files as the proof that there is a voicemail here.
// Then we work from there...
if (strpos($file, ".txt") != FALSE) {
// We got a .txt file (which is like our INI file)
// Read INI File
$ini_array = parse_ini_file($voicemail_path . $file, false);
// Strip extension from file name
$file_noext = substr($file, 0, strpos($file, ".txt"));
// Add .wav and .mp3 on to file name
$file_wav = $file_noext . ".wav";
$file_mp3 = $file_noext . ".mp3";
// Return a better date
$origdate = str_replace(" ", " ", $ini_array['origdate']);
list($day, $month, $date, $time, $ampm, $tz, $year) = split(' ', $origdate);
$origdate_unix = strtotime("{$month} {$date} {$year} {$time} {$ampm}");
//$datetimebetter = date("D M j Y, g:i a", $origdate_unix); Sun Feb 02 2008
$datetimebetter = date("M j Y, g:i a", $origdate_unix);
$arr[$i] = array('file' => $file_noext, 'calleridname' => CallerIdGetName($ini_array['callerid']), 'calleridnumber' => CallerIdGetNumber($ini_array['callerid']), 'datetime' => $ini_array['origdate'], 'datetimebetter' => $datetimebetter, 'duration' => $ini_array['duration']);
// **********************************************************************
// See if there is a MP3 file. If not, create one.
// **********************************************************************
if (!file_exists($voicemail_path . $file_noext . ".mp3")) {
// Create a standard wav file
//$cmd = "sox ".$voicemail_path.$file_noext.".WAV -r 8000 -c 1 -s ".$voicemail_path.$file_noext.".wav";
//echo($cmd . "<br />\n");
//exec($cmd);
// Create a mp3 file from the wav file
$cmd = "lame --resample 11.025 " . $voicemail_path . $file_noext . ".wav " . $voicemail_path . $file_noext . ".mp3";
//echo($cmd . "<br />\n");
exec($cmd);
// Delete the wav file
//$cmd = "unlink ".$voicemail_path.$file_noext.".wav";
//echo($cmd . "<br />\n");
//exec($cmd);
// Touch the mp3 file to set the timestamp to match the .wav file.
// This is so the auto cleanup script will work.
// To set the date to 7:30 am 1st October 2015
// TOUCH /t 2015 10 01 07 30 00 MyFile.txt
$origdate = $ini_array['origdate'];
// Fix a bug in the asterisk date. It puts an extra space in
$origdate = str_replace(" ", " ", $origdate);
list($day, $month, $date, $time, $ampm, $tz, $year) = split(' ', $origdate);
$monthnumber = MonthToMonthNumber($month);
if (strlen($date) == 1) {
$date = "0" . $date;
}
// Pad a 0 to the beginning of date
list($hour, $minute, $second) = split(":", $time);
if ($ampm == "PM") {
$hour = $hour + 12;
}
// Compensate for PM
$touchcmd = "touch -t " . $year . $monthnumber . $date . $hour . $minute . " " . $voicemail_path . $file_noext . ".mp3";
exec($touchcmd);
}
}
$loopcount++;
}
// end if . or ..
}
// end while
$dir->close();
}
}
return $arr;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Label $labelModel, Request $request, Purchase $purchaseModel, User $userModel, Product $productModel, History $historyModel)
{
if (isset($_POST['update_template'])) {
//pr($_POST);
if (isset($_POST['col']) and !empty($_POST['col'])) {
$fields = serialize($_POST['col']);
} else {
$fields = null;
}
if (!empty($_POST['name_template'])) {
$template_name = $_POST['name_template'];
} elseif (isset($_POST['selected_name_template']) and !empty($_POST['selected_name_template'])) {
$template_name = $_POST['selected_name_template'];
} else {
$template_name = 'По умолчанию';
}
$template_id = $userModel->checkTemplates($template_name, 'products');
if ($template_id != null) {
$res = array('fields' => $fields);
$userModel->updateTemplate($res, $template_id, 'products');
} else {
//добавляем шаблон
$res = array('type' => 'products', 'user_id' => Auth::User()->id, 'template' => $template_name, 'fields' => $fields);
$userModel->addTemplates($res, 'products');
}
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['delete_template'])) {
$userModel->deleteTemplate($_POST['selected_name_template'], 'products');
Session::flash('message', GetMessages("SUCCESS_TEMPLATE_DELETE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['select_template'])) {
$userModel->updateUser(Auth::User()->id, array('template_prod_id' => $_POST['selected_name_template']));
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['search_button'])) {
//pr($_POST);
if (strlen($_POST['search_field']) > 0) {
return redirect()->route('product.search.index', ['string' => $_POST['search_field']]);
} else {
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_products'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['update_products']);
unset($_POST['_token']);
$res = array();
$reViewAbsents = false;
//pr($_POST);
foreach ($_POST as $element) {
if (array_key_exists('check', $element)) {
unset($element['check']);
$childs = false;
if (isset($element['childs'])) {
$childs = unserialize($productModel->where('id', $element['id'])->pluck('childs'));
}
//status
!isset($element['status']['new']) ? $element['status']['new'] = 0 : ($element['status']['new'] = 1);
if ($element['status']['new'] != $element['status']['old']) {
$res[$element['id']]['products.status'] = $element['status']['new'];
}
//name
if ($element['name']['new'] != $element['name']['old']) {
$res[$element['id']]['products.name'] = trim($element['name']['new']);
}
//monitoring_name
if ($element['monitoring_name']['new'] != $element['monitoring_name']['old']) {
$res[$element['id']]['products.monitoring_name'] = trim($element['monitoring_name']['new']);
}
//absent
if ($element['absent']['new'] != $element['absent']['old']) {
if (empty($element['absent']['new'])) {
$res[$element['id']]['products.absent'] = null;
} else {
$res[$element['id']]['products.absent'] = trim($element['absent']['new']);
}
$reViewAbsents = true;
}
//article
if ($element['article']['new'] != $element['article']['old']) {
$res[$element['id']]['products.article'] = trim($element['article']['new']);
}
//in_stock
!isset($element['in_stock']['new']) ? $element['in_stock']['new'] = 0 : ($element['in_stock']['new'] = 1);
if ($element['in_stock']['new'] != $element['in_stock']['old']) {
$res[$element['id']]['products.in_stock'] = $element['in_stock']['new'];
}
//flag
!isset($element['flag']['new']) ? $element['flag']['new'] = 0 : ($element['flag']['new'] = 1);
if ($element['flag']['new'] != $element['flag']['old']) {
$res[$element['id']]['products.flag'] = $element['flag']['new'];
}
//sort
if ($element['sort']['new'] != $element['sort']['old']) {
$res[$element['id']]['products.sort'] = $element['sort']['new'];
}
//mrc
if ($element['mrc']['new'] != $element['mrc']['old']) {
$res[$element['id']]['products.mrc'] = toFloat($element['mrc']['new']);
}
//mrc_currency
if ($element['mrc_currency']['new'] != $element['mrc_currency']['old']) {
$res[$element['id']]['products.mrc_currency'] = $element['mrc_currency']['new'];
}
//mrc_relation
if ($element['mrc_relation']['new'] != $element['mrc_relation']['old']) {
$res[$element['id']]['products.mrc_relation'] = trim($element['mrc_relation']['new']);
}
//mrc_raise_relation
if ($element['mrc_raise_relation']['new'] != $element['mrc_raise_relation']['old']) {
$res[$element['id']]['products.mrc_raise_relation'] = trim($element['mrc_raise_relation']['new']);
}
//price
if ($element['price']['new'] != $element['price']['old']) {
$res[$element['id']]['products.price'] = toFloat($element['price']['new']);
}
//price_currency
if ($element['price_currency']['new'] != $element['price_currency']['old']) {
$res[$element['id']]['products.price_currency'] = $element['price_currency']['new'];
}
//price_relation
if ($element['price_relation']['new'] != $element['price_relation']['old']) {
$res[$element['id']]['products.price_relation'] = trim($element['price_relation']['new']);
}
//price_raise_relation
if ($element['price_raise_relation']['new'] != $element['price_raise_relation']['old']) {
$res[$element['id']]['products.price_raise_relation'] = trim($element['price_raise_relation']['new']);
}
//target_margin
isset($element['target_margin']['new']) ? $element['target_margin']['new'] = toFloat($element['target_margin']['new']) : ($element['target_margin']['new'] = 0);
if ($element['target_margin']['new'] != $element['target_margin']['old']) {
$res[$element['id']]['products.target_margin'] = $element['target_margin']['new'];
}
//common_price
isset($element['common_price']['new']) ? $element['common_price']['new'] = toFloat($element['common_price']['new']) : ($element['common_price']['new'] = 0);
if ($element['common_price']['new'] != $element['common_price']['old']) {
$res[$element['id']]['products.common_price'] = $element['common_price']['new'];
}
if (isset($element['GK_enabled']['old'])) {
//GK_enabled
!isset($element['GK_enabled']['new']) ? $element['GK_enabled']['new'] = 0 : ($element['GK_enabled']['new'] = 1);
if ($element['GK_enabled']['new'] != $element['GK_enabled']['old']) {
$res[$element['id']]['GK.enabled'] = $element['GK_enabled']['new'];
}
//GK_yandex_enabled
!isset($element['GK_yandex_enabled']['new']) ? $element['GK_yandex_enabled']['new'] = 0 : ($element['GK_yandex_enabled']['new'] = 1);
if ($element['GK_yandex_enabled']['new'] != $element['GK_yandex_enabled']['old']) {
$res[$element['id']]['GK.yandex_enabled'] = $element['GK_yandex_enabled']['new'];
}
//GK_price
if ($element['GK_price']['new'] != $element['GK_price']['old']) {
$res[$element['id']]['GK.price'] = toFloat($element['GK_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['GK.price'] = $res[$element['id']]['GK.price'] * $child['multiplicator'];
$res[$child['product_id']]['GK.to_export'] = 1;
}
}
}
//GK_price_currency
if ($element['GK_price_currency']['new'] != $element['GK_price_currency']['old']) {
$res[$element['id']]['GK.currency'] = $element['GK_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['GK.currency'] = $res[$element['id']]['GK.currency'];
$res[$child['product_id']]['GK.to_export'] = 1;
}
}
}
//GK update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['GK.enabled']) or isset($res[$element['id']]['GK.yandex_enabled']) or isset($res[$element['id']]['GK.price']) or isset($res[$element['id']]['GK.currency'])) {
$res[$element['id']]['GK.to_export'] = 1;
$res[$element['id']]['GK.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['GK.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
if (isset($element['TV_enabled']['old'])) {
//TV_enabled
!isset($element['TV_enabled']['new']) ? $element['TV_enabled']['new'] = 0 : ($element['TV_enabled']['new'] = 1);
if ($element['TV_enabled']['new'] != $element['TV_enabled']['old']) {
$res[$element['id']]['TV.enabled'] = $element['TV_enabled']['new'];
}
//TV_yandex_enabled
!isset($element['TV_yandex_enabled']['new']) ? $element['TV_yandex_enabled']['new'] = 0 : ($element['TV_yandex_enabled']['new'] = 1);
if ($element['TV_yandex_enabled']['new'] != $element['TV_yandex_enabled']['old']) {
$res[$element['id']]['TV.yandex_enabled'] = $element['TV_yandex_enabled']['new'];
}
//TV_price
if ($element['TV_price']['new'] != $element['TV_price']['old']) {
$res[$element['id']]['TV.price'] = toFloat($element['TV_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['TV.price'] = $res[$element['id']]['TV.price'] * $child['multiplicator'];
$res[$child['product_id']]['TV.to_export'] = 1;
}
}
}
//TV_price_currency
if ($element['TV_price_currency']['new'] != $element['TV_price_currency']['old']) {
$res[$element['id']]['TV.currency'] = $element['TV_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['TV.currency'] = $res[$element['id']]['TV.currency'];
$res[$child['product_id']]['TV.to_export'] = 1;
}
}
}
//TV update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['TV.enabled']) or isset($res[$element['id']]['TV.yandex_enabled']) or isset($res[$element['id']]['TV.price']) or isset($res[$element['id']]['TV.currency'])) {
$res[$element['id']]['TV.to_export'] = 1;
$res[$element['id']]['TV.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['TV.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
if (isset($element['MK_enabled']['old'])) {
//MK_enabled
!isset($element['MK_enabled']['new']) ? $element['MK_enabled']['new'] = 0 : ($element['MK_enabled']['new'] = 1);
if ($element['MK_enabled']['new'] != $element['MK_enabled']['old']) {
$res[$element['id']]['MK.enabled'] = $element['MK_enabled']['new'];
}
//MK_yandex_enabled
!isset($element['MK_yandex_enabled']['new']) ? $element['MK_yandex_enabled']['new'] = 0 : ($element['MK_yandex_enabled']['new'] = 1);
if ($element['MK_yandex_enabled']['new'] != $element['MK_yandex_enabled']['old']) {
$res[$element['id']]['MK.yandex_enabled'] = $element['MK_yandex_enabled']['new'];
}
//MK_price
if ($element['MK_price']['new'] != $element['MK_price']['old']) {
$res[$element['id']]['MK.price'] = toFloat($element['MK_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['MK.price'] = $res[$element['id']]['MK.price'] * $child['multiplicator'];
$res[$child['product_id']]['MK.to_export'] = 1;
}
}
}
//MK_price_currency
if ($element['MK_price_currency']['new'] != $element['MK_price_currency']['old']) {
$res[$element['id']]['MK.currency'] = $element['MK_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['MK.currency'] = $res[$element['id']]['MK.currency'];
$res[$child['product_id']]['MK.to_export'] = 1;
}
}
}
//MK update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['MK.enabled']) or isset($res[$element['id']]['MK.yandex_enabled']) or isset($res[$element['id']]['MK.price']) or isset($res[$element['id']]['MK.currency'])) {
$res[$element['id']]['MK.to_export'] = 1;
$res[$element['id']]['MK.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['MK.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
//product update
if (isset($res[$element['id']]['products.status']) or isset($res[$element['id']]['products.name']) or isset($res[$element['id']]['products.article']) or isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['products.mrc']) or isset($res[$element['id']]['products.mrc_currency']) or isset($res[$element['id']]['products.mrc_relation']) or isset($res[$element['id']]['products.mrc_raise_relation']) or isset($res[$element['id']]['products.price']) or isset($res[$element['id']]['products.price_currency']) or isset($res[$element['id']]['products.price_relation']) or isset($res[$element['id']]['products.price_raise_relation']) or isset($res[$element['id']]['products.target_margin']) or isset($res[$element['id']]['products.common_price'])) {
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
}
if (count($res) > 0) {
$productModel->updatingListProducts($res);
$historyModel->saveHistory('update_products', $res);
if ($reViewAbsents) {
$absentModel = new Absent();
$absents = $productModel->getAbsentsList();
$absentModel->addAbsentsList($absents);
}
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_product'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
$res = array();
//status
!isset($_POST['status']['new']) ? $_POST['status']['new'] = 0 : ($_POST['status']['new'] = 1);
if ($_POST['status']['new'] != $_POST['status']['old']) {
$res[$_POST['id']]['products.status'] = $_POST['status']['new'];
}
//name
if ($_POST['name']['new'] != $_POST['name']['old']) {
$res[$_POST['id']]['products.name'] = trim($_POST['name']['new']);
}
//article
if ($_POST['article']['new'] != $_POST['article']['old']) {
$res[$_POST['id']]['products.article'] = trim($_POST['article']['new']);
}
//ean
if ($_POST['ean']['new'] != $_POST['ean']['old']) {
$res[$_POST['id']]['products.ean'] = trim($_POST['ean']['new']);
}
//in_stock
!isset($_POST['in_stock']['new']) ? $_POST['in_stock']['new'] = 0 : ($_POST['in_stock']['new'] = 1);
if ($_POST['in_stock']['new'] != $_POST['in_stock']['old']) {
$res[$_POST['id']]['products.in_stock'] = $_POST['in_stock']['new'];
}
//mrc
isset($_POST['mrc']['new']) ? $_POST['mrc']['new'] = toFloat($_POST['mrc']['new']) : ($_POST['mrc']['new'] = 0);
if ($_POST['mrc']['new'] != $_POST['mrc']['old']) {
$res[$_POST['id']]['products.mrc'] = toFloat($_POST['mrc']['new']);
}
//price
isset($_POST['price']['new']) ? $_POST['price']['new'] = toFloat($_POST['price']['new']) : ($_POST['price']['new'] = 0);
if ($_POST['price']['new'] != $_POST['price']['old']) {
$res[$_POST['id']]['products.price'] = toFloat($_POST['price']['new']);
}
//target_margin
if ($_POST['target_margin']['new'] != $_POST['target_margin']['old']) {
$res[$_POST['id']]['products.target_margin'] = toFloat($_POST['target_margin']['new']);
}
//category_id
if ($_POST['category_id']['new'] != $_POST['category_id']['old']) {
$res[$_POST['id']]['products.category_id'] = intval($_POST['category_id']['new']);
}
//brand_id
if ($_POST['brand_id']['new'] != $_POST['brand_id']['old']) {
$res[$_POST['id']]['products.brand_id'] = intval($_POST['brand_id']['new']);
}
//childs
if (isset($_POST['childs']) and !empty($_POST['childs'])) {
foreach ($_POST['childs'] as $key => $child) {
if (empty($child['product_id']) or empty($child['multiplicator'])) {
unset($_POST['childs'][$key]);
}
}
if (!empty($_POST['childs'])) {
$res[$_POST['id']]['products.childs'] = serialize($_POST['childs']);
} else {
$res[$_POST['id']]['products.childs'] = null;
}
}
if (isset($_POST['GK_enabled']['old'])) {
//GK_id
isset($_POST['GK_id']['new']) ? $_POST['GK_id']['new'] = intval($_POST['GK_id']['new']) : ($_POST['GK_id']['new'] = 0);
if ($_POST['GK_id']['new'] != $_POST['GK_id']['old']) {
if ($_POST['GK_id']['new'] !== 0 and $_POST['GK_id']['new'] !== 1) {
if (count($productModel->checkSiteId('GK', $_POST['GK_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['GK.site_id'] = $_POST['GK_id']['new'];
}
//GK_enabled
!isset($_POST['GK_enabled']['new']) ? $_POST['GK_enabled']['new'] = 0 : ($_POST['GK_enabled']['new'] = 1);
if ($_POST['GK_enabled']['new'] != $_POST['GK_enabled']['old']) {
$res[$_POST['id']]['GK.enabled'] = $_POST['GK_enabled']['new'];
}
//GK_yandex_enabled
!isset($_POST['GK_yandex_enabled']['new']) ? $_POST['GK_yandex_enabled']['new'] = 0 : ($_POST['GK_yandex_enabled']['new'] = 1);
if ($_POST['GK_yandex_enabled']['new'] != $_POST['GK_yandex_enabled']['old']) {
$res[$_POST['id']]['GK.yandex_enabled'] = $_POST['GK_yandex_enabled']['new'];
}
//GK_price
isset($_POST['GK_price']['new']) ? $_POST['GK_price']['new'] = toFloat($_POST['GK_price']['new']) : ($_POST['GK_price']['new'] = 0);
if ($_POST['GK_price']['new'] != $_POST['GK_price']['old']) {
$res[$_POST['id']]['GK.price'] = $_POST['GK_price']['new'];
}
//GK_price_currency
if ($_POST['GK_price_currency']['new'] != $_POST['GK_price_currency']['old']) {
$res[$_POST['id']]['GK.currency'] = $_POST['GK_price_currency']['new'];
}
//GK update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['GK.enabled']) or isset($res[$_POST['id']]['GK.yandex_enabled']) or isset($res[$_POST['id']]['GK.price']) or isset($res[$_POST['id']]['GK.currency'])) {
$res[$_POST['id']]['GK.to_export'] = 1;
$res[$_POST['id']]['GK.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['GK.user_id'] = Auth::User()->id;
}
}
if (isset($_POST['TV_enabled']['old'])) {
//TV_id
isset($_POST['TV_id']['new']) ? $_POST['TV_id']['new'] = intval($_POST['TV_id']['new']) : ($_POST['TV_id']['new'] = 0);
if ($_POST['TV_id']['new'] != $_POST['TV_id']['old']) {
if ($_POST['TV_id']['new'] !== 0 and $_POST['TV_id']['new'] !== 1) {
if (count($productModel->checkSiteId('TV', $_POST['TV_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['TV.site_id'] = $_POST['TV_id']['new'];
}
//TV_enabled
!isset($_POST['TV_enabled']['new']) ? $_POST['TV_enabled']['new'] = 0 : ($_POST['TV_enabled']['new'] = 1);
if ($_POST['TV_enabled']['new'] != $_POST['TV_enabled']['old']) {
$res[$_POST['id']]['TV.enabled'] = $_POST['TV_enabled']['new'];
}
//TV_yandex_enabled
!isset($_POST['TV_yandex_enabled']['new']) ? $_POST['TV_yandex_enabled']['new'] = 0 : ($_POST['TV_yandex_enabled']['new'] = 1);
if ($_POST['TV_yandex_enabled']['new'] != $_POST['TV_yandex_enabled']['old']) {
$res[$_POST['id']]['TV.yandex_enabled'] = $_POST['TV_yandex_enabled']['new'];
}
//TV_price
isset($_POST['TV_price']['new']) ? $_POST['TV_price']['new'] = toFloat($_POST['TV_price']['new']) : ($_POST['TV_price']['new'] = 0);
if ($_POST['TV_price']['new'] != $_POST['TV_price']['old']) {
$res[$_POST['id']]['TV.price'] = $_POST['TV_price']['new'];
}
//TV_price_currency
if ($_POST['TV_price_currency']['new'] != $_POST['TV_price_currency']['old']) {
$res[$_POST['id']]['TV.currency'] = $_POST['TV_price_currency']['new'];
}
//TV update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['TV.enabled']) or isset($res[$_POST['id']]['TV.yandex_enabled']) or isset($res[$_POST['id']]['TV.price']) or isset($res[$_POST['id']]['TV.currency'])) {
$res[$_POST['id']]['TV.to_export'] = 1;
$res[$_POST['id']]['TV.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['TV.user_id'] = Auth::User()->id;
}
}
if (isset($_POST['MK_enabled']['old'])) {
//MK_id
isset($_POST['MK_id']['new']) ? $_POST['MK_id']['new'] = intval($_POST['MK_id']['new']) : ($_POST['MK_id']['new'] = 0);
if ($_POST['MK_id']['new'] != $_POST['MK_id']['old']) {
if ($_POST['MK_id']['new'] !== 0 and $_POST['MK_id']['new'] !== 1) {
if (count($productModel->checkSiteId('MK', $_POST['MK_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['MK.site_id'] = $_POST['MK_id']['new'];
}
//MK_enabled
!isset($_POST['MK_enabled']['new']) ? $_POST['MK_enabled']['new'] = 0 : ($_POST['MK_enabled']['new'] = 1);
if ($_POST['MK_enabled']['new'] != $_POST['MK_enabled']['old']) {
$res[$_POST['id']]['MK.enabled'] = $_POST['MK_enabled']['new'];
}
//MK_yandex_enabled
!isset($_POST['MK_yandex_enabled']['new']) ? $_POST['MK_yandex_enabled']['new'] = 0 : ($_POST['MK_yandex_enabled']['new'] = 1);
if ($_POST['MK_yandex_enabled']['new'] != $_POST['MK_yandex_enabled']['old']) {
$res[$_POST['id']]['MK.yandex_enabled'] = $_POST['MK_yandex_enabled']['new'];
}
//MK_price
isset($_POST['MK_price']['new']) ? $_POST['MK_price']['new'] = toFloat($_POST['MK_price']['new']) : ($_POST['MK_price']['new'] = 0);
if ($_POST['MK_price']['new'] != $_POST['MK_price']['old']) {
$res[$_POST['id']]['MK.price'] = $_POST['MK_price']['new'];
}
//MK_price_currency
if ($_POST['MK_price_currency']['new'] != $_POST['MK_price_currency']['old']) {
$res[$_POST['id']]['MK.currency'] = $_POST['MK_price_currency']['new'];
}
//MK update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['MK.enabled']) or isset($res[$_POST['id']]['MK.yandex_enabled']) or isset($res[$_POST['id']]['MK.price']) or isset($res[$_POST['id']]['MK.currency'])) {
$res[$_POST['id']]['MK.to_export'] = 1;
$res[$_POST['id']]['MK.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['MK.user_id'] = Auth::User()->id;
}
}
//product update
if (isset($res[$_POST['id']]['products.status']) or isset($res[$_POST['id']]['products.name']) or isset($res[$_POST['id']]['products.article']) or isset($res[$_POST['id']]['products.ean']) or isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['products.mrc']) or isset($res[$_POST['id']]['products.price']) or isset($res[$_POST['id']]['products.target_margin']) or isset($res[$_POST['id']]['products.category_id']) or isset($res[$_POST['id']]['products.brand_id'])) {
$res[$_POST['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['products.user_id'] = Auth::User()->id;
}
if (count($res) > 0 or isset($arLabels)) {
$productModel->updatingListProducts($res);
$historyModel->saveHistory('update_products', $res);
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_labels'])) {
$label = trim($_POST['labels']['new']);
if ($label != $_POST['labels']['old']) {
$labelModel->joinLabels($_POST['product_id'], explode(',', $_POST['labels']['new']));
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['add_to_site'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
if (isset($_POST['GK'])) {
if (!isset($_POST['GK']['product_id']) or strlen($_POST['GK']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['GK']['site_id']) and count($productModel->checkSiteId('GK', $_POST['GK']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['GK']['product_id'];
!empty($_POST['GK']['site_id']) ? $res['site_id'] = intval($_POST['GK']['site_id']) : ($res['site_id'] = 1);
isset($_POST['GK']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['GK']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['GK']['currency']) ? $res['currency'] = $_POST['GK']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['GK']['price']) ? $res['price'] = toFloat($_POST['GK']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'GK');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'ГарантКомфорт');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['TV'])) {
if (!isset($_POST['TV']['product_id']) or strlen($_POST['TV']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['TV']['site_id']) and count($productModel->checkSiteId('TV', $_POST['TV']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['TV']['product_id'];
!empty($_POST['TV']['site_id']) ? $res['site_id'] = intval($_POST['TV']['site_id']) : ($res['site_id'] = 1);
isset($_POST['TV']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['TV']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['TV']['currency']) ? $res['currency'] = $_POST['TV']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['TV']['price']) ? $res['price'] = toFloat($_POST['TV']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'TV');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'Таваго');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['MK'])) {
if (!isset($_POST['MK']['product_id']) or strlen($_POST['MK']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['MK']['site_id']) and count($productModel->checkSiteId('MK', $_POST['MK']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['MK']['product_id'];
!empty($_POST['MK']['site_id']) ? $res['site_id'] = intval($_POST['MK']['site_id']) : ($res['site_id'] = 1);
isset($_POST['MK']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['MK']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['MK']['currency']) ? $res['currency'] = $_POST['MK']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['MK']['price']) ? $res['price'] = toFloat($_POST['MK']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'MK');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'МаксКлимат');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['add_purchase'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
$res = array();
$res['vendor_id'] = $_POST['provider'];
$res['product_id'] = $_POST['product_id'];
$res['currency'] = $_POST['currency'];
!empty($_POST['base_price']) ? $res['base_price'] = toFloat($_POST['base_price']) : ($res['base_price'] = 0);
!empty($_POST['discount_price']) ? $res['discount_price'] = toFloat($_POST['discount_price']) : ($res['discount_price'] = 0);
!empty($_POST['raise']) ? $res['raise'] = toFloat($_POST['raise']) : ($res['raise'] = 0);
!empty($_POST['discount_bulk']) ? $res['discount_bulk'] = toFloat($_POST['discount_bulk']) : ($res['discount_bulk'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$purchaseModel->addPurchase($res);
$historyModel->saveHistory('add_purchase', $res['product_id']);
Session::flash('message', GetMessages("SUCCESS_ADD_PURCHASE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['update_purchase'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['_token']);
unset($_POST['update_purchase']);
//pr($_POST);
$res = array();
foreach ($_POST as $element) {
//base_price
if (isset($element['base_price'])) {
if ($element['base_price']['new'] != $element['base_price']['old']) {
$res[$element['purchase_id']]['base_price'] = $element['base_price']['new'];
}
} else {
$res[$element['purchase_id']]['base_price'] = 0;
}
//currency
if (isset($element['currency'])) {
if ($element['currency']['new'] != $element['currency']['old']) {
$res[$element['purchase_id']]['currency'] = $element['currency']['new'];
}
} else {
$res[$element['purchase_id']]['currency'] = 'RUB';
}
//raise
if (isset($element['raise'])) {
if ($element['raise']['new'] != $element['raise']['old']) {
$res[$element['purchase_id']]['raise'] = $element['raise']['new'];
}
} else {
$res[$element['purchase_id']]['raise'] = 1;
}
//discount_price
if (isset($element['discount_price'])) {
if ($element['discount_price']['new'] != $element['discount_price']['old']) {
$res[$element['purchase_id']]['discount_price'] = $element['discount_price']['new'];
}
} else {
$res[$element['purchase_id']]['discount_price'] = 0;
}
//discount_bulk
if (isset($element['discount_bulk'])) {
if ($element['discount_bulk']['new'] != $element['discount_bulk']['old']) {
$res[$element['purchase_id']]['discount_bulk'] = $element['discount_bulk']['new'];
}
} else {
$res[$element['purchase_id']]['discount_bulk'] = 0;
}
if (isset($res[$element['purchase_id']]['base_price']) or isset($res[$element['purchase_id']]['currency']) or isset($res[$element['purchase_id']]['raise']) or isset($res[$element['purchase_id']]['discount_price']) or isset($res[$element['purchase_id']]['discount_bulk'])) {
$res[$element['purchase_id']]['product_id'] = $element['product_id'];
$res[$element['purchase_id']]['purchase.updated_at'] = date('Y-m-d H:i:s');
$res[$element['purchase_id']]['purchase.user_id'] = Auth::User()->id;
}
}
//pr($res);
if (count($res) > 0) {
$purchaseModel->updatePurchase($res);
$historyModel->saveHistory('update_purchase', $res);
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['create_product'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['_token']);
unset($_POST['create_product']);
//pr($_POST);
if (strlen($request->input('name')) > 0) {
$res = array();
$res['name'] = $request->input('name');
$res['article'] = $request->input('article');
$res['ean'] = $request->input('ean');
$res['status'] = isset($_POST['status']) ? 1 : 0;
$res['category_id'] = $request->input('category_id');
$res['brand_id'] = $request->input('brand_id');
$res['mrc'] = empty($_POST['mrc']) ? 0 : $_POST['mrc'];
$res['mrc_currency'] = empty($_POST['mrc_currency']) ? 'RUB' : $_POST['mrc_currency'];
$res['price'] = empty($_POST['price']) ? 0 : $_POST['price'];
$res['price_currency'] = empty($_POST['price_currency']) ? 'RUB' : $_POST['price_currency'];
$res['target_margin'] = $request->input('target_margin');
$res['in_stock'] = isset($_POST['in_stock']) ? 1 : 0;
$res['user_id'] = Auth::User()->id;
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$id = $productModel->createProduct($res);
$historyModel->saveHistory('create_product', $id);
Session::flash('message', GetMessages("SUCCESS_CREATE_NEW_PRODUCT"));
return redirect()->route('product.show', ['id' => $id]);
} else {
Session::flash('message', GetMessages("ERROR_EMPTY_NAME_PRODUCT"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['ajax'])) {
if (!right('EditProduct')) {
abort(404);
}
return $productModel->checkSiteId($_POST['site'], $_POST['id']);
}
if (isset($_POST['cp_page_sbmt'])) {
$userModel->where('id', Auth::User()->id)->update(array('count_products' => $_POST['cp_page_val']));
Session::flash('message', GetMessages("SUCCESS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
public function flag($category_id, Category $categoryModel, Product $productModel)
{
$childs = $categoryModel->getChild($category_id);
$products = $productModel->getIdByCategoryId($childs);
$productModel->setFlagsByProductsId($products);
Session::flash('message', GetMessages("SUCCESS_ADD_FLAG"));
return redirect($_SERVER['HTTP_REFERER']);
}
/**
* Outputs the sitemap link, admin login/logout link, powered by link, admin html and messages
* @static
*/
static function GetAdminLink()
{
global $config, $langmessage, $page;
if (!isset($config['showsitemap']) || $config['showsitemap']) {
echo ' <span class="sitemap_link">';
echo common::Link('Special_Site_Map', $langmessage['site_map']);
echo '</span>';
}
if (!isset($config['showlogin']) || $config['showlogin']) {
echo ' <span class="login_link">';
if (common::LoggedIn()) {
echo common::Link($page->title, $langmessage['logout'], 'cmd=logout', array('data-cmd' => 'creq', 'rel' => 'nofollow'));
} else {
echo common::Link('Admin', $langmessage['login'], 'file=' . rawurlencode($page->title), ' rel="nofollow" data-cmd="login"');
}
echo '</span>';
}
if (!isset($config['showgplink']) || $config['showgplink']) {
echo ' <span id="powered_by_link">';
echo 'Powered by <a href="http://gpEasy.com" title="A Free and Easy CMS in PHP" target="_blank">gp|Easy CMS</a>';
echo '</span>';
}
gpPlugin::Action('GetAdminLink');
echo GetMessages();
//global $gpLayouts;
//echo pre($gpLayouts);
//$included = get_included_files();
//echo pre($included);
}
public function delete(Purchase $purchaseModel, History $historyModel, $purchase_id, $product_id)
{
$purchaseModel->deletePurchase($purchase_id, $product_id);
$historyModel->saveHistory('del_purchase', $product_id);
Session::flash('message', GetMessages("SUCCESS_DELETE_PURCHASE"));
return redirect($_SERVER['HTTP_REFERER']);
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(History $historyModel, Provider $providerModel, Request $request, $id)
{
if (isset($_POST['update_provider'])) {
if (!right('EditProvider')) {
abort(404);
}
if (strlen($request->input('name')) > 0) {
$data = array('name' => $request->input('name'), 'note' => $request->input('note'), 'updated_at' => date('Y-m-d H:i:s'), 'user_id' => Auth::User()->id);
$providerModel->updateProvider($id, $data);
$historyModel->saveHistory('update_provider', $request->input('name'));
Session::flash('message', GetMessages("SUCCESS_UPDATE_PROVIDER"));
return redirect()->route('provider.index');
} else {
Session::flash('message', GetMessages("ERROR_EMPTY_NAME_PROVIDER"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['status_provider'])) {
if (!right('EditProvider')) {
abort(404);
}
$providerModel->changeStatus($id, $request->input('status'));
$historyModel->saveHistory('status_provider', $id, $request->input('status'));
Session::flash('message', GetMessages("SUCCESS_CHANGE_STATUS_PROVIDER"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
/**
* Outputs the sitemap link, admin login/logout link, powered by link, admin html and messages
* @static
*/
public static function GetAdminLink()
{
global $config, $langmessage, $page;
if (!isset($config['showsitemap']) || $config['showsitemap']) {
echo ' <span class="sitemap_link">';
echo \gp\tool::Link('Special_Site_Map', $langmessage['site_map']);
echo '</span>';
}
if (!isset($config['showlogin']) || $config['showlogin']) {
echo ' <span class="login_link">';
if (\gp\tool::LoggedIn()) {
echo \gp\tool::Link($page->title, $langmessage['logout'], 'cmd=logout', array('data-cmd' => 'creq', 'rel' => 'nofollow'));
} else {
echo \gp\tool::Link('Admin', $langmessage['login'], 'file=' . rawurlencode($page->title), ' rel="nofollow" data-cmd="login"');
}
echo '</span>';
}
if (!isset($config['showgplink']) || $config['showgplink']) {
if (self::is_front_page()) {
echo ' <span id="powered_by_link">';
echo 'Powered by <a href="' . CMS_DOMAIN . '" target="_blank">' . CMS_NAME . '</a>';
echo '</span>';
}
}
\gp\tool\Plugins::Action('GetAdminLink');
echo GetMessages();
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return Response
*/
public function update(Request $request, $id, User $userModel, History $historyModel)
{
if (isset($_POST['edit_user'])) {
if (!right('EditUsers')) {
abort(404);
}
$validator = Validator::make(array('name' => $request->input('name'), 'family' => $request->input('family'), 'password' => $request->input('password')), array('name' => 'required|min:3|max:55', 'family' => 'required|min:3|max:55', 'password' => 'min:4|max:4'), array('required' => 'Поле :attribute обязательно для заполнения', 'min' => 'Поле :attribute должно быть не меньше 4 символов', 'max' => 'Поле :attribute слишком длинное'));
if ($validator->fails()) {
Session::flash('message', GetMessages("ERROR_FIELD_ADD_NEW_USER"));
return redirect()->route('user.create');
} else {
if (isset($_POST['right'])) {
$serialize_rights = serialize($_POST['right']);
} else {
$serialize_rights = null;
}
if (strlen($request->input('password')) == 4) {
$password = Hash::make($request->input('password'));
} else {
$password = $userModel->getPasswordFromUser($id);
}
$showName = $request->input('family') . ' ' . $request->input('name');
$dataUser = array('name' => $request->input('name'), 'family' => $request->input('family'), 'patronymic' => $request->input('patronymic'), 'showname' => $showName, 'position' => $request->input('position'), 'login' => $request->input('login'), 'password' => $password, 'rights' => $serialize_rights, 'updated_at' => date('Y-m-d H:i:s'), 'user_id' => Auth::User()->id);
$userModel->updateUser($id, $dataUser);
$historyModel->saveHistory('update_user', $showName);
Session::flash('message', GetMessages("SUCCESS_USER_UPDATING"));
return redirect()->route('user.edit', ['id' => $id]);
}
}
if (isset($_POST['status_user'])) {
if (!right('EditUsers')) {
abort(404);
}
$status = $request->input('status');
$userModel->updateUser($id, array('status' => $status, 'updated_at' => date('Y-m-d H:i:s'), 'user_id' => Auth::User()->id));
$historyModel->saveHistory('status_user', $id, $status);
Session::flash('message', GetMessages("SUCCESS_CHANGE_STATUS_USER"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
<?php
session_start();
require_once $_SERVER['DOCUMENT_ROOT'] . "/data-layer/dbCommunication.php";
if (isset($_POST['update_chat'])) {
GetMessages();
}
if (isset($_POST['update_leaderboard'])) {
GetLeaderboard();
}
if (isset($_POST['get_games'])) {
GetGames();
}
if (isset($_POST['send_message'])) {
$Message = $_POST["message"];
SendMessage($Message);
}
if (isset($_POST['update_game'])) {
UpdateBoard();
}
if (isset($_POST['create_game'])) {
$GameName = $_POST["game_name"];
$Username = $_SESSION["Username"];
$output = CreateGame($GameName, $Username);
UpdateBoard();
}
if (isset($_POST['game_hit'])) {
$Username = $_SESSION["Username"];
$GameID = $_SESSION["GameID"];
if (IsUserTurn($Username, $GameID)) {
HitPlayer();
public function flag($label_id, Product $productModel)
{
$products = $productModel->getIdByLabelId($label_id);
$productModel->setFlagsByProductsId($products);
Session::flash('message', GetMessages("SUCCESS_ADD_FLAG"));
return redirect($_SERVER['HTTP_REFERER']);
}
/**
* Handle HTTP responses made with $_REQUEST['req'] = json (when <a ... data-cmd="gpajax">)
* Sends JSON object to client
*
*/
static function Response()
{
global $page;
if (!is_array($page->ajaxReplace)) {
die;
}
//gadgets may be using gpajax/json request/responses
gpOutput::TemplateSettings();
gpOutput::PrepGadgetContent();
echo gpAjax::Callback($_REQUEST['jsoncallback']);
echo '([';
//output content
if (!empty($_REQUEST['gpx_content'])) {
switch ($_REQUEST['gpx_content']) {
case 'gpabox':
gpAjax::JsonDo('admin_box_data', '', $page->contentBuffer);
break;
}
} elseif (in_array('#gpx_content', $page->ajaxReplace)) {
$replace_id = '#gpx_content';
if (isset($_GET['gpreqarea'])) {
$replace_id = '#' . $_GET['gpreqarea'];
}
ob_start();
$page->GetGpxContent(true);
$content = ob_get_clean();
gpAjax::JsonDo('replace', $replace_id, $content);
}
//other areas
foreach ($page->ajaxReplace as $arguments) {
if (is_array($arguments)) {
$arguments += array(0 => '', 1 => '', 2 => '');
gpAjax::JsonDo($arguments[0], $arguments[1], $arguments[2]);
}
}
//always send messages
ob_start();
echo GetMessages(false);
$content = ob_get_clean();
if (!empty($content)) {
gpAjax::JsonDo('messages', '', $content);
}
echo ']);';
die;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request, History $historyModel, Cloud $cloudModel, Product $productModel, Purchase $purchaseModel)
{
if (isset($_POST['delete_all_flags'])) {
if (!right('Import')) {
abort(404);
}
$productModel->deleteAllFlags();
Session::flash('message', GetMessages("SUCCESS_DELETE_FLAGS"));
return redirect()->route('cloud.index');
}
if (isset($_POST['delete_all_export_list'])) {
if (!right('Import')) {
abort(404);
}
$productModel->deleteAllExport();
Session::flash('message', GetMessages("SUCCESS_DELETE_FLAGS"));
return redirect()->route('cloud.index');
}
if (isset($_POST['ajax'])) {
if (!right('Import')) {
abort(404);
}
Session::forget('idsNewProducts');
}
if (isset($_POST['export_site'])) {
if (!right('Import')) {
abort(404);
}
//pr($_POST);
if (isset($_POST['field'])) {
$products = $productModel->getProductFromExportToSite();
if (count($products) > 0) {
$res = array();
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'ВП ID');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Производитель');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Наменование');
if (isset($_POST['field']['GK'])) {
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'ID ГК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Цена ГК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Валюта ГК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Активность ГК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Яндекс ГК');
}
if (isset($_POST['field']['TV'])) {
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'ID ТВ');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Цена ТВ');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Валюта ТВ');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Активность ТВ');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Яндекс ТВ');
}
if (isset($_POST['field']['MK'])) {
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'ID МК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Цена МК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Валюта МК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Активность МК');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Яндекс МК');
}
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Наличие');
$i = 1;
foreach ($products as $product) {
$res[$i][] = $product->id;
$res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->brand);
$res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->name);
if (isset($_POST['field']['GK'])) {
if (strpos($product->GK_price, '.')) {
$product->GK_price = str_replace('.', ',', $product->GK_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
if ($product->GK_currency == 'RUB') {
$product->GK_price = intval($product->GK_price);
//округляем, если валюта RUB
}
$res[$i][] = $product->GK_id;
$res[$i][] = $product->GK_price;
$res[$i][] = $product->GK_currency;
$res[$i][] = $product->GK_enabled;
$res[$i][] = $product->GK_yandex_enabled;
}
if (isset($_POST['field']['TV'])) {
if (strpos($product->TV_price, '.')) {
$product->TV_price = str_replace('.', ',', $product->TV_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
if ($product->TV_currency == 'RUB') {
$product->TV_price = intval($product->TV_price);
//округляем, если валюта RUB
}
$res[$i][] = $product->TV_id;
$res[$i][] = $product->TV_price;
$res[$i][] = $product->TV_currency;
$res[$i][] = $product->TV_enabled;
$res[$i][] = $product->TV_yandex_enabled;
}
if (isset($_POST['field']['MK'])) {
if (strpos($product->MK_price, '.')) {
$product->MK_price = str_replace('.', ',', $product->MK_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
if ($product->MK_currency == 'RUB') {
$product->MK_price = intval($product->MK_price);
//округляем, если валюта RUB
}
$res[$i][] = $product->MK_id;
$res[$i][] = $product->MK_price;
$res[$i][] = $product->MK_currency;
$res[$i][] = $product->MK_enabled;
$res[$i][] = $product->MK_yandex_enabled;
}
$res[$i][] = $product->in_stock;
$i++;
}
$this->saveToCSV($res);
Session::flash('message', GetMessages("SUCCESS_EXPORT"));
return redirect()->route('cloud.index');
} else {
return redirect()->route('cloud.index');
}
} else {
return redirect()->route('cloud.index');
}
}
if (isset($_POST['export_prod'])) {
if (!right('Import')) {
abort(404);
}
//pr($_POST);
$fields = array();
$fields[] = 'products.id';
!isset($_POST['field']['prod']['status']) ?: ($fields[] = 'products.status');
!isset($_POST['field']['prod']['name']) ?: ($fields[] = 'products.name');
!isset($_POST['field']['prod']['category']) ?: ($fields[] = 'products.category_id');
!isset($_POST['field']['prod']['category']) ?: ($fields[] = 'PC.name as category_name');
!isset($_POST['field']['prod']['brand']) ?: ($fields[] = 'products.brand_id');
!isset($_POST['field']['prod']['brand']) ?: ($fields[] = 'PB.name as brand_name');
!isset($_POST['field']['prod']['article']) ?: ($fields[] = 'products.article');
!isset($_POST['field']['prod']['ean']) ?: ($fields[] = 'products.ean');
!isset($_POST['field']['prod']['mrc']) ?: ($fields[] = 'products.mrc');
!isset($_POST['field']['prod']['mrc']) ?: ($fields[] = 'products.mrc_currency');
!isset($_POST['field']['prod']['price']) ?: ($fields[] = 'products.price');
!isset($_POST['field']['prod']['price']) ?: ($fields[] = 'products.price_currency');
!isset($_POST['field']['prod']['target_margin']) ?: ($fields[] = 'products.target_margin');
!isset($_POST['field']['prod']['in_stock']) ?: ($fields[] = 'products.in_stock');
!isset($_POST['field']['site']['id']) ?: ($fields[] = 'GK.site_id as GK_id');
!isset($_POST['field']['site']['enabled']) ?: ($fields[] = 'GK.enabled as GK_enabled');
!isset($_POST['field']['site']['yandex_enabled']) ?: ($fields[] = 'GK.yandex_enabled as GK_yandex_enabled');
!isset($_POST['field']['site']['currency']) ?: ($fields[] = 'GK.currency as GK_currency');
!isset($_POST['field']['site']['price']) ?: ($fields[] = 'GK.price as GK_price');
!isset($_POST['field']['site']['id']) ?: ($fields[] = 'TV.site_id as TV_id');
!isset($_POST['field']['site']['enabled']) ?: ($fields[] = 'TV.enabled as TV_enabled');
!isset($_POST['field']['site']['yandex_enabled']) ?: ($fields[] = 'TV.yandex_enabled as TV_yandex_enabled');
!isset($_POST['field']['site']['currency']) ?: ($fields[] = 'TV.currency as TV_currency');
!isset($_POST['field']['site']['price']) ?: ($fields[] = 'TV.price as TV_price');
!isset($_POST['field']['site']['id']) ?: ($fields[] = 'MK.site_id as MK_id');
!isset($_POST['field']['site']['enabled']) ?: ($fields[] = 'MK.enabled as MK_enabled');
!isset($_POST['field']['site']['yandex_enabled']) ?: ($fields[] = 'MK.yandex_enabled as MK_yandex_enabled');
!isset($_POST['field']['site']['currency']) ?: ($fields[] = 'MK.currency as MK_currency');
!isset($_POST['field']['site']['price']) ?: ($fields[] = 'MK.price as MK_price');
$products = $productModel->getProductFromExport($fields);
if (count($products) > 0) {
$res = array();
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP01 Id товара');
!isset($_POST['field']['prod']['status']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP02 Статус'));
!isset($_POST['field']['prod']['name']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP03 Наименование'));
!isset($_POST['field']['prod']['category']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Категория'));
!isset($_POST['field']['prod']['category']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP04 ID категории'));
!isset($_POST['field']['prod']['brand']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Производитель'));
!isset($_POST['field']['prod']['brand']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP05 ID производителя'));
!isset($_POST['field']['prod']['article']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP06 Артикул'));
!isset($_POST['field']['prod']['ean']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP07 Штрих-код'));
!isset($_POST['field']['prod']['mrc']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP08 МРЦ'));
!isset($_POST['field']['prod']['mrc']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP09 МРЦ валюта'));
!isset($_POST['field']['prod']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP10 Прайс'));
!isset($_POST['field']['prod']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP11 Прайс валюта'));
!isset($_POST['field']['prod']['target_margin']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP12 Маржинальность'));
!isset($_POST['field']['prod']['in_stock']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'VP13 Наличие'));
!isset($_POST['field']['site']['id']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'GK01 ID на ГК'));
!isset($_POST['field']['site']['enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'GK02 Статус ГК'));
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'GK03 Маркет ГК'));
!isset($_POST['field']['site']['currency']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'GK04 Валюта ГК'));
!isset($_POST['field']['site']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'GK05 Цена ГК'));
!isset($_POST['field']['site']['id']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'TV01 ID на ТВ'));
!isset($_POST['field']['site']['enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'TV02 Статус ТВ'));
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'TV03 Маркет ТВ'));
!isset($_POST['field']['site']['currency']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'TV04 Валюта ТВ'));
!isset($_POST['field']['site']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'TV05 Цена ТВ'));
!isset($_POST['field']['site']['id']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'MK01 ID на МК'));
!isset($_POST['field']['site']['enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'MK02 Статус МК'));
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'MK03 Маркет МК'));
!isset($_POST['field']['site']['currency']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'MK04 Валюта МК'));
!isset($_POST['field']['site']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'MK05 Цена МК'));
$i = 1;
foreach ($products as $product) {
$res[$i][] = $product->id;
!isset($_POST['field']['prod']['status']) ?: ($res[$i][] = $product->status);
!isset($_POST['field']['prod']['name']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->name));
!isset($_POST['field']['prod']['category']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->category_name));
!isset($_POST['field']['prod']['category']) ?: ($res[$i][] = $product->category_id);
!isset($_POST['field']['prod']['brand']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->brand_name));
!isset($_POST['field']['prod']['brand']) ?: ($res[$i][] = $product->brand_id);
!isset($_POST['field']['prod']['article']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $product->article));
!isset($_POST['field']['prod']['ean']) ?: ($res[$i][] = $product->ean);
if (isset($_POST['field']['prod']['mrc'])) {
if (strpos($product->mrc, '.')) {
$product->mrc = str_replace('.', ',', $product->mrc);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $product->mrc;
}
!isset($_POST['field']['prod']['mrc']) ?: ($res[$i][] = $product->mrc_currency);
if (isset($_POST['field']['prod']['price'])) {
if (strpos($product->price, '.')) {
$product->price = str_replace('.', ',', $product->price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $product->price;
}
!isset($_POST['field']['prod']['price']) ?: ($res[$i][] = $product->price_currency);
!isset($_POST['field']['prod']['target_margin']) ?: ($res[$i][] = $product->target_margin);
!isset($_POST['field']['prod']['in_stock']) ?: ($res[$i][] = $product->in_stock);
!isset($_POST['field']['site']['id']) ?: ($res[$i][] = $product->GK_id);
!isset($_POST['field']['site']['enabled']) ?: ($res[$i][] = $product->GK_enabled);
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[$i][] = $product->GK_yandex_enabled);
!isset($_POST['field']['site']['currency']) ?: ($res[$i][] = $product->GK_currency);
if (isset($_POST['field']['site']['price'])) {
if (strpos($product->GK_price, '.')) {
$product->GK_price = str_replace('.', ',', $product->GK_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $product->GK_price;
}
!isset($_POST['field']['site']['id']) ?: ($res[$i][] = $product->TV_id);
!isset($_POST['field']['site']['enabled']) ?: ($res[$i][] = $product->TV_enabled);
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[$i][] = $product->TV_yandex_enabled);
!isset($_POST['field']['site']['currency']) ?: ($res[$i][] = $product->TV_currency);
if (isset($_POST['field']['site']['price'])) {
if (strpos($product->TV_price, '.')) {
$product->TV_price = str_replace('.', ',', $product->TV_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $product->TV_price;
}
!isset($_POST['field']['site']['id']) ?: ($res[$i][] = $product->MK_id);
!isset($_POST['field']['site']['enabled']) ?: ($res[$i][] = $product->MK_enabled);
!isset($_POST['field']['site']['yandex_enabled']) ?: ($res[$i][] = $product->MK_yandex_enabled);
!isset($_POST['field']['site']['currency']) ?: ($res[$i][] = $product->MK_currency);
if (isset($_POST['field']['site']['price'])) {
if (strpos($product->MK_price, '.')) {
$product->MK_price = str_replace('.', ',', $product->MK_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $product->MK_price;
}
$i++;
}
$this->saveToCSV($res);
Session::flash('message', GetMessages("SUCCESS_EXPORT"));
return redirect()->route('cloud.index');
} else {
return redirect()->route('cloud.index');
}
}
if (isset($_POST['export_purch'])) {
if (!right('Import')) {
abort(404);
}
$fields = array();
$fields[] = 'purchase.id as purchase_id';
$fields[] = 'P.id as product_id';
!isset($_POST['field']['purch']['name']) ?: ($fields[] = 'P.name as product_name');
!isset($_POST['field']['purch']['article']) ?: ($fields[] = 'P.article as article');
!isset($_POST['field']['purch']['price']) ?: ($fields[] = 'P.price as price');
!isset($_POST['field']['purch']['price']) ?: ($fields[] = 'P.price_currency as price_currency');
!isset($_POST['field']['purch']['ean']) ?: ($fields[] = 'P.ean as ean');
!isset($_POST['field']['purch']['category']) ?: ($fields[] = 'PC.name as category');
!isset($_POST['field']['purch']['brand']) ?: ($fields[] = 'PB.name as brand');
!isset($_POST['field']['purch']['provider']) ?: ($fields[] = 'PROV.name as provider');
!isset($_POST['field']['purch']['provider']) ?: ($fields[] = 'PROV.id as provider_id');
!isset($_POST['field']['purch']['base_price']) ?: ($fields[] = 'purchase.base_price');
!isset($_POST['field']['purch']['currency']) ?: ($fields[] = 'purchase.currency');
!isset($_POST['field']['purch']['raise']) ?: ($fields[] = 'purchase.raise');
!isset($_POST['field']['purch']['discount_price']) ?: ($fields[] = 'purchase.discount_price');
!isset($_POST['field']['purch']['discount_bulk']) ?: ($fields[] = 'purchase.discount_bulk');
$purchases = $purchaseModel->getPurchaseFromExport($fields);
if (count($purchases) > 0) {
$res = array();
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU01 Id закупки');
$res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU02 Id товара');
!isset($_POST['field']['purch']['name']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Наименование'));
!isset($_POST['field']['purch']['article']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Артикул'));
!isset($_POST['field']['purch']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Прайс'));
!isset($_POST['field']['purch']['price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Валюта прайса'));
!isset($_POST['field']['purch']['ean']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Штрих-код'));
!isset($_POST['field']['purch']['category']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Категория'));
!isset($_POST['field']['purch']['brand']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Производитель'));
!isset($_POST['field']['purch']['provider']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'Поставщик'));
!isset($_POST['field']['purch']['provider']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU03 ID поставщика'));
!isset($_POST['field']['purch']['base_price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU04 Базовая цена'));
!isset($_POST['field']['purch']['currency']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU05 Валюта'));
!isset($_POST['field']['purch']['raise']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU06 Поправка к ЦБ'));
!isset($_POST['field']['purch']['discount_price']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU07 Скидка'));
!isset($_POST['field']['purch']['discount_bulk']) ?: ($res[0][] = iconv('UTF-8', 'cp1251//TRANSLIT', 'PU08 Доп.скидка'));
$i = 1;
foreach ($purchases as $purchase) {
$res[$i][] = $purchase->purchase_id;
$res[$i][] = $purchase->product_id;
!isset($_POST['field']['purch']['name']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->product_name));
!isset($_POST['field']['purch']['article']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->article));
!isset($_POST['field']['purch']['price']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', str_replace('.', ',', $purchase->price)));
!isset($_POST['field']['purch']['price']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->price_currency));
!isset($_POST['field']['purch']['ean']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->ean));
!isset($_POST['field']['purch']['category']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->category));
!isset($_POST['field']['purch']['brand']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->brand));
!isset($_POST['field']['purch']['provider']) ?: ($res[$i][] = iconv('UTF-8', 'cp1251//TRANSLIT', $purchase->provider));
!isset($_POST['field']['purch']['provider']) ?: ($res[$i][] = $purchase->provider_id);
if (isset($_POST['field']['purch']['base_price'])) {
if (strpos($purchase->base_price, '.')) {
$purchase->base_price = str_replace('.', ',', $purchase->base_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $purchase->base_price;
}
!isset($_POST['field']['purch']['currency']) ?: ($res[$i][] = $purchase->currency);
!isset($_POST['field']['purch']['raise']) ?: ($res[$i][] = $purchase->raise);
if (isset($_POST['field']['purch']['discount_price'])) {
if (strpos($purchase->discount_price, '.')) {
$purchase->discount_price = str_replace('.', ',', $purchase->discount_price);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $purchase->discount_price;
}
if (isset($_POST['field']['purch']['discount_bulk'])) {
if (strpos($purchase->discount_bulk, '.')) {
$purchase->discount_bulk = str_replace('.', ',', $purchase->discount_bulk);
//заменяем точку на запятую, ибо эксель ебанутый((
}
$res[$i][] = $purchase->discount_bulk;
}
$i++;
}
$this->saveToCSV($res);
Session::flash('message', GetMessages("SUCCESS_EXPORT"));
return redirect()->route('cloud.index');
} else {
return redirect()->route('cloud.index');
}
}
if (isset($_POST['import_csv'])) {
if (!right('Import')) {
abort(404);
}
if (isset($request['file_csv'])) {
$file = Input::file('file_csv');
$extension = $file->getClientOriginalExtension();
//получаем расширение
if ($extension == 'csv') {
$filename = $file->getClientOriginalName();
//оригинальное название файла
$real_filename = date("Y_m_d_H_i_s") . '_' . RuslugFacade::make(mb_strtolower($file->getClientOriginalName()));
//преобразованное название файла
$file->move(base_path() . '/public/storage/import/', $real_filename);
//перемещаем файл
$header = NULL;
$data = array();
if (($handle = fopen(base_path() . cloud_path() . '/import/' . $real_filename, "r")) !== FALSE) {
while (($row = fgetcsv($handle, 1000, ';')) !== FALSE) {
if (!$header) {
$header = $row;
} else {
$data[] = array_combine($header, $row);
}
}
fclose($handle);
$res = [];
//pr($data);
$i = 0;
foreach ($data as $row) {
if (array_key_exists(to1251('VP01 Id товара'), $row)) {
//это товар
if (!empty($row[to1251('VP01 Id товара')])) {
//товар уже существует, будем обновлять
!array_key_exists(to1251('VP02 Статус'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.status'] = import_field($row[to1251('VP02 Статус')], 'bool', 1));
!array_key_exists(to1251('VP03 Наименование'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.name'] = import_field(toUTF($row[to1251('VP03 Наименование')]), 'string', ''));
!array_key_exists(to1251('VP04 ID категории'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.category_id'] = import_field($row[to1251('VP04 ID категории')], 'int', 0));
!array_key_exists(to1251('VP05 ID производителя'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.brand_id'] = import_field($row[to1251('VP05 ID производителя')], 'int', 0));
!array_key_exists(to1251('VP06 Артикул'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.article'] = import_field(toUTF($row[to1251('VP06 Артикул')]), 'string', ''));
!array_key_exists(to1251('VP07 Штрих-код'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.ean'] = import_field($row[to1251('VP07 Штрих-код')], 'string', ''));
!array_key_exists(to1251('VP08 МРЦ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.mrc'] = import_field($row[to1251('VP08 МРЦ')], 'float', 0));
!array_key_exists(to1251('VP09 МРЦ валюта'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.mrc_currency'] = import_field($row[to1251('VP09 МРЦ валюта')], 'string', 'RUB'));
!array_key_exists(to1251('VP10 Прайс'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.price'] = import_field($row[to1251('VP10 Прайс')], 'float', 0));
!array_key_exists(to1251('VP11 Прайс валюта'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.price_currency'] = import_field($row[to1251('VP11 Прайс валюта')], 'string', 'RUB'));
!array_key_exists(to1251('VP12 Маржинальность'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.target_margin'] = import_field($row[to1251('VP12 Маржинальность')], 'float', 0));
!array_key_exists(to1251('VP13 Наличие'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.in_stock'] = import_field($row[to1251('VP13 Наличие')], 'bool', 0));
if (isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.status']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.name']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.category_id']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.brand_id']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.article']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.ean']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.min_retail_price']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.rec_retail_price']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.target_margin']) or isset($res['update_prod'][$row[to1251('VP01 Id товара')]]['products.in_stock'])) {
$res['update_prod'][$row[to1251('VP01 Id товара')]]['products.id'] = $row[to1251('VP01 Id товара')];
$res['update_prod'][$row[to1251('VP01 Id товара')]]['products.updated_at'] = date('Y-m-d H:i:s');
$res['update_prod'][$row[to1251('VP01 Id товара')]]['products.user_id'] = Auth::User()->id;
}
if (array_key_exists(to1251('GK01 ID на ГК'), $row)) {
//есть поле Гаранта
if (stristr($row[to1251('GK01 ID на ГК')], 'add')) {
$row[to1251('GK01 ID на ГК')] = str_replace('add', '', $row[to1251('GK01 ID на ГК')]);
//добавляем новый
$productModel->deleteWithSite('GK', $row[to1251('VP01 Id товара')]);
//сперва удаяем все, что связано с этим товаром (если есть)
$res['add_to_GK'][$i]['product_id'] = $row[to1251('VP01 Id товара')];
!array_key_exists(to1251('GK01 ID на ГК'), $row) ? $res['add_to_GK'][$i]['site_id'] = 1 : ($res['add_to_GK'][$i]['site_id'] = import_field($row[to1251('GK01 ID на ГК')], 'int', 1));
!array_key_exists(to1251('GK02 Статус ГК'), $row) ? $res['add_to_GK'][$i]['enabled'] = 1 : ($res['add_to_GK'][$i]['enabled'] = import_field($row[to1251('GK02 Статус ГК')], 'bool', 1));
!array_key_exists(to1251('GK03 Маркет ГК'), $row) ? $res['add_to_GK'][$i]['yandex_enabled'] = 0 : ($res['add_to_GK'][$i]['yandex_enabled'] = import_field($row[to1251('GK03 Маркет ГК')], 'bool', 0));
!array_key_exists(to1251('GK04 Валюта ГК'), $row) ? $res['add_to_GK'][$i]['currency'] = 'RUB' : ($res['add_to_GK'][$i]['currency'] = import_field($row[to1251('GK04 Валюта ГК')], 'string', 'RUB'));
!array_key_exists(to1251('GK05 Цена ГК'), $row) ? $res['add_to_GK'][$i]['price'] = 0 : ($res['add_to_GK'][$i]['price'] = import_field($row[to1251('GK05 Цена ГК')], 'float', 0));
$res['add_to_GK'][$i]['created_at'] = date('Y-m-d H:i:s');
$res['add_to_GK'][$i]['updated_at'] = date('Y-m-d H:i:s');
$res['add_to_GK'][$i]['user_id'] = Auth::User()->id;
} else {
if (count($productModel->checkProductOnSiteId('GK', $row[to1251('VP01 Id товара')])) > 0) {
//убеждаемся, что на этот товар уже привязан
//если товар есть на сайте, будем обновлять
!array_key_exists(to1251('GK01 ID на ГК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.site_id'] = import_field($row[to1251('GK01 ID на ГК')], 'int', 0));
!array_key_exists(to1251('GK02 Статус ГК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.enabled'] = import_field($row[to1251('GK02 Статус ГК')], 'bool', 1));
!array_key_exists(to1251('GK03 Маркет ГК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.yandex_enabled'] = import_field($row[to1251('GK03 Маркет ГК')], 'bool', 0));
!array_key_exists(to1251('GK04 Валюта ГК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.currency'] = import_field($row[to1251('GK04 Валюта ГК')], 'string', 'RUB'));
!array_key_exists(to1251('GK05 Цена ГК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.price'] = import_field($row[to1251('GK05 Цена ГК')], 'float', 0));
$res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.updated_at'] = date('Y-m-d H:i:s');
$res['update_prod'][$row[to1251('VP01 Id товара')]]['GK.user_id'] = Auth::User()->id;
}
}
}
if (array_key_exists(to1251('TV01 ID на ТВ'), $row)) {
//есть поле Таваго
if (stristr($row[to1251('TV01 ID на ТВ')], 'add')) {
$row[to1251('TV01 ID на ТВ')] = str_replace('add', '', $row[to1251('TV01 ID на ТВ')]);
//добавляем новый
$productModel->deleteWithSite('TV', $row[to1251('VP01 Id товара')]);
//сперва удаяем все, что связано с этим товаром (если есть)
$res['add_to_TV'][$i]['product_id'] = $row[to1251('VP01 Id товара')];
!array_key_exists(to1251('TV01 ID на ТВ'), $row) ? $res['add_to_TV'][$i]['site_id'] = 1 : ($res['add_to_TV'][$i]['site_id'] = import_field($row[to1251('TV01 ID на ТВ')], 'int', 1));
!array_key_exists(to1251('TV02 Статус ТВ'), $row) ? $res['add_to_TV'][$i]['enabled'] = 1 : ($res['add_to_TV'][$i]['enabled'] = import_field($row[to1251('TV02 Статус ТВ')], 'bool', 1));
!array_key_exists(to1251('TV03 Маркет ТВ'), $row) ? $res['add_to_TV'][$i]['yandex_enabled'] = 0 : ($res['add_to_TV'][$i]['yandex_enabled'] = import_field($row[to1251('TV03 Маркет ТВ')], 'bool', 0));
!array_key_exists(to1251('TV04 Валюта ТВ'), $row) ? $res['add_to_TV'][$i]['currency'] = 'RUB' : ($res['add_to_TV'][$i]['currency'] = import_field($row[to1251('TV04 Валюта ТВ')], 'string', 'RUB'));
!array_key_exists(to1251('TV05 Цена ТВ'), $row) ? $res['add_to_TV'][$i]['price'] = 0 : ($res['add_to_TV'][$i]['price'] = import_field($row[to1251('TV05 Цена ТВ')], 'float', 0));
$res['add_to_TV'][$i]['created_at'] = date('Y-m-d H:i:s');
$res['add_to_TV'][$i]['updated_at'] = date('Y-m-d H:i:s');
$res['add_to_TV'][$i]['user_id'] = Auth::User()->id;
} else {
if (count($productModel->checkProductOnSiteId('TV', $row[to1251('VP01 Id товара')])) > 0) {
//убеждаемся, что на этот товар уже привязан
//если товар есть на сайте, будем обновлять
!array_key_exists(to1251('TV01 ID на ТВ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.site_id'] = import_field($row[to1251('TV01 ID на ТВ')], 'int', 0));
!array_key_exists(to1251('TV02 Статус ТВ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.enabled'] = import_field($row[to1251('TV02 Статус ТВ')], 'bool', 1));
!array_key_exists(to1251('TV03 Маркет ТВ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.yandex_enabled'] = import_field($row[to1251('TV03 Маркет ТВ')], 'bool', 0));
!array_key_exists(to1251('TV04 Валюта ТВ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.currency'] = import_field($row[to1251('TV04 Валюта ТВ')], 'string', 'RUB'));
!array_key_exists(to1251('TV05 Цена ТВ'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.price'] = import_field($row[to1251('TV05 Цена ТВ')], 'float', 0));
$res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.updated_at'] = date('Y-m-d H:i:s');
$res['update_prod'][$row[to1251('VP01 Id товара')]]['TV.user_id'] = Auth::User()->id;
}
}
}
if (array_key_exists(to1251('MK01 ID на МК'), $row)) {
//есть поле МаксКлимат
if (stristr($row[to1251('MK01 ID на МК')], 'add')) {
$row[to1251('MK01 ID на МК')] = str_replace('add', '', $row[to1251('MK01 ID на МК')]);
//добавляем новый
$productModel->deleteWithSite('MK', $row[to1251('VP01 Id товара')]);
//сперва удаяем все, что связано с этим товаром (если есть)
$res['add_to_MK'][$i]['product_id'] = $row[to1251('VP01 Id товара')];
!array_key_exists(to1251('MK01 ID на МК'), $row) ? $res['add_to_MK'][$i]['site_id'] = 1 : ($res['add_to_MK'][$i]['site_id'] = import_field($row[to1251('MK01 ID на МК')], 'int', 1));
!array_key_exists(to1251('MK02 Статус МК'), $row) ? $res['add_to_MK'][$i]['enabled'] = 1 : ($res['add_to_MK'][$i]['enabled'] = import_field($row[to1251('MK02 Статус МК')], 'bool', 1));
!array_key_exists(to1251('MK03 Маркет МК'), $row) ? $res['add_to_MK'][$i]['yandex_enabled'] = 0 : ($res['add_to_MK'][$i]['yandex_enabled'] = import_field($row[to1251('MK03 Маркет МК')], 'bool', 0));
!array_key_exists(to1251('MK04 Валюта МК'), $row) ? $res['add_to_MK'][$i]['currency'] = 'RUB' : ($res['add_to_MK'][$i]['currency'] = import_field($row[to1251('MK04 Валюта МК')], 'string', 'RUB'));
!array_key_exists(to1251('MK05 Цена МК'), $row) ? $res['add_to_MK'][$i]['price'] = 0 : ($res['add_to_MK'][$i]['price'] = import_field($row[to1251('MK05 Цена МК')], 'float', 0));
$res['add_to_MK'][$i]['created_at'] = date('Y-m-d H:i:s');
$res['add_to_MK'][$i]['updated_at'] = date('Y-m-d H:i:s');
$res['add_to_MK'][$i]['user_id'] = Auth::User()->id;
} else {
if (count($productModel->checkProductOnSiteId('MK', $row[to1251('VP01 Id товара')])) > 0) {
//убеждаемся, что на этот товар уже привязан
//если товар есть на сайте, будем обновлять
!array_key_exists(to1251('MK01 ID на МК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.site_id'] = import_field($row[to1251('MK01 ID на МК')], 'int', 0));
!array_key_exists(to1251('MK02 Статус МК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.enabled'] = import_field($row[to1251('MK02 Статус МК')], 'bool', 1));
!array_key_exists(to1251('MK03 Маркет МК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.yandex_enabled'] = import_field($row[to1251('MK03 Маркет МК')], 'bool', 0));
!array_key_exists(to1251('MK04 Валюта МК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.currency'] = import_field($row[to1251('MK04 Валюта МК')], 'string', 'RUB'));
!array_key_exists(to1251('MK05 Цена МК'), $row) ?: ($res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.price'] = import_field($row[to1251('MK05 Цена МК')], 'float', 0));
$res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.updated_at'] = date('Y-m-d H:i:s');
$res['update_prod'][$row[to1251('VP01 Id товара')]]['MK.user_id'] = Auth::User()->id;
}
}
}
} else {
//такого товара нет, будем добавлять
!array_key_exists(to1251('VP02 Статус'), $row) ? $res['add_prod'][$i]['products.status'] = 1 : ($res['add_prod'][$i]['products.status'] = import_field($row[to1251('VP02 Статус')], 'bool', 1));
!array_key_exists(to1251('VP03 Наименование'), $row) ? $res['add_prod'][$i]['products.name'] = '' : ($res['add_prod'][$i]['products.name'] = import_field(toUTF($row[to1251('VP03 Наименование')]), 'string', ''));
!array_key_exists(to1251('VP04 ID категории'), $row) ? $res['add_prod'][$i]['products.category_id'] = 1 : ($res['add_prod'][$i]['products.category_id'] = import_field($row[to1251('VP04 ID категории')], 'int', 1));
!array_key_exists(to1251('VP05 ID производителя'), $row) ? $res['add_prod'][$i]['products.brand_id'] = 1 : ($res['add_prod'][$i]['products.brand_id'] = import_field($row[to1251('VP05 ID производителя')], 'int', 1));
!array_key_exists(to1251('VP06 Артикул'), $row) ? $res['add_prod'][$i]['products.article'] = '' : ($res['add_prod'][$i]['products.article'] = import_field(toUTF($row[to1251('VP06 Артикул')]), 'string', ''));
!array_key_exists(to1251('VP07 Штрих-код'), $row) ? $res['add_prod'][$i]['products.ean'] = '' : ($res['add_prod'][$i]['products.ean'] = import_field($row[to1251('VP07 Штрих-код')], 'string', ''));
!array_key_exists(to1251('VP08 МРЦ'), $row) ? $res['add_prod'][$i]['products.mrc'] = 0 : ($res['add_prod'][$i]['products.mrc'] = import_field($row[to1251('VP08 МРЦ')], 'float', 0));
!array_key_exists(to1251('VP09 МРЦ валюта'), $row) ? $res['add_prod'][$i]['products.mrc_currency'] = 'RUB' : ($res['add_prod'][$i]['products.mrc_currency'] = import_field($row[to1251('VP09 МРЦ валюта')], 'string', 'RUB'));
!array_key_exists(to1251('VP10 Прайс'), $row) ? $res['add_prod'][$i]['products.price'] = 0 : ($res['add_prod'][$i]['products.price'] = import_field($row[to1251('VP10 Прайс')], 'float', 0));
!array_key_exists(to1251('VP11 Прайс валюта'), $row) ? $res['add_prod'][$i]['products.price_currency'] = 'RUB' : ($res['add_prod'][$i]['products.price_currency'] = import_field($row[to1251('VP11 Прайс валюта')], 'string', 'RUB'));
!array_key_exists(to1251('VP12 Маржинальность'), $row) ? $res['add_prod'][$i]['products.target_margin'] = 0 : ($res['add_prod'][$i]['products.target_margin'] = import_field($row[to1251('VP12 Маржинальность')], 'float', 0));
!array_key_exists(to1251('VP13 Наличие'), $row) ? $res['add_prod'][$i]['products.in_stock'] = 0 : ($res['add_prod'][$i]['products.in_stock'] = import_field($row[to1251('VP13 Наличие')], 'bool', 0));
$res['add_prod'][$i]['products.created_at'] = date('Y-m-d H:i:s');
$res['add_prod'][$i]['products.updated_at'] = date('Y-m-d H:i:s');
$res['add_prod'][$i]['products.user_id'] = Auth::User()->id;
}
} elseif (array_key_exists(to1251('PU01 Id закупки'), $row)) {
//это условия
if (!array_key_exists(to1251('PU02 Id товара'), $row) or empty($row[to1251('PU02 Id товара')])) {
//нет обязательного поля с ID товара
Session::flash('message', GetMessages("ERROR_NO_REQUIRED_FIELD"));
return redirect()->route('cloud.index');
}
if (!empty($row[to1251('PU01 Id закупки')])) {
//такое уcловие существует - будем обновлять
!array_key_exists(to1251('PU03 ID поставщика'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.vendor_id'] = import_field($row[to1251('PU03 ID поставщика')], 'int', 1));
!array_key_exists(to1251('PU04 Базовая цена'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.base_price'] = import_field($row[to1251('PU04 Базовая цена')], 'float', 0));
!array_key_exists(to1251('PU05 Валюта'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.currency'] = import_field($row[to1251('PU05 Валюта')], 'string', 'RUB'));
!array_key_exists(to1251('PU06 Поправка к ЦБ'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.raise'] = import_field($row[to1251('PU06 Поправка к ЦБ')], 'float', 0));
!array_key_exists(to1251('PU07 Скидка'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.discount_price'] = import_field($row[to1251('PU07 Скидка')], 'float', 0));
!array_key_exists(to1251('PU08 Доп.скидка'), $row) ?: ($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.discount_bulk'] = import_field($row[to1251('PU08 Доп.скидка')], 'float', 0));
if (isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.vendor_id']) or isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.base_price']) or isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.currency_id']) or isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.raise']) or isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.discount_price']) or isset($res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.discount_bulk'])) {
$res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.id'] = $row[to1251('PU01 Id закупки')];
$res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.product_id'] = $row[to1251('PU02 Id товара')];
$res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.updated_at'] = date('Y-m-d H:i:s');
$res['update_purch'][$row[to1251('PU01 Id закупки')]]['purchase.user_id'] = Auth::User()->id;
}
} else {
//такого условия нет - будем добавлять
!array_key_exists(to1251('PU03 ID поставщика'), $row) ? $res['add_purch'][$i]['purchase.vendor_id'] = 1 : ($res['add_purch'][$i]['purchase.vendor_id'] = import_field($row[to1251('PU03 ID поставщика')], 'int', 1));
!array_key_exists(to1251('PU04 Базовая цена'), $row) ? $res['add_purch'][$i]['purchase.base_price'] = 0 : ($res['add_purch'][$i]['purchase.base_price'] = import_field($row[to1251('PU04 Базовая цена')], 'float', 0));
!array_key_exists(to1251('PU05 Валюта'), $row) ? $res['add_purch'][$i]['purchase.currency'] = 'RUB' : ($res['add_purch'][$i]['purchase.currency'] = import_field($row[to1251('PU05 Валюта')], 'string', 'RUB'));
!array_key_exists(to1251('PU06 Поправка к ЦБ'), $row) ? $res['add_purch'][$i]['purchase.raise'] = 0 : ($res['add_purch'][$i]['purchase.raise'] = import_field($row[to1251('PU06 Поправка к ЦБ')], 'float', 0));
!array_key_exists(to1251('PU07 Скидка'), $row) ? $res['add_purch'][$i]['purchase.discount_price'] = 0 : ($res['add_purch'][$i]['purchase.discount_price'] = import_field($row[to1251('PU07 Скидка')], 'float', 0));
!array_key_exists(to1251('PU08 Доп.скидка'), $row) ? $res['add_purch'][$i]['purchase.discount_bulk'] = 0 : ($res['add_purch'][$i]['purchase.discount_bulk'] = import_field($row[to1251('PU08 Доп.скидка')], 'float', 0));
$res['add_purch'][$i]['purchase.product_id'] = $row[to1251('PU02 Id товара')];
$res['add_purch'][$i]['purchase.created_at'] = date('Y-m-d H:i:s');
$res['add_purch'][$i]['purchase.updated_at'] = date('Y-m-d H:i:s');
$res['add_purch'][$i]['purchase.user_id'] = Auth::User()->id;
}
} else {
Session::flash('message', GetMessages("ERROR_NO_REQUIRED_FIELD"));
return redirect()->route('cloud.index');
}
//pr($res);
$i++;
}
//pr($res);
$count = [];
if (isset($res['update_prod'])) {
$count['update_prod'] = count($res['update_prod']);
}
if (isset($res['add_prod'])) {
$count['add_prod'] = count($res['add_prod']);
}
if (isset($res['add_to_GK'])) {
$count['add_to_GK'] = count($res['add_to_GK']);
}
if (isset($res['add_to_TV'])) {
$count['add_to_TV'] = count($res['add_to_TV']);
}
if (isset($res['add_to_MK'])) {
$count['add_to_MK'] = count($res['add_to_MK']);
}
if (isset($res['update_purch'])) {
$count['update_purch'] = count($res['update_purch']);
}
if (isset($res['add_purch'])) {
$count['add_purch'] = count($res['add_purch']);
}
Session::put('count', $count);
Session::put('res', $res);
//pr($res);
$cloudModel->addFile('import', $filename, $real_filename);
return redirect()->route('cloud.index');
}
} else {
Session::flash('message', GetMessages("ERROR_NO_CSV_FILE"));
return redirect()->route('cloud.index');
}
} else {
Session::flash('message', GetMessages("ERROR_NO_CSV_FILE"));
return redirect()->route('cloud.index');
}
}
if (isset($_POST['end_import'])) {
if (!right('Import')) {
abort(404);
}
$count = Session::pull('count', null);
$res = Session::pull('res', null);
//pr($res);
//pr($count);
if (isset($res['update_prod']) and count($res['update_prod']) > 0) {
$productModel->updatingListProducts($res['update_prod']);
}
if (isset($res['add_prod']) and count($res['add_prod']) > 0) {
$idsNewProducts = $productModel->createProducts($res['add_prod']);
Session::put('idsNewProducts', $idsNewProducts);
}
if (isset($res['add_to_GK']) and count($res['add_to_GK']) > 0) {
$productModel->addsToSite($res['add_to_GK'], 'GK');
}
if (isset($res['add_to_TV']) and count($res['add_to_TV']) > 0) {
$productModel->addsToSite($res['add_to_TV'], 'TV');
}
if (isset($res['add_to_MK']) and count($res['add_to_MK']) > 0) {
$productModel->addsToSite($res['add_to_MK'], 'MK');
}
if (isset($res['update_purch']) and count($res['update_purch']) > 0) {
$purchaseModel->updatePurchase($res['update_purch']);
}
if (isset($res['add_purch']) and count($res['add_purch']) > 0) {
$purchaseModel->addPurchases($res['add_purch']);
}
$historyModel->saveHistory('import', $count);
Session::flash('message', GetMessages("SUCCESS_IMPORT_COMPLETED"));
return redirect()->route('cloud.index');
}
if (isset($_POST['send_to_site'])) {
if (!right('Import')) {
abort(404);
}
//pr($_POST);
if (isset($_POST['sent_to_'])) {
$externalModel = new External();
if (isset($_POST['sent_to_']['GK'])) {
$externalModel->send('GK');
}
if (isset($_POST['sent_to_']['TV'])) {
$externalModel->send('TV');
}
if (isset($_POST['sent_to_']['GK'])) {
$externalModel->send('MK');
}
}
if (isset($_POST['clear_list'])) {
$productModel->deleteAllExport();
}
Session::flash('message', GetMessages("SUCCESS_EXTERNAL_EXPORT"));
return redirect()->route('cloud.index');
}
}
$birthday = '12/30/1985';
$reg = Register($username, $name, $pass, $birthday);
$code = $codes[array_rand($codes)];
Login($username, $pass);
$change = ChangeNumber($code);
//$out = array_values($change);
echo @json_encode($change);
LogOut();
break;
case "5":
ini_set('max_execution_time', 300);
//300 seconds = 5 minutes
//hideChatGroup
try {
Login($username, $pass);
$msgs = GetMessages();
foreach ($msgs['conversations']['conversation'] as $msg) {
$cid = $msg['@attributes']['cid'];
HideChatGroup($cid);
}
echo $done;
//LogOut();
} catch (Exception $e) {
echo $err;
}
break;
default:
echo $err;
break;
}
function SendRequest($url, $sub_url, $post, $data)
/**
* Outputs the sitemap link, admin login/logout link, powered by link, admin html and messages
* @static
*/
function GetAdminLink()
{
global $config, $langmessage, $page;
if (!isset($config['showsitemap']) || $config['showsitemap']) {
echo ' <span class="sitemap_link">';
echo common::Link('Special_Site_Map', $langmessage['site_map']);
echo '</span>';
}
if (!isset($config['showlogin']) || $config['showlogin']) {
echo ' <span class="login_link">';
if (common::LoggedIn()) {
echo common::Link($page->title, $langmessage['logout'], 'cmd=logout', ' name="creq" rel="nofollow" ');
} else {
echo common::Link('Admin_Main', $langmessage['login'], 'file=' . $page->title, ' rel="nofollow" name="login"');
}
echo '</span>';
}
if (!isset($config['showgplink']) || $config['showgplink']) {
echo ' <span id="powered_by_link">';
echo 'Powered by <a href="http://gpEasy.com" title="A Free and Easy CMS in PHP">gp|Easy CMS</a>';
echo '</span>';
}
GetMessages();
}
<input type="hidden" name="_token" value="{!! csrf_token() !!}"/>
<div class="form-group">
<label class="col-sm-2 control-label">Наименование <span class="c_red">*</span></label>
<div class="col-sm-10">
<input type="text" class="form-control" name="name" value="">
<span class="help-block m-b-none">Не может быть пустым</span>
</div>
</div>
<div class="hr-line-dashed"></div>
<div class="form-group">
<div class="col-sm-4 col-sm-offset-2">
<a href="{{ route('brand.index') }}" class="btn btn-white"><i class="fa fa-arrow-left"></i> Назад</a>
<button class="btn btn-primary" name="create_brand">Создать производителя</button>
</div>
</div>
</form>
</div>
</div>
@else
<div class="alert alert-danger">
<?php
echo GetMessages("NO_RIGHTS");
?>
</div>
@endif
</div>
@stop
public function delete(Currency $currencyModel, $currency)
{
$currencyModel->deleteCurrency($currency);
Session::flash('message', GetMessages("SUCCESS_DELETING_CURR"));
return redirect($_SERVER['HTTP_REFERER']);
}