trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR); } else { $stmt->bind_param("ss", $stock_quantity, $stock_id); $stmt->execute(); } $stmt->close(); } } $_cron = new CRON_EXPIRED_ORDER(); $_cron_email = 1; /* --- MINUS STOCK PREVENTED --- */ $_count_minus_stock = $_cron->count_minus_stock(); if ($_count_minus_stock->rows > 0) { $_data_minus_stock = $_cron->get_minus_stock(); foreach ($_data_minus_stock as $_data_minus_stock) { $_cron->update_minus_stock(0, $_data_minus_stock->stock_id); } } $header_check_expired = $_cron->header_count_order('Open', 'Unpaid'); if ($header_check_expired->rows > 0) { $header_get_expired = $_cron->header_get_order('Open', 'Unpaid'); foreach ($header_get_expired as $key => $header_get_expired) { $_time = 86400; $_order_living_time = $_cron->check_on_hold($header_get_expired->order_date); if ($_order_living_time->second > $_time) { $_cron->header_update_expired_order($header_get_expired->order_id); $status = 'Expired'; $date = date('Y-m-d H:i:s'); $payment = $header_get_expired->payment_status; $fulfillment = $header_get_expired->fulfillment_status; $order_id = $header_get_expired->order_id;