Subversion Repositories SmartDukaan

Rev

Rev 15188 | Rev 15227 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13532 anikendra 1
<?php
2
App::uses('AppController', 'Controller');
3
/**
4
 * Orders Controller
5
 *
6
 * @property Order $Order
7
 * @property PaginatorComponent $Paginator
8
 */
9
class OrdersController extends AppController {
10
 
11
/**
12
 * Components
13
 *
14
 * @var array
15
 */
16
	public $components = array('Paginator');
17
 
13672 anikendra 18
	public function beforeFilter() {		
13591 anikendra 19
		parent::beforeFilter();
15093 anikendra 20
		$this->Auth->allow('add','mine','pendingcashbacks','all');
13672 anikendra 21
		$this->apihost = Configure::read('pythonapihost');
13591 anikendra 22
	}
23
 
13816 anikendra 24
	public function mine() {
25
		$page = $this->request->query('page');
26
		$page = isset($page)?$page:1;
13682 anikendra 27
		$userId = $this->request->query('user_id');
28
		if(isset($userId) && !empty($userId)){
29
			$this->loadModel('User');
30
			$dbuser = $this->User->findById($userId);
31
			$this->Auth->login($dbuser['User']);	
32
		}
13672 anikendra 33
		$this->layout = "innerpages";
13815 anikendra 34
		$url = $this->apihost."storeorder/user/".$this->Auth->User('id')."?page=$page&window=10";
13672 anikendra 35
		$response = $this->make_request($url,null);
13815 anikendra 36
		$totalPages = $response['totalPages'];
13672 anikendra 37
		if(!empty($response['data'])){
38
			$this->set('orders',$response['data']);
39
		}
13752 anikendra 40
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
13944 anikendra 41
		$storemapping = Configure::read('storemapping');
42
		$activestores = Configure::read('activestores');
14224 anikendra 43
		$amazonorderurl = Configure::read('amazonorderurl');
44
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl'));
13672 anikendra 45
	}
46
 
15217 anikendra 47
	public function by($userId) {
48
		$page = $this->request->query('page');
49
		$page = isset($page)?$page:1;		
50
		$this->layout = "innerpages";
51
		$url = $this->apihost."storeorder/user/".$userId."?page=$page&window=10";
52
		$response = $this->make_request($url,null);
53
		$totalPages = $response['totalPages'];
54
		if(!empty($response['data'])){
55
			$this->set('orders',$response['data']);
56
		}
57
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
58
		$storemapping = Configure::read('storemapping');
59
		$activestores = Configure::read('activestores');
60
		$amazonorderurl = Configure::read('amazonorderurl');
61
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl'));
62
	}
63
 
13762 anikendra 64
	public function pendingcashbacks() {
65
		$userId = $this->request->query('user_id');
66
		if(isset($userId) && !empty($userId)){
67
			$this->loadModel('User');
68
			$dbuser = $this->User->findById($userId);
69
			$this->Auth->login($dbuser['User']);	
70
		}
71
		$this->layout = "innerpages";
13993 anikendra 72
		$url = $this->apihost."storeorder/user/".$this->Auth->User('id')."?page=1&window=50";
13762 anikendra 73
		$response = $this->make_request($url,null);
13993 anikendra 74
		// debug($response);
75
		$creditedOrders = $pendingOrders = $approvedOrders = array();
76
		$creditedAmount = $pendingAmount = $approvedAmount = 0;
13762 anikendra 77
		if(!empty($response['data'])){
13993 anikendra 78
			foreach ($response['data'] as $key => $order) {
14111 anikendra 79
				if(!empty($order['subOrders'])){
80
					foreach ($order['subOrders'] as $key => $suborder) {
81
						$suborder['storeId'] = $order['storeId'];
15035 amit.gupta 82
						if($order['storeId']!=4){
15036 amit.gupta 83
							$suborder['merchantOrderId'] = $order['merchantOrderId'];
84
						} else {
15035 amit.gupta 85
							$suborder['merchantOrderId'] = $suborder['merchantSubOrderId'];
86
						}
14700 anikendra 87
						if(!empty($order['orderTrackingUrl'])){
88
							$suborder['orderSuccessUrl'] = $order['orderTrackingUrl'];
89
						}
14111 anikendra 90
						switch($suborder['cashBackStatus']){
91
							// case 'Credited to wallet'://Credited
92
							// $creditedOrders[] = $suborder;
93
							// break;
94
							case 'Approved':
95
							$approvedOrders[] = $suborder;
96
							$approvedAmount += $suborder['cashBackAmount'];
97
							break;
98
							case 'Pending':
99
							$pendingOrders[] = $suborder;
14673 anikendra 100
							// $pendingAmount += $suborder['cashBackAmount'];
14111 anikendra 101
						}
13993 anikendra 102
					}
103
				}
104
			}
13762 anikendra 105
		}
14673 anikendra 106
		$url = $this->apihost.'pending-cashbacks/user/'.$userId;
107
		$result = $this->make_request($url,null);
108
		$pendingAmount = $result['amount'];
13993 anikendra 109
		//Get pending cashbacks
110
		$url = $this->apihost.'pending-refunds/user/'.$userId;
111
		$pendingCashbacks = $this->make_request($url,null);
112
		//Get credited cashbacks
113
		$url = $this->apihost.'refund/user/'.$userId;
14068 anikendra 114
		$creditedCashbacks = $this->make_request($url,null);
115
 
14026 anikendra 116
		if(!empty($creditedCashbacks)){
13993 anikendra 117
			foreach ($creditedCashbacks['data'] as $key => $value) {
14068 anikendra 118
				$creditedAmount += $value['userAmount'];				
119
				$data = array('subOrders.batchId'=>$value['batch']);
120
				$jsonVar = json_encode($data);
121
				$url = $this->apihost."storeorder/user/".$this->Auth->User('id')."?page=1&window=50&searchMap=$jsonVar";
122
				$creditedOrders[$value['batch']] = $this->make_request($url,null);
123
				// debug($creditedOrders);
13993 anikendra 124
			}
125
		}
14026 anikendra 126
		$storemapping = Configure::read('storemapping');
127
		$activestores = Configure::read('activestores');
13993 anikendra 128
		if(!empty($response['data'])){
14026 anikendra 129
			$this->set(compact('storemapping','activestores','pendingOrders','approvedOrders','creditedOrders','pendingCashbacks','creditedCashbacks','pendingAmount','approvedAmount','creditedAmount'));
13993 anikendra 130
		}
13762 anikendra 131
	}
132
 
15217 anikendra 133
	public function usercashbacks($userId) {		
134
		$this->layout = "innerpages";
135
		$url = $this->apihost."storeorder/user/".$userId."?page=1&window=50";
136
		$response = $this->make_request($url,null);
137
		// debug($response);
138
		$creditedOrders = $pendingOrders = $approvedOrders = array();
139
		$creditedAmount = $pendingAmount = $approvedAmount = 0;
140
		if(!empty($response['data'])){
141
			foreach ($response['data'] as $key => $order) {
142
				if(!empty($order['subOrders'])){
143
					foreach ($order['subOrders'] as $key => $suborder) {
144
						$suborder['storeId'] = $order['storeId'];
145
						if($order['storeId']!=4){
146
							$suborder['merchantOrderId'] = $order['merchantOrderId'];
147
						} else {
148
							$suborder['merchantOrderId'] = $suborder['merchantSubOrderId'];
149
						}
150
						if(!empty($order['orderTrackingUrl'])){
151
							$suborder['orderSuccessUrl'] = $order['orderTrackingUrl'];
152
						}
153
						switch($suborder['cashBackStatus']){
154
							// case 'Credited to wallet'://Credited
155
							// $creditedOrders[] = $suborder;
156
							// break;
157
							case 'Approved':
158
							$approvedOrders[] = $suborder;
159
							$approvedAmount += $suborder['cashBackAmount'];
160
							break;
161
							case 'Pending':
162
							$pendingOrders[] = $suborder;
163
							// $pendingAmount += $suborder['cashBackAmount'];
164
						}
165
					}
166
				}
167
			}
168
		}
169
		$url = $this->apihost.'pending-cashbacks/user/'.$userId;
170
		$result = $this->make_request($url,null);
171
		$pendingAmount = $result['amount'];
172
		//Get pending cashbacks
173
		$url = $this->apihost.'pending-refunds/user/'.$userId;
174
		$pendingCashbacks = $this->make_request($url,null);
175
		//Get credited cashbacks
176
		$url = $this->apihost.'refund/user/'.$userId;
177
		$creditedCashbacks = $this->make_request($url,null);
178
 
179
		if(!empty($creditedCashbacks)){
180
			foreach ($creditedCashbacks['data'] as $key => $value) {
181
				$creditedAmount += $value['userAmount'];				
182
				$data = array('subOrders.batchId'=>$value['batch']);
183
				$jsonVar = json_encode($data);
184
				$url = $this->apihost."storeorder/user/".$userId."?page=1&window=50&searchMap=$jsonVar";
185
				$creditedOrders[$value['batch']] = $this->make_request($url,null);
186
				// debug($creditedOrders);
187
			}
188
		}
189
		$storemapping = Configure::read('storemapping');
190
		$activestores = Configure::read('activestores');
191
		if(!empty($response['data'])){
192
			$this->set(compact('storemapping','activestores','pendingOrders','approvedOrders','creditedOrders','pendingCashbacks','creditedCashbacks','pendingAmount','approvedAmount','creditedAmount'));
193
		}
194
	}
195
 
13532 anikendra 196
/**
197
 * index method
198
 *
199
 * @return void
200
 */
201
	public function index() {
13591 anikendra 202
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 203
		$this->Order->recursive = 0;
204
		$this->set('orders', $this->Paginator->paginate());
205
	}
206
 
207
/**
208
 * view method
209
 *
210
 * @throws NotFoundException
211
 * @param string $id
212
 * @return void
213
 */
214
	public function view($id = null) {
13591 anikendra 215
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 216
		if (!$this->Order->exists($id)) {
217
			throw new NotFoundException(__('Invalid order'));
218
		}
219
		$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
220
		$this->set('order', $this->Order->find('first', $options));
221
	}
222
 
223
/**
224
 * add method
225
 *
226
 * @return void
227
 */
13814 anikendra 228
 
229
	public function postOrders($order=null) {
13994 anikendra 230
		// Configure::load('live');
13814 anikendra 231
		$apihost = Configure::read('pythonapihost');
232
		$url = $apihost."storeorder";
233
		if(!empty($order)) {
234
			$params = array('sourceId'=>$order['Order']['store_id'],'orderId'=>$order['Order']['id'],'subTagId'=>$order['Order']['sub_tag'],'userId'=>$order['Order']['user_id'],'rawHtml'=>$order['Order']['rawhtml'],'orderSuccessUrl'=>$order['Order']['order_url']);
235
			$jsonVar = json_encode($params);
236
			return $this->make_request($url,$jsonVar);
237
		}else{
238
			$result = array('success'=>false,'message'=>'Empty order array');
239
			return $result;
240
		}
241
	}
242
 
13532 anikendra 243
	public function add() {
14933 amit.gupta 244
		$this->log(print_r($this->request->data,1),'orders');
13532 anikendra 245
		if ($this->request->is('post')) {
14886 amit.gupta 246
			if($this->request->data['zip']){
14933 amit.gupta 247
				$this->request->data['rawhtml'] = gzuncompress(base64_decode($this->request->data['rawhtml'])); 
14886 amit.gupta 248
			}
249
			$this->log(print_r($this->request->data,1),'orders');
14315 anikendra 250
			if(empty($this->request->data['id'])) {
251
				$this->Order->create();
13633 anikendra 252
			}
15093 anikendra 253
			$this->request->data['ip'] = $_SERVER['HTTP_CF_CONNECTING_IP'];
13532 anikendra 254
			if ($this->Order->save($this->request->data)) {
14315 anikendra 255
				//$this->loadModel('PythonApi');	
256
				if(empty($this->request->data['id'])) {
257
					$id = $this->Order->getLastInsertID();
258
				}else{
259
					$id = $this->request->data['id'];
260
				}
261
				$order = $this->Order->find('first',array('conditions'=>array('id'=>$id),'recursive'=>-1));
13814 anikendra 262
				$response = $this->postOrders($order);
263
				$this->log(print_r($response,1),'orders');
264
				if(!empty($response) && $response['result']) {
14315 anikendra 265
					//if($response['result'] == 'HTML_REQUIRED' || $response['result'] == 'requireHtml') {
266
					if($response['htmlRequired'] == 1) {
13814 anikendra 267
						$this->loadModel('Rawhtml');
268
						$data = array('order_id' => $order['Order']['id'],'url' => $response['url'], 'status' => 'new');
269
						$this->Rawhtml->create();
270
						$this->Rawhtml->save($data); 
14315 anikendra 271
						//$result =array('success'=>true,'message'=>__('requireHtml'),'url' => $response['url'],'orderId' => $response['orderId']);
272
						$result =  $response;
273
						$sql = "UPDATE orders SET status = '".$response['result']."' WHERE id = ".$order['Order']['id'];
274
					}/* elseif($response['result'] == 'IGNORED') {
13814 anikendra 275
						$result =array('success'=>true,'message'=>__('IGNORED'));
276
						$sql = "UPDATE orders SET status = 'deleted' WHERE id = ".$order['Order']['id'];
277
					} elseif($response['result'] == 'PARSE_ERROR') {
278
						$result =array('success'=>true,'message'=>__('PARSE_ERROR'));
279
						$sql = "UPDATE orders SET status = 'deleted' WHERE id = ".$order['Order']['id'];
14315 anikendra 280
					} */
281
					else {
282
						$result =array('success'=>true,'message'=> $response['result']);
283
						$sql = "UPDATE orders SET status = '".$response['result']."' WHERE id = ".$order['Order']['id'];
13814 anikendra 284
					}
285
					$this->Order->query($sql);
286
				}
287
				//$result = array('success'=>true,'message'=>__('HTML_REQUIRED'),'url'=>'https://www.amazon.in/gp/css/summary/edit.html?orderID=404-7369214-6566739');
13633 anikendra 288
/*
289
				$options = array('conditions'=>array('status'=>'mapped'),'recursive'=>-1);
290
				$order = $this->Order->find('first',$options);
291
				if(!empty($orders)) {
292
					foreach($orders AS $order) {
293
						$response = $this->PythonApi->postOrders($order);
294
						if(!empty($response) && $response['result']) {
295
							$sql = "UPDATE orders SET status = 'processed' WHERE id = ".$order['Order']['id'];
296
							$this->Order->query($sql);
297
						}
298
					}
299
				}
300
*/
13532 anikendra 301
			} else {
14315 anikendra 302
				$this->log(print_r($this->Order->validationErrors,1),'orders');
13591 anikendra 303
				$result = array('success'=>false,'message'=>__('The order could not be saved. Please, try again.'));
13532 anikendra 304
			}
13591 anikendra 305
			$this->response->type('json');
306
			$this->layout = 'ajax';
307
			$this->set(array(
14315 anikendra 308
			    'result' => $response,
13591 anikendra 309
			    // 'callback' => $callback,
310
			    '_serialize' => array('result')
311
			));
312
			$this->render('/Elements/json');		
313
		}			
13532 anikendra 314
	}
315
 
316
/**
317
 * edit method
318
 *
319
 * @throws NotFoundException
320
 * @param string $id
321
 * @return void
322
 */
323
	public function edit($id = null) {
13591 anikendra 324
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 325
		if (!$this->Order->exists($id)) {
326
			throw new NotFoundException(__('Invalid order'));
327
		}
328
		if ($this->request->is(array('post', 'put'))) {
329
			if ($this->Order->save($this->request->data)) {
330
				$this->Session->setFlash(__('The order has been saved.'));
331
				return $this->redirect(array('action' => 'index'));
332
			} else {
333
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
334
			}
335
		} else {
336
			$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
337
			$this->request->data = $this->Order->find('first', $options);
338
		}
339
		$users = $this->Order->User->find('list');
340
		$stores = $this->Order->Store->find('list');
341
		$storeOrders = $this->Order->StoreOrder->find('list');
342
		$this->set(compact('users', 'stores', 'storeOrders'));
343
	}
344
 
345
/**
346
 * delete method
347
 *
348
 * @throws NotFoundException
349
 * @param string $id
350
 * @return void
351
 */
352
	public function delete($id = null) {
13591 anikendra 353
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 354
		$this->Order->id = $id;
355
		if (!$this->Order->exists()) {
356
			throw new NotFoundException(__('Invalid order'));
357
		}
358
		$this->request->onlyAllow('post', 'delete');
359
		if ($this->Order->delete()) {
360
			$this->Session->setFlash(__('The order has been deleted.'));
361
		} else {
362
			$this->Session->setFlash(__('The order could not be deleted. Please, try again.'));
363
		}
364
		return $this->redirect(array('action' => 'index'));
365
	}
366
 
367
/**
368
 * admin_index method
369
 *
370
 * @return void
371
 */
372
	public function admin_index() {
373
		$this->Order->recursive = 0;
374
		$this->set('orders', $this->Paginator->paginate());
375
	}
376
 
377
/**
378
 * admin_view method
379
 *
380
 * @throws NotFoundException
381
 * @param string $id
382
 * @return void
383
 */
384
	public function admin_view($id = null) {
385
		if (!$this->Order->exists($id)) {
386
			throw new NotFoundException(__('Invalid order'));
387
		}
388
		$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
389
		$this->set('order', $this->Order->find('first', $options));
390
	}
391
 
392
/**
393
 * admin_add method
394
 *
395
 * @return void
396
 */
397
	public function admin_add() {
398
		if ($this->request->is('post')) {
399
			$this->Order->create();
400
			if ($this->Order->save($this->request->data)) {
401
				$this->Session->setFlash(__('The order has been saved.'));
402
				return $this->redirect(array('action' => 'index'));
403
			} else {
404
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
405
			}
406
		}
407
		$users = $this->Order->User->find('list');
408
		$stores = $this->Order->Store->find('list');
409
		$storeOrders = $this->Order->StoreOrder->find('list');
410
		$this->set(compact('users', 'stores', 'storeOrders'));
411
	}
412
 
413
/**
414
 * admin_edit method
415
 *
416
 * @throws NotFoundException
417
 * @param string $id
418
 * @return void
419
 */
420
	public function admin_edit($id = null) {
421
		if (!$this->Order->exists($id)) {
422
			throw new NotFoundException(__('Invalid order'));
423
		}
424
		if ($this->request->is(array('post', 'put'))) {
425
			if ($this->Order->save($this->request->data)) {
426
				$this->Session->setFlash(__('The order has been saved.'));
427
				return $this->redirect(array('action' => 'index'));
428
			} else {
429
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
430
			}
431
		} else {
432
			$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
433
			$this->request->data = $this->Order->find('first', $options);
434
		}
435
		$users = $this->Order->User->find('list');
436
		$stores = $this->Order->Store->find('list');
437
		$storeOrders = $this->Order->StoreOrder->find('list');
438
		$this->set(compact('users', 'stores', 'storeOrders'));
439
	}
440
 
441
/**
442
 * admin_delete method
443
 *
444
 * @throws NotFoundException
445
 * @param string $id
446
 * @return void
447
 */
448
	public function admin_delete($id = null) {
449
		$this->Order->id = $id;
450
		if (!$this->Order->exists()) {
451
			throw new NotFoundException(__('Invalid order'));
452
		}
453
		$this->request->onlyAllow('post', 'delete');
454
		if ($this->Order->delete()) {
455
			$this->Session->setFlash(__('The order has been deleted.'));
456
		} else {
457
			$this->Session->setFlash(__('The order could not be deleted. Please, try again.'));
458
		}
459
		return $this->redirect(array('action' => 'index'));
14354 anikendra 460
	}
461
 
462
	public function all() {
463
		$page = $this->request->query('page');
464
		$page = isset($page)?$page:1;
14509 anikendra 465
		// $userId = $this->request->query('user_id');
466
		// if(isset($userId) && !empty($userId)){
467
		// 	$this->loadModel('User');
468
		// 	$dbuser = $this->User->findById($userId);
469
		// 	$this->Auth->login($dbuser['User']);	
470
		// }
14354 anikendra 471
		$this->layout = "innerpages";
472
		$url = $this->apihost."orders/?page=$page&window=10";
473
		$response = $this->make_request($url,null);
14509 anikendra 474
		$totalPages = $response['totalPages'];		
14354 anikendra 475
		if(!empty($response['data'])){
476
			$this->set('orders',$response['data']);
477
		}
478
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
479
		$storemapping = Configure::read('storemapping');
480
		$activestores = Configure::read('activestores');
481
		$amazonorderurl = Configure::read('amazonorderurl');
482
		$allusers = $this->Order->User->find('all',array('fields'=>array('first_name','id'),'recursive'=>-1));
483
		foreach($allusers AS $user){
484
			$users[$user['User']['id']] = $user['User']['first_name'];
485
		}
15188 anikendra 486
		$this->layout = 'admin';
14354 anikendra 487
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl','users'));
488
	}
489
}