PageRenderTime 45ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/admin444/tabs/AdminCarts.php

http://marocmall.googlecode.com/
PHP | 285 lines | 248 code | 21 blank | 16 comment | 17 complexity | 82ef21e0dc737df85ed2b28824bb058a MD5 | raw file
Possible License(s): LGPL-2.1 
    

  1. <?php
    2. 

  2. 

  3. /**
    4. 

  4.   * Customers tab for admin panel, AdminContacts.php
    5. 

  5.   * @category admin
    6. 

  6.   *
    7. 

  7.   * @author PrestaShop <support@prestashop.com>
    8. 

  8.   * @copyright PrestaShop
    9. 

  9.   * @license http://www.opensource.org/licenses/osl-3.0.php Open-source licence 3.0
    10. 

  10.   * @version 1.3
    11. 

  11.   *
    12. 

  12.   */
    13. 

  13. 

  14. include_once(PS_ADMIN_DIR.'/../classes/AdminTab.php');
    15. 

  15. 

  16. class AdminCarts extends AdminTab
    17. 

  17. {
    18. 

  18. 	public function __construct()
    19. 

  19. 	{
    20. 

  20. 	 	$this->table = 'cart';
    21. 

  21. 	 	$this->className = 'Cart';
    22. 

  22. 		$this->lang = false;
    23. 

  23. 	 	$this->edit = false;
    24. 

  24. 	 	$this->view = true;
    25. 

  25. 	 	$this->delete = false;
    26. 

  26. 

  27. 

  28. 		$this->_select = 'CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`, a.id_cart as total, ca.name as carrier';
    29. 

  29. 		$this->_join = 'LEFT JOIN '._DB_PREFIX_.'customer c on (c.id_customer = a.id_customer)
    30. 

  30. 		LEFT JOIN '._DB_PREFIX_.'currency cu on (cu.id_currency = a.id_currency)
    31. 

  31. 		LEFT JOIN '._DB_PREFIX_.'carrier ca on (ca.id_carrier = a.id_carrier)
    32. 

  32. 		';
    33. 

  33. 		
    34. 

  34.  		$this->fieldsDisplay = array(
    35. 

  35. 		'id_cart' => array('title' => $this->l('ID'), 'align' => 'center', 'width' => 25),
    36. 

  36. 		'customer' => array('title' => $this->l('Customer'), 'width' => 80, 'filter_key' => 'c!lastname'),
    37. 

  37. 		'total' => array('title' => $this->l('Total'), 'callback' => 'getTotalCart', 'orderby' => false, 'search' => false, 'width' => 50, 'align' => 'right', 'prefix' => '<b>', 'suffix' => '</b>', 'currency' => true),
    38. 

  38. 		'carrier' => array('title' => $this->l('Carrier'), 'width' => 25, 'align' => 'center', 'callback' => 'replaceZeroByShopName'),
    39. 

  39. 		'date_add' => array('title' => $this->l('Date'), 'width' => 90, 'align' => 'right', 'type' => 'datetime', 'filter_key' => 'a!date_add'));
    40. 

  40. 		parent::__construct();
    41. 

  41. 	}
    42. 

  42. 

  43. 	public function viewDetails()
    44. 

  44. 	{
    45. 

  45. 		global $currentIndex, $cookie;
    46. 

  46. 

  47. 		$cart = $this->loadObject();
    48. 

  48. 		$customer = new Customer($cart->id_customer);
    49. 

  49. 		$customerStats = $customer->getStats();
    50. 

  50. 		$products = $cart->getProducts();
    51. 

  51. 		$customizedDatas = Product::getAllCustomizedDatas(intval($cart->id));
    52. 

  52. 		Product::addCustomizationPrice($products, $customizedDatas);
    53. 

  53. 		$summary = $cart->getSummaryDetails();
    54. 

  54. 		$discounts = $cart->getDiscounts();
    55. 

  55. 

  56. 		$currency = new Currency($cart->id_currency);
    57. 

  57. 		$currentLanguage = new Language(intval($cookie->id_lang));
    58. 

  58. 

  59. 		// display cart header
    60. 

  60. 		echo '<h2>'.(($customer->id) ? $customer->firstname.' '.$customer->lastname : $this->l('Guest')).' - '.$this->l('Cart #').sprintf('%06d', $cart->id).' '.$this->l('from').' '.$cart->date_upd.'</h2>';
    61. 

  61. 

  62. 		/* Display customer information */
    63. 

  63. 		echo '
    64. 

  64. 		<br />
    65. 

  65. 		<div style="float: left;">
    66. 

  66. 		<fieldset style="width: 400px">
    67. 

  67. 			<legend><img src="../img/admin/tab-customers.gif" /> '.$this->l('Customer information').'</legend>
    68. 

  68. 			<span style="font-weight: bold; font-size: 14px;">';
    69. 

  69. 			if ($customer->id)
    70. 

  70. 				echo '
    71. 

  71. 			<a href="?tab=AdminCustomers&id_customer='.$customer->id.'&viewcustomer&token='.Tools::getAdminToken('AdminCustomers'.intval(Tab::getIdFromClassName('AdminCustomers')).intval($cookie->id_employee)).'"> '.$customer->firstname.' '.$customer->lastname.'</a></span> ('.$this->l('#').$customer->id.')<br />
    72. 

  72. 			(<a href="mailto:'.$customer->email.'">'.$customer->email.'</a>)<br /><br />
    73. 

  73. 			'.$this->l('Account registered:').' '.Tools::displayDate($customer->date_add, intval($cookie->id_lang), true).'<br />
    74. 

  74. 			'.$this->l('Valid orders placed:').' <b>'.$customerStats['nb_orders'].'</b><br />
    75. 

  75. 			'.$this->l('Total paid since registration:').' <b>'.Tools::displayPrice($customerStats['total_orders'], $currency, false, false).'</b><br />';
    76. 

  76. 			else
    77. 

  77. 				echo $this->l('Guest not registered').'</span>';
    78. 

  78. 		echo '</fieldset>';
    79. 

  79. 		echo '
    80. 

  80. 		</div>
    81. 

  81. 		<div style="float: left; margin-left: 40px">';
    82. 

  82. 		
    83. 

  83. 		/* Display order information */
    84. 

  84. 		$id_order = intval(Order::getOrderByCartId($cart->id));
    85. 

  85. 		$order = new Order($id_order);
    86. 

  86. 		echo '
    87. 

  87. 		<fieldset style="width: 400px">
    88. 

  88. 			<legend><img src="../img/admin/cart.gif" /> '.$this->l('Order information').'</legend>
    89. 

  89. 			<span style="font-weight: bold; font-size: 14px;">';
    90. 

  90. 			if ($order->id)
    91. 

  91. 				echo '
    92. 

  92. 			<a href="?tab=AdminOrders&id_order='.intval($order->id).'&vieworder&token='.Tools::getAdminToken('AdminOrders'.intval(Tab::getIdFromClassName('AdminOrders')).intval($cookie->id_employee)).'"> '.$this->l('Order #').sprintf('%06d', $order->id).'</a></span>
    93. 

  93. 			<br /><br />
    94. 

  94. 			'.$this->l('Made on:').' '.Tools::displayDate($order->date_add, intval($cookie->id_lang), true).'<br /><br /><br /><br />';
    95. 

  95. 			else
    96. 

  96. 				echo $this->l('No order created from this cart').'</span>';
    97. 

  97. 		echo '</fieldset>';
    98. 

  98. 		echo '
    99. 

  99. 		</div>';
    100. 

    101. 

  101. 		// List of products
    102. 

  102. 		echo '
    103. 

  103. 		<br style="clear:both;" />
    104. 

  104. 			<fieldset style="margin-top:25px; width: 715px; ">
    105. 

  105. 				<legend><img src="../img/admin/cart.gif" alt="'.$this->l('Products').'" />'.$this->l('Cart summary').'</legend>
    106. 

  106. 				<div style="float:left;">
    107. 

  107. 					<table style="width: 700px;" cellspacing="0" cellpadding="0" class="table" id="orderProducts">
    108. 

  108. 						<tr>
    109. 

  109. 							<th align="center" style="width: 60px">&nbsp;</th>
    110. 

  110. 							<th>'.$this->l('Product').'</th>
    111. 

  111. 							<th style="width: 80px; text-align: center">'.$this->l('UP').'</th>
    112. 

  112. 							<th style="width: 20px; text-align: center">'.$this->l('Qty').'</th>
    113. 

  113. 							<th style="width: 30px; text-align: center">'.$this->l('Stock').'</th>
    114. 

  114. 							<th style="width: 90px; text-align: right; font-weight:bold;">'.$this->l('Total').'</th>
    115. 

  115. 						</tr>';
    116. 

  116. 						$tokenCatalog = Tools::getAdminToken('AdminCatalog'.intval(Tab::getIdFromClassName('AdminCatalog')).intval($cookie->id_employee));
    117. 

  117. 						foreach ($products as $k => $product)
    118. 

  118. 						{
    119. 

  119. 							$image = array();
    120. 

  120. 							if (isset($product['id_product_attribute']) AND intval($product['id_product_attribute']))
    121. 

  121. 								$image = Db::getInstance()->getRow('
    122. 

  122. 								SELECT id_image
    123. 

  123. 								FROM '._DB_PREFIX_.'product_attribute_image
    124. 

  124. 								WHERE id_product_attribute = '.intval($product['id_product_attribute']));
    125. 

  125. 						 	if (!isset($image['id_image']))
    126. 

  126. 								$image = Db::getInstance()->getRow('
    127. 

  127. 								SELECT id_image
    128. 

  128. 								FROM '._DB_PREFIX_.'image
    129. 

  129. 								WHERE id_product = '.intval($product['id_product']).' AND cover = 1');
    130. 

  130. 						 	$stock = Db::getInstance()->getRow('
    131. 

  131. 							SELECT '.($product['id_product_attribute'] ? 'pa' : 'p').'.quantity
    132. 

  132. 							FROM '._DB_PREFIX_.'product p
    133. 

  133. 							'.($product['id_product_attribute'] ? 'LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON p.id_product = pa.id_product' : '').'
    134. 

  134. 							WHERE p.id_product = '.intval($product['id_product']).'
    135. 

  135. 							'.($product['id_product_attribute'] ? 'AND pa.id_product_attribute = '.intval($product['id_product_attribute']) : ''));
    136. 

  136. 							/* Customization display */
    137. 

  137. 							$this->displayCustomizedDatas($customizedDatas, $product, $currency, $image, $tokenCatalog, $stock);
    138. 

  138. 							if ($product['cart_quantity'] > $product['customizationQuantityTotal'])
    139. 

  139. 								echo '
    140. 

  140. 								<tr>
    141. 

  141. 									<td align="center">'.(isset($image['id_image']) ? cacheImage(_PS_IMG_DIR_.'p/'.intval($product['id_product']).'-'.intval($image['id_image']).'.jpg',
    142. 

  142. 									'product_mini_'.intval($product['id_product']).(isset($product['id_product_attribute']) ? '_'.intval($product['id_product_attribute']) : '').'.jpg', 45, 'jpg') : '--').'</td>
    143. 

  143. 									<td><a href="index.php?tab=AdminCatalog&id_product='.$product['id_product'].'&updateproduct&token='.$tokenCatalog.'">
    144. 

  144. 										<span class="productName">'.$product['name'].'</span><br />
    145. 

  145. 										'.($product['reference'] ? $this->l('Ref:').' '.$product['reference'] : '')
    146. 

  146. 										.(($product['reference'] AND $product['supplier_reference']) ? ' / '.$product['supplier_reference'] : '')
    147. 

  147. 										.'</a></td>
    148. 

  148. 									<td align="center">'.Tools::displayPrice($product['price_wt'], $currency, false, false).'</td>
    149. 

  149. 									<td align="center" class="productQuantity">'.(intval($product['cart_quantity']) - $product['customizationQuantityTotal']).'</td>
    150. 

  150. 									<td align="center" class="productQuantity">'.intval($stock['quantity']).'</td>
    151. 

  151. 									<td align="right">'.Tools::displayPrice($product['total_wt'], $currency, false, false).'</td>
    152. 

  152. 								</tr>';
    153. 

  153. 							if (isset($image['id_image']))
    154. 

  154. 							{
    155. 

  155. 								$target = '../img/tmp/product_mini_'.intval($product['id_product']).(isset($product['id_product_attribute']) ? '_'.intval($product['id_product_attribute']) : '').'.jpg';
    156. 

  156. 								if (file_exists($target))
    157. 

  157. 									$products[$k]['image_size'] = getimagesize($target);
    158. 

  158. 							}
    159. 

  159. 						}
    160. 

  160. 					echo '
    161. 

  161. 					<tr class="cart_total_product">
    162. 

  162. 				<td colspan="5">'.$this->l('Total products:').'</td>
    163. 

  163. 				<td class="price bold right">'.Tools::displayPrice($summary['total_products_wt'], $currency, false).'</td>
    164. 

  164. 			</tr>';
    165. 

  165. 			if ($summary['total_discounts'] != 0)
    166. 

  166. 			echo '
    167. 

  167. 			<tr class="cart_total_voucher">
    168. 

  168. 				<td colspan="5">'.$this->l('Total vouchers:').'</td>
    169. 

  169. 				<td class="price-discount bold right">'.Tools::displayPrice($summary['total_discounts'], $currency, false).'</td>
    170. 

  170. 			</tr>';
    171. 

  171. 			if ($summary['total_wrapping'] > 0)
    172. 

  172. 			 echo '
    173. 

  173. 			 <tr class="cart_total_voucher">
    174. 

  174. 				<td colspan="5">'.$this->l('Total gift-wrapping:').'</td>
    175. 

  175. 				<td class="price-discount bold right">'.Tools::displayPrice($summary['total_wrapping'], $currency, false).'</td>
    176. 

  176. 			</tr>';
    177. 

  177. 			if ($cart->getOrderTotal(true, 5) > 0)
    178. 

  178. 			echo '
    179. 

  179. 			<tr class="cart_total_delivery">
    180. 

  180. 				<td colspan="5">'.$this->l('Total shipping:').'</td>
    181. 

  181. 				<td class="price bold right">'.Tools::displayPrice($cart->getOrderTotal(true, 5), $currency, false).'</td>
    182. 

  182. 			</tr>';
    183. 

  183. 			echo '
    184. 

  184. 			<tr class="cart_total_price">
    185. 

  185. 				<td colspan="5" class="bold">'.$this->l('Total:').'</td>
    186. 

  186. 				<td class="price bold right">'.Tools::displayPrice($summary['total_price'], $currency, false).'</td>
    187. 

  187. 			</tr>
    188. 

  188. 			</table>';
    189. 

    190. 

  190. 			if (sizeof($discounts))
    191. 

  191. 			{
    192. 

  192. 				echo '
    193. 

  193. 			<table cellspacing="0" cellpadding="0" class="table" style="width:280px; margin:15px 0px 0px 420px;">
    194. 

  194. 				<tr>
    195. 

  195. 					<th><img src="../img/admin/coupon.gif" alt="'.$this->l('Discounts').'" />'.$this->l('Discount name').'</th>
    196. 

  196. 					<th align="center" style="width: 100px">'.$this->l('Value').'</th>
    197. 

  197. 				</tr>';
    198. 

  198. 				
    199. 

  199. 				foreach ($discounts as $discount)
    200. 

  200. 					echo '
    201. 

  201. 				<tr>
    202. 

  202. 					<td><a href="?tab=AdminDiscounts&id_discount='.$discount['id_discount'].'&updatediscount&token='.Tools::getAdminToken('AdminDiscounts'.intval(Tab::getIdFromClassName('AdminDiscounts')).intval($cookie->id_employee)).'">'.$discount['name'].'</a></td>
    203. 

  203. 					<td align="center">- '.Tools::displayPrice($discount['value_real'], $currency, false).'</td>
    204. 

  204. 				</tr>';
    205. 

  205. 				echo '
    206. 

  206. 			</table>';
    207. 

  207. 			}
    208. 

  208. 				echo '
    209. 

  209. 				</div>';
    210. 

    211. 

  211. 				// Cancel product
    212. 

  212. 				echo '
    213. 

  213. 			</fieldset>
    214. 

  214. 		<div class="clear" style="height:20px;">&nbsp;</div>';
    215. 

  215. 	}
    216. 

  216. 	
    217. 

  217. 	private function displayCustomizedDatas(&$customizedDatas, &$product, &$currency, &$image, $tokenCatalog, &$stock)
    218. 

  218. 	{
    219. 

  219. 		$order = $this->loadObject();
    220. 

  220. 

  221. 		if (is_array($customizedDatas) AND isset($customizedDatas[intval($product['id_product'])][intval($product['id_product_attribute'])]))
    222. 

  222. 		{
    223. 

  223. 			echo '
    224. 

  224. 			<tr>
    225. 

  225. 				<td align="center">'.(isset($image['id_image']) ? cacheImage(_PS_IMG_DIR_.'p/'.intval($product['id_product']).'-'.intval($image['id_image']).'.jpg',
    226. 

  226. 				'product_mini_'.intval($product['id_product']).(isset($product['id_product_attribute']) ? '_'.intval($product['id_product_attribute']) : '').'.jpg', 45, 'jpg') : '--').'</td>
    227. 

  227. 				<td><a href="index.php?tab=AdminCatalog&id_product='.$product['id_product'].'&updateproduct&token='.$tokenCatalog.'">
    228. 

  228. 					<span class="productName">'.$product['name'].'</span><br />
    229. 

  229. 					'.($product['reference'] ? $this->l('Ref:').' '.$product['reference'] : '')
    230. 

  230. 					.(($product['reference'] AND $product['supplier_reference']) ? ' / '.$product['supplier_reference'] : '')
    231. 

  231. 					.'</a></td>
    232. 

  232. 				<td align="center">'.Tools::displayPrice($product['price_wt'], $currency, false, false).'</td>
    233. 

  233. 				<td align="center" class="productQuantity">'.$product['customizationQuantityTotal'].'</td>
    234. 

  234. 				<td align="center" class="productQuantity">'.intval($stock['quantity']).'</td>
    235. 

  235. 				<td align="right">'.Tools::displayPrice($product['total_customization_wt'], $currency, false, false).'</td>
    236. 

  236. 			</tr>';
    237. 

  237. 			foreach ($customizedDatas[intval($product['id_product'])][intval($product['id_product_attribute'])] AS $customization)
    238. 

  238. 			{
    239. 

  239. 				echo '
    240. 

  240. 				<tr>
    241. 

  241. 					<td colspan="2">';
    242. 

  242. 				foreach ($customization['datas'] AS $type => $datas)
    243. 

  243. 					if ($type == _CUSTOMIZE_FILE_)
    244. 

  244. 					{
    245. 

  245. 						$i = 0;
    246. 

  246. 						echo '<ul style="margin: 4px 0px 4px 0px; padding: 0px; list-style-type: none;">';
    247. 

  247. 						foreach ($datas AS $data)
    248. 

  248. 							echo '<li style="display: inline; margin: 2px;">
    249. 

  249. 									<a href="displayImage.php?img='.$data['value'].'&name='.intval($order->id).'-file'.++$i.'" target="_blank"><img src="'._THEME_PROD_PIC_DIR_.$data['value'].'_small" alt="" /></a>
    250. 

  250. 								</li>';
    251. 

  251. 						echo '</ul>';
    252. 

  252. 					}
    253. 

  253. 					elseif ($type == _CUSTOMIZE_TEXTFIELD_)
    254. 

  254. 					{
    255. 

  255. 						$i = 0;
    256. 

  256. 						echo '<ul style="margin: 0px 0px 4px 0px; padding: 0px 0px 0px 6px; list-style-type: none;">';
    257. 

  257. 						foreach ($datas AS $data)
    258. 

  258. 							echo '<li>'.($data['name'] ? $data['name'] : $this->l('Text #').++$i).$this->l(':').' '.$data['value'].'</li>';
    259. 

  259. 						echo '</ul>';
    260. 

  260. 					}
    261. 

  261. 				echo '</td>
    262. 

  262. 					<td align="center"></td>
    263. 

  263. 					<td align="center" class="productQuantity">'.$customization['quantity'].'</td>
    264. 

  264. 					<td align="center" class="productQuantity"></td>
    265. 

  265. 					<td align="center"></td>
    266. 

  266. 				</tr>';
    267. 

  267. 			}
    268. 

  268. 		}
    269. 

  269. 	}
    270. 

  270. 

  271. 	public function display()
    272. 

  272. 	{
    273. 

  273. 		global $cookie;
    274. 

  274. 

  275. 		if (isset($_GET['view'.$this->table]))
    276. 

  276. 			$this->viewDetails();
    277. 

  277. 		else
    278. 

  278. 		{
    279. 

  279. 			$this->getList(intval($cookie->id_lang), !Tools::getValue($this->table.'Orderby') ? 'date_add' : NULL, !Tools::getValue($this->table.'Orderway') ? 'DESC' : NULL);
    280. 

  280. 			$this->displayList();
    281. 

  281. 		}
    282. 

  282. 	}
    283. 

  283. }
    284. 

  284. 

  285. ?>
    286. 

  286.