"<?php
echo $row['printpromolink'] ? ' checked="checked"' : '';
?>
>
</label>
</div>
</div>
</td>
<td>
<div class="form-group">
<select class="form-control" id="cart-item-size-<?php
echo $row['id'];
?>
">
<?php
foreach (EshopHelper::getClothingSizes() as $value) {
?>
<option<?php
echo $row['size'] == $value ? ' selected="selected"' : '';
?>
><?php
echo $value;
?>
</option>
<?php
}
?>
</select>
</div>
</td>
<td class="text-right" id="cart-item-price-<?php
$result = Yii::$app->db->createCommand("\n\t\t\t \t\tINSERT INTO cart (\n\t\t\t \t\t\thash, item_id, size, amount, inscription, printpromolink, created\n\t\t\t \t\t)\n\t\t\t \t\tVALUES (\n\t\t\t \t\t\t{$hash},\n\t\t\t\t\t\t{$item_id},\n\t\t\t \t\t\t" . Yii::$app->db->quoteValue($size) . ",\n\t\t\t \t\t\t{$amount},\n\t\t\t \t\t\t" . Yii::$app->db->quoteValue($inscription) . ",\n\t\t\t \t\t\t{$printpromolink},\n\t\t\t \t\t\t" . new \yii\db\Expression('NOW()') . "\n\t\t\t \t\t)")->execute();
$response = ['status' => $result, 'count' => Yii::$app->db->createCommand("SELECT COUNT(id) FROM cart WHERE hash = {$hash}")->queryScalar(), 'sum' => (int) Yii::$app->db->createCommand("SELECT SUM(amount) FROM cart WHERE hash = {$hash}")->queryScalar()];
}
} elseif ($_POST['action'] == 'c') {
$item_id = (int) $_POST['item_id'];
$result = Yii::$app->db->createCommand("\n\t\t\t\t\tINSERT INTO cart (hash, item_id, created)\n\t\t\t \t\tVALUES (\n\t\t\t \t\t\t{$hash},\n\t\t\t \t\t\t{$item_id},\n\t\t\t \t\t\t" . new \yii\db\Expression('NOW()') . "\n\t\t\t \t\t)")->execute();
Yii::$app->db->createCommand("UPDATE cart SET amount=amount+1 WHERE id = " . Yii::$app->db->lastInsertID)->execute() . " AND hash = {$hash}";
$response = ['status' => $result, 'count' => Yii::$app->db->createCommand("SELECT COUNT(id) FROM cart WHERE hash = {$hash}")->queryScalar(), 'sum' => (int) Yii::$app->db->createCommand("SELECT SUM(amount) FROM cart WHERE hash = {$hash}")->queryScalar()];
} elseif ($_POST['action'] == 'd') {
$id = (int) $_POST['id'];
$result = Yii::$app->db->createCommand("DELETE FROM cart WHERE id = {$id} AND hash = {$hash}")->execute();
$response = ['status' => $result, 'count' => Yii::$app->db->createCommand("SELECT COUNT(id) FROM cart WHERE hash = {$hash}")->queryScalar(), 'sum' => (int) Yii::$app->db->createCommand("SELECT SUM(amount) FROM cart WHERE hash = {$hash}")->queryScalar(), 'total' => EshopHelper::priceFormat(Yii::$app->db->createCommand("\n\t\t\t\t\tSELECT SUM(price * amount) FROM cart \n\t\t\t\t\t\tINNER JOIN item ON (cart.item_id = item.id)\n\t\t\t\t\tWHERE hash = {$hash}")->queryScalar())];
} elseif ($_POST['action'] == 'e') {
$set = "modified = " . new \yii\db\Expression('NOW()');
$id = (int) $_POST['id'];
if (isset($_POST['size']) && in_array($_POST['size'], EshopHelper::getClothingSizes())) {
$set .= ", size = '{$_POST['size']}' ";
}
if (isset($_POST['amount'])) {
$amount = (int) $_POST['amount'];
if ($amount > 0) {
$set .= ", amount = {$amount} ";
}
}
if (isset($_POST['printpromolink'])) {
$set .= ", printpromolink = " . ((int) $_POST['printpromolink'] == 1 ? '1' : '0') . " ";
}
$result = Yii::$app->db->createCommand("UPDATE cart SET {$set} WHERE id = {$id} AND hash = {$hash}")->execute();
$response = ['status' => $result, 'count' => Yii::$app->db->createCommand("SELECT COUNT(id) FROM cart WHERE hash = {$hash}")->queryScalar(), 'sum' => (int) Yii::$app->db->createCommand("SELECT SUM(amount) FROM cart WHERE hash = {$hash}")->queryScalar(), 'priceamount' => EshopHelper::priceFormat(Yii::$app->db->createCommand("\n\t\t\t\t\t\tSELECT price * amount FROM cart\n\t\t\t\t\t\tINNER JOIN item ON (cart.item_id = item.id)\n\t\t\t\t\t\tWHERE cart.id = {$id} AND hash = {$hash}")->queryScalar()), 'total' => EshopHelper::priceFormat(Yii::$app->db->createCommand("\n\t\t\t\t\t\tSELECT SUM(price * amount) FROM cart\n\t\t\t\t\t\tINNER JOIN item ON (cart.item_id = item.id)\n\t\t\t\t\t\tWHERE hash = {$hash}")->queryScalar())];
} elseif ($_POST['action'] == 'f') {
$set = "modified = " . new \yii\db\Expression('NOW()');
