Subversion Repositories SmartDukaan

Rev

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