send sms to manufacturer after new order

Code: Select all

$product_info_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "product` WHERE product_id = '" . (int)$product['product_id'] . "'");
$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
$manufacturer_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "manufacturer` WHERE manufacturer_id = '" . (int)$pp_query->row['manufacturer_id'] . "'");

Code: Select all

$this->load->model('catalog/manufacturer');
$manufacturer = $this->model_catalog_manufacturer->getManufacturer($product['manufacturer_id']);
if (isset($data['manufacturer'])) {
foreach ($data['manufacturer'] as $manufacturer) {
		$this->db->query("UPDATE " . DB_PREFIX . "manufacturer SET manufacturer_id = '" . (int)$manufacturer_id . "', name = '" . $this->db->escape($manufacturer['name']) . "', telephone = '" . $this->db->escape($manufacturer['telephone']));} 
}

Code: Select all

foreach ($order_product_query->rows as $result) {
		$pro_name = $result['name'];  
		$pro_quantity = $result['quantity']; 
	}
foreach ($manufacturer_query->rows as $result) {
		$manufacturer_name = $result['name'];  
		$manufacturer_number = $result['telephone']; 
	}
$pattern_code = "snuvhlo2nl5440q";
$input_data = array(
        "name" => $manufacturer_name,
        "order_id" => $order_id,
        "status" => $manufacturer_number,
	);
 $username = "";
$password = '';
$from = "";
$to = array($manufacturer_query->row['telephone']);
$url = "https://webservice.com/patterns/pattern?username=" . $username . "&password=" . urlencode($password) . "&from=".$from."&to=" . json_encode($to) . "&input_data=" . urlencode(json_encode($input_data)) . "&pattern_code=$pattern_code";
            $handler = curl_init($url);
            curl_setopt($handler, CURLOPT_CUSTOMREQUEST, "POST");
            curl_setopt($handler, CURLOPT_POSTFIELDS, $input_data);
            curl_setopt($handler, CURLOPT_RETURNTRANSFER, true);
            $response = curl_exec($handler);
            echo $response;
}
else {
      echo "nothing else";                 
}			
				
				

Code: Select all

