/**
* Массовое обновление статуса на все продукты,
* в соответствии с их активными товарными предложениями и активными торговыми акциями
*/
public static function massUpdateProductsStatuses()
{
$sql = "update " . Product::TABLE_NAME . " set status = 0";
\DB::update($sql);
$sql = "update " . Product::TABLE_NAME . " p\n join products_offers po on p.id = po.product_id\n join catalogs ct on ct.id = po.catalog_id\n set p.status = 1\n where ct.status = 1 and po.status = 1";
\DB::update($sql);
}
public function upload()
{
$ds = DIRECTORY_SEPARATOR;
//1
$storeFolder = PATH_UPLOAD . 'profile/';
//2
extract($_POST);
if (!empty($_FILES)) {
$filename = Str::sanitize($_FILES['file']['name']);
if (copy($_FILES['file']['tmp_name'], $storeFolder . $filename)) {
$id = DB::update('users', $_SESSION['user_id'], $section, array($section => $filename));
Image::resize_group($storeFolder, $filename);
return array('success' => true, 'id' => $id);
}
return array("error" => "Could not write to fs");
}
}
public function add()
{
extract($_REQUEST);
$now = time();
$lastid = DB::update('feed', $id, '*');
/*
preg_match_all('/(#\w+)/', $status, $matches);
foreach ($matches[0] as $hashtag)
echo $hashtag . ' ';
*/
preg_match_all("/(@\\w+)/", $status, $matches);
foreach ($matches[0] as $mentiontag) {
$user_id = DB::query('select id from users where username = \'' . str_replace('@', '', $mentiontag) . '\'', '2', 'id');
if ($user_id) {
DB::write('insert into mentions set
user_id = ' . $_SESSION['user_id'] . ',
user2_id = ' . $user_id . ',
feed_id = ' . $lastid . ',
created_ts = ' . $now);
}
}
$entry = feedController::status($lastid);
return array('entry' => $entry);
}
public function update()
{
$_POST['user_id'] = $_SESSION['user_id'];
return DB::update('webcams', $_POST['id'], '*', $_POST);
}