Subversion Repositories SmartDukaan

Rev

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