$this->load->model('catalog/manufacturer');
$manufacturers = $this->model_catalog_manufacturer->getManufacturer($product['manufacturer_id']);
if (is_array($manufacturers) || is_object($manufacturers)) {
foreach ($manufacturers as $manufacturer) {
		This query is wrong 
}

Code: Select all

ALTER TABLE `oc_manufacturer` ADD `telephone` varchar(32) NOT NULL;

Code: Select all

$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_product` op 
LEFT JOIN `" . DB_PREFIX . "product` p 
ON (op.`product_id` = p.`product_id`) 
LEFT JOIN `" . DB_PREFIX . "manufacturer` m 
ON (p.`manufacturer_id` = m.`manufacturer_id`) 
WHERE `order_id` = '" . (int)$order_id . "'");

Code: Select all

public function getproductsmanufacturer($order_id) {

$query = $this->db->query("SELECT op.*, p.*, GROUP_CONCAT(DISTINCT m.`name`) as manufacturer_names, GROUP_CONCAT(DISTINCT m.`telephone`) as manufacturer_telephones, GROUP_CONCAT(DISTINCT m.`manufacturer_id`) as manufacturer_ids FROM `" . DB_PREFIX . "order_product` op LEFT JOIN `" . DB_PREFIX . "product` p ON (op.`product_id` = p.`product_id`) LEFT JOIN `" . DB_PREFIX . "manufacturer` m ON (p.`manufacturer_id` = m.`manufacturer_id`) WHERE `order_id` = '" . (int)$order_id . "'");

$results = array();
        foreach ($query->rows as $row) {
        $manufacturer_names = explode(",", $row['manufacturer_names']);
        $manufacturer_telephones = explode(",", $row['manufacturer_telephones']);
        $manufacturer_ids = explode(",", $row['manufacturer_ids']);
        $product_id = $row['product_id'];
        $product_name = $row['name'];

        for ($i = 0; $i < count($manufacturer_names); $i++) {
            $manufacturer_name = $manufacturer_names[$i];
            $manufacturer_telephone = $manufacturer_telephones[$i];
            $manufacturer_id = $manufacturer_ids[$i];

            $results[] = array(
                'manufacturer_name' => $manufacturer_name,
                'manufacturer_telephone' => $manufacturer_telephone,
                'manufacturer_id' => $manufacturer_id,
                'order_id' => $order_id,
                'product_id' => $product_id,
                'product_name' => $product_name,
            );
        }
    }
     return $results;
}

Code: Select all

$ordered_products = $this->model_checkout_order->getproductsmanufacturer($order_id);
$data['ordered_products'] = $ordered_products;
foreach ($ordered_products as $ordered_product) {
    $manufacturer_name = $ordered_product['manufacturer_name'];
    $manufacturer_telephone = $ordered_product['manufacturer_telephone'];
    $product_name = $ordered_product['product_name'];
    $manufacturer_id = $ordered_product['manufacturer_id'];
}

    $pattern_code = "11hi8uiyoa1bq8w";
    $input_data = array(
        "tamin" => $manufacturer_name,
        "order_id" => $order_id,
        "product" => $product_name,
	);
    $username = "username";
    $password = 'password';
    $from = "+983000505";
    $to = array($manufacturer_telephone);
    $url = "https://ippanel.com/patterns/pattern?username=" . $username . "&password=" . urlencode($password) . "&from=".$from."&to=" . json_encode($to) . "&input_data=" . urlencode(json_encode($input_data)) . "&pattern_code=$pattern_code";
            $handler = curl_init($url);
            curl_setopt($handler, CURLOPT_CUSTOMREQUEST, "POST");
            curl_setopt($handler, CURLOPT_POSTFIELDS, $input_data);
            curl_setopt($handler, CURLOPT_RETURNTRANSFER, true);
            $response = curl_exec($handler);
            echo $response;

Code: Select all

	public function checkDatabaseonManufacturerPhone() {
		$manufacturerphone_altered = $this->db->query("SHOW COLUMNS FROM `".DB_PREFIX."manufacturer` LIKE 'telephone';");
		if ( !$manufacturerphone_altered->row ) {
			$this->db->query("ALTER TABLE `".DB_PREFIX."manufacturer` ADD `telephone` varchar(32) NOT NULL DEFAULT '0' AFTER `image`;");	
		}
		
	}
	public function getOrderManufacturer($order_product_id) {
		// first check if telephone exists
		$this->checkDatabaseonManufacturerPhone();
		
		$manufacturer_query = $this->db->query("SELECT p.product_id as product_id, m.manufacturer_id as manufacturer_id, m.name AS name, m.telephone as telephone FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$order_product_id . "'");

		if ($manufacturer_query->rows) {
			return $manufacturer_query->row;
		} else {
			return false;
		}
	}

Code: Select all

foreach ($order_products as $order_product) {

Code: Select all

$manufacturers_data = array();

Code: Select all

foreach ($order_products as $order_product) {

Code: Select all

			$orderproduct_manufacturer = $this->model_checkout_order->getOrderManufacturer($order_product['product_id']);
			
			if ($orderproduct_manufacturer) {
				if (!array_key_exists($orderproduct_manufacturer['manufacturer_id'], $manufacturers_data)) {
					$manufacturers_data[$orderproduct_manufacturer['manufacturer_id']] = array(
						'manufacturer_id'	=> $orderproduct_manufacturer['manufacturer_id'],
						'name'				=> $orderproduct_manufacturer['name'],
						'telephone' 		=> $orderproduct_manufacturer['telephone']
					);
				}				
				
				$manufacturers_data[$orderproduct_manufacturer['manufacturer_id']]['products'][] = array(
					'product_id' =>  $order_product['product_id'],
					'name'			=> $order_product['name'],
					'model'			=> $order_product['model'],
					'quantity'		=> $order_product['quantity']
				);
			}

Code: Select all

$mail->send();

Code: Select all

		$this->log->write($manufacturers_data);
		foreach ($manufacturers_data as $manufacturer) {
			$ordered_products = '';
			
			foreach ($manufacturer['products'] as $ordered_product) {
				$ordered_products .= $ordered_product['quantity'] . ' x ' .  $ordered_product['product_id'] . ' ' . $ordered_product['name'] . '-' . $ordered_product['model'] . "\n";
			}
			
			$this->log->write('To ' . $manufacturer['name']);
			$this->log->write('Phone ' . $manufacturer['telephone']);
			$this->log->write('Products ' . $ordered_products);
			 
			// SMS code here
		}