<?php

class admin_orders_model extends Model {
    
    
    public function getOrders() {
        $result = $this->query("SELECT * "
                . "FROM orders "
                . "WHERE status>'1' "
                . "ORDER BY created DESC;");
        return $result;
    }
    
    
    public function loadOrder() {
        $order_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from orders where id='".$order_id."';");
        return $row[0];
    }
    
    
    public function loadCart() {
        $order_id = $this->escapeString($_REQUEST['id']);
        $result = $this->query("SELECT "
                . "cart.id AS cart_id, "
                . "cart.*, products.* "
                . "FROM cart "
                . "LEFT JOIN products ON products.id=cart.product_id "
                . "WHERE cart.status='1';");
        return $result;
    }
        
    
    public function deleteOrder($id) {
        $id = $this->escapeString($_REQUEST['id']);
        $this->execute("delete from orders where id='".$id."';");
        $this->execute("delete from cart where order_id='".$id."';");
        return true;
    }
    
    
    public function deleteCartItem($id) {
        $id = $this->escapeString($id);
        $this->execute("DELETE FROM cart WHERE id='".$id."';");
        return true;
    }
    
    
    public function setOrderState($id,$state) {
        $id = $this->escapeString($id);
        $state = $this->escapeString($state);
        $this->execute("update orders set status='".$state."' where id='".$id."';");
        
        $res = $this->query("SELECT * FROM orders WHERE id='".$id."';");
        $row = $res[0];
        
        if ($state=='3') {
            $headers = "From: Azonics.com <info@azonics.com>\r\n";
            $headers .= "Reply-To: Azonics.com <info@azonics.com>\r\n";
            $headers .= "MIME-Version: 1.0\r\n";
            $headers .= "Content-Type: text/html; charset=UTF-8\r\n";

            $message = file_get_contents("application/views/mails/order_payed_mail.html");
            $message = str_replace("%keresztnev%",$row->bill_knev,$message);
            $message = str_replace("%id%",$id,$message);
            $message = str_replace("%website%","Azonics.com",$message);
            $message = str_replace("%address%","1147 Budapest, Öv utca 133. (A)",$message);
            $message = str_replace("%phone%","+36 (30) 203-9960",$message);
            $message = str_replace("%email%","info@azonics.com",$message);

            mail($row->email,"A(z) ".$id." számú rendelés fizetve",$message,$headers);
        }
        elseif ($state=='4') {
            $headers = "From: Azonics.com <info@azonics.com>\r\n";
            $headers .= "Reply-To: Azonics.com <info@azonics.com>\r\n";
            $headers .= "MIME-Version: 1.0\r\n";
            $headers .= "Content-Type: text/html; charset=UTF-8\r\n";

            $message = file_get_contents("application/views/mails/order_delivered_mail.html");
            $message = str_replace("%keresztnev%",$row->bill_knev,$message);
            $message = str_replace("%id%",$id,$message);
            $message = str_replace("%website%","Azonics.com",$message);
            $message = str_replace("%address%","1147 Budapest, Öv utca 133. (A)",$message);
            $message = str_replace("%phone%","+36 (30) 203-9960",$message);
            $message = str_replace("%email%","info@azonics.com",$message);

            mail($row->email,"A(z) ".$id.". számú rendelés szállítás alatt",$message,$headers);
        }
        
        return true;
    }
    
    
}