Subversion Repositories SmartDukaan

Rev

Rev 19676 | Rev 19785 | 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
 
17287 amit.gupta 24
 
25
	public function getOrderFilters($type='user') {
26
		$cachekey = 'orderfilters-'.$type;
27
		$filters = Cache::read($cachekey);
28
		if(empty($filters)) {
29
			$url = $this->apihost."orderfilters/?type=".$type;
30
			$response = $this->make_request($url, null);
31
			echo $response;
32
			if(!empty($response)){
33
				$filters = $response;
34
				Cache::write($cachekey,$filters);
35
			}
36
		}
37
        return $filters;
38
	}
39
 
13816 anikendra 40
	public function mine() {
15824 anikendra 41
		$type = $this->request->query('type');
13816 anikendra 42
		$page = $this->request->query('page');
43
		$page = isset($page)?$page:1;
13682 anikendra 44
		$userId = $this->request->query('user_id');
45
		if(isset($userId) && !empty($userId)){
46
			$this->loadModel('User');
47
			$dbuser = $this->User->findById($userId);
48
			$this->Auth->login($dbuser['User']);	
49
		}
13672 anikendra 50
		$this->layout = "innerpages";
13815 anikendra 51
		$url = $this->apihost."storeorder/user/".$this->Auth->User('id')."?page=$page&window=10";
15824 anikendra 52
		if(isset($type) && !empty($type)) {
53
			$url .= '&type='.$type;
54
		}
13672 anikendra 55
		$response = $this->make_request($url,null);
13815 anikendra 56
		$totalPages = $response['totalPages'];
13672 anikendra 57
		if(!empty($response['data'])){
58
			$this->set('orders',$response['data']);
59
		}
13752 anikendra 60
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
13944 anikendra 61
		$storemapping = Configure::read('storemapping');
62
		$activestores = Configure::read('activestores');
14224 anikendra 63
		$amazonorderurl = Configure::read('amazonorderurl');
64
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl'));
13672 anikendra 65
	}
66
 
15217 anikendra 67
	public function by($userId) {
68
		$page = $this->request->query('page');
69
		$page = isset($page)?$page:1;		
70
		$this->layout = "innerpages";
71
		$url = $this->apihost."storeorder/user/".$userId."?page=$page&window=10";
72
		$response = $this->make_request($url,null);
73
		$totalPages = $response['totalPages'];
74
		if(!empty($response['data'])){
75
			$this->set('orders',$response['data']);
76
		}
77
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
78
		$storemapping = Configure::read('storemapping');
79
		$activestores = Configure::read('activestores');
80
		$amazonorderurl = Configure::read('amazonorderurl');
81
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl'));
82
	}
83
 
13762 anikendra 84
	public function pendingcashbacks() {
85
		$userId = $this->request->query('user_id');
86
		if(isset($userId) && !empty($userId)){
87
			$this->loadModel('User');
88
			$dbuser = $this->User->findById($userId);
89
			$this->Auth->login($dbuser['User']);	
90
		}
91
		$this->layout = "innerpages";
17724 amit.gupta 92
		$url = $this->apihost."storeorder/user/".$userId."?page=1&window=50&searchMap=%7B\"subOrders.cashBackStatus\"%3A%20%7B\"%24in\"%3A%20%5B\"Approved\"%2C%20\"Pending\"%5D%7D%7D";
13762 anikendra 93
		$response = $this->make_request($url,null);
13993 anikendra 94
		// debug($response);
95
		$creditedOrders = $pendingOrders = $approvedOrders = array();
96
		$creditedAmount = $pendingAmount = $approvedAmount = 0;
13762 anikendra 97
		if(!empty($response['data'])){
13993 anikendra 98
			foreach ($response['data'] as $key => $order) {
14111 anikendra 99
				if(!empty($order['subOrders'])){
100
					foreach ($order['subOrders'] as $key => $suborder) {
101
						$suborder['storeId'] = $order['storeId'];
15035 amit.gupta 102
						if($order['storeId']!=4){
15036 amit.gupta 103
							$suborder['merchantOrderId'] = $order['merchantOrderId'];
104
						} else {
15035 amit.gupta 105
							$suborder['merchantOrderId'] = $suborder['merchantSubOrderId'];
106
						}
14700 anikendra 107
						if(!empty($order['orderTrackingUrl'])){
108
							$suborder['orderSuccessUrl'] = $order['orderTrackingUrl'];
109
						}
14111 anikendra 110
						switch($suborder['cashBackStatus']){
111
							case 'Approved':
112
							$approvedOrders[] = $suborder;
113
							$approvedAmount += $suborder['cashBackAmount'];
114
							break;
115
							case 'Pending':
116
							$pendingOrders[] = $suborder;
117
						}
13993 anikendra 118
					}
119
				}
120
			}
13762 anikendra 121
		}
14673 anikendra 122
		$url = $this->apihost.'pending-cashbacks/user/'.$userId;
123
		$result = $this->make_request($url,null);
124
		$pendingAmount = $result['amount'];
13993 anikendra 125
		//Get pending cashbacks
126
		$url = $this->apihost.'pending-refunds/user/'.$userId;
127
		$pendingCashbacks = $this->make_request($url,null);
128
		//Get credited cashbacks
129
		$url = $this->apihost.'refund/user/'.$userId;
14068 anikendra 130
		$creditedCashbacks = $this->make_request($url,null);
19499 naman 131
 
132
		$totalcreditedcashback = 0;
133
		if(!empty($creditedCashbacks)){
134
			$totalcreditedcashback = $creditedCashbacks['credited'];
135
		}
136
 
16893 naman 137
		$creditKeyArray = array();
138
		$creditValueArray = array();
16907 naman 139
		$total_credited_amount = 0;
14026 anikendra 140
		if(!empty($creditedCashbacks)){
13993 anikendra 141
			foreach ($creditedCashbacks['data'] as $key => $value) {
14068 anikendra 142
				$creditedAmount += $value['userAmount'];				
143
				$data = array('subOrders.batchId'=>$value['batch']);
144
				$jsonVar = json_encode($data);
145
				$url = $this->apihost."storeorder/user/".$this->Auth->User('id')."?page=1&window=50&searchMap=$jsonVar";
146
				$creditedOrders[$value['batch']] = $this->make_request($url,null);
16907 naman 147
				$total_credited_amount =$total_credited_amount + $value['userAmount'];
17109 naman 148
				if($value['type']== 'Order')
149
				{
150
					$creditValueArray['amount'] = $value['userAmount'];
151
					$creditValueArray['type'] = $value['type'];
152
					$creditValueArray['fortbatchid'] = $value['batch'];
153
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
19552 naman 154
					$creditValueArray['description'] = '';
17109 naman 155
					// $creditKeyArray[date('Y-m-d',strtotime($value['timestamp']))] = $creditValueArray;
19552 naman 156
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
17109 naman 157
				}
19499 naman 158
				elseif($value['type']== 'Refund'){
159
					$creditValueArray['amount'] = $value['userAmount'];
160
					$creditValueArray['type'] = $value['type'];
161
					$creditValueArray['fortbatchid'] = $value['batch'];
162
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
163
					$creditValueArray['description'] = $value['description'];
19552 naman 164
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
19499 naman 165
 
166
				}
167
				elseif($value['type']== 'Adjustment'){
168
					$creditValueArray['amount'] = $value['userAmount'];
169
					$creditValueArray['type'] = $value['type'];
170
					$creditValueArray['fortbatchid'] = $value['batch'];
171
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
172
					$creditValueArray['description'] = $value['description'];
19552 naman 173
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
19499 naman 174
				}
13993 anikendra 175
			}
176
		}
14026 anikendra 177
		$storemapping = Configure::read('storemapping');
178
		$activestores = Configure::read('activestores');
16628 anikendra 179
		//App related cashbacks
180
		$this->loadModel('UserAppCashback');
181
		$this->loadModel('UserAppInstall');
182
		//Compute last two fortnight ids
183
		$fortnightIds = array();
184
		if(date('d',time())<=15){
16784 anikendra 185
			$fortnightIds[] = 2*(date('m',time())-1)-1;
16629 anikendra 186
			$fortnightIds[] = 2*(date('m',time())-1);
16628 anikendra 187
		}else{
16784 anikendra 188
			$fortnightIds[] = 2*(date('m',time())-1);
16628 anikendra 189
			$fortnightIds[] = 2*(date('m',time())-1)+1;
190
		}
191
		$cashBacks = array();
16893 naman 192
 
193
		// Approved Start
194
 
16840 naman 195
		$url = $this->apihost.'appUserCashBack/'.$userId.'/Approved';
196
		$getapproved = $this->make_request($url,null);
197
		$fortnight = array();
198
		$fortnight_amount = array();
199
		$counter = 0;
200
		$total_approved_amount = 0;
201
		$current_date =  date("Y");
202
		foreach ($getapproved["UserAppCashBack"] as $key => $value) {
203
			 $fortnight[$counter] = $value["fortnightOfYear"];
204
			 $fortnight_amount[$counter] = $value["amount"];
205
			 $total_approved_amount += $value["amount"];
206
			 $counter++;
207
		}
208
		$approvedFortnight = array();
209
		for($i=0; $i<count($fortnight); $i++){
18172 manish.sha 210
			$url = $this->apihost.'appUserBatchDrillDown/'.$userId.'/'.$getapproved["UserAppCashBack"][$i]['fortnightOfYear'].'/'.$getapproved["UserAppCashBack"][$i]['yearVal'];
16983 naman 211
			$approvedFortnight[$i] = $this->make_request($url,null);
16840 naman 212
		// $url = $this->apihost.'appUserBatchDrillDown/1/16/2015';
213
		// $approvedFortnight[] = $this->make_request($url,null);
214
		}
16983 naman 215
		// debug($approvedFortnight);
16840 naman 216
		$this->set(compact('fortnight','total_approved_amount','fortnight_amount','approvedFortnight'));		
16893 naman 217
	// Approved End	
16840 naman 218
 
16893 naman 219
	// App Credit Start
220
		$creditedFortnight = array();
221
		$url = $this->apihost.'appUserCashBack/'.$userId.'/Credited';
222
		$getcredited = $this->make_request($url,null);
17110 naman 223
		// debug($getcredited);
16893 naman 224
		foreach ($getcredited['UserAppCashBack'] as $key => $value) {
16840 naman 225
 
17109 naman 226
 
227
 
16893 naman 228
			$url = $this->apihost.'appUserBatchDrillDown/'.$userId.'/'.$value['fortnightOfYear'].'/'.$value['yearVal'];
229
			$creditedFortnight[$value['fortnightOfYear']] = $this->make_request($url,null);
230
 
231
			$creditValueArray['amount'] = $value['amount'];
17104 anikendra 232
			// $total_credited_amount = $total_credited_amount + $value['amount'];
16893 naman 233
			$creditValueArray['type'] = 'App';
234
			$creditValueArray['fortbatchid'] = $value['fortnightOfYear'];
17109 naman 235
			$creditValueArray['creditedDate'] = $value['creditedDate'];
19552 naman 236
			$creditValueArray['description'] = '';
237
			$creditKeyArray[$value['batchCreditId'].'App'] = $creditValueArray;
17109 naman 238
			// echo "total credit",$total_credited_amount;
16893 naman 239
			// echo $url;
240
		}
241
 
242
		ksort($creditKeyArray);
16907 naman 243
		$this->set(compact('getcredited','creditedFortnight','creditKeyArray','total_credited_amount'));
16893 naman 244
		// debug($creditedFortnight);
245
	// App Credit End
246
 
247
 
16628 anikendra 248
		foreach ($fortnightIds AS $fortnightId){
16712 naman 249
			$appInstalls = array();
16628 anikendra 250
			$options = array('conditions'=>array('fortnightOfYear'=>$fortnightId,'user_id'=>$this->Auth->User('id')),'fields'=>array('status','amount'));
251
			$temp = $this->UserAppCashback->find('first',$options);
16681 anikendra 252
			if(isset($temp) && !empty($temp)){
253
				$cashBacks[$temp['UserAppCashback']['status']]['amount'] = $temp['UserAppCashback']['amount'];
16712 naman 254
				$cashBacks[$temp['UserAppCashback']['status']]['fortnightOfYear'] = $fortnightId;
255
				// debug($fortnightId);
16681 anikendra 256
				$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');
257
				$installs = $this->UserAppInstall->find('all',$options);			
258
				if(!empty($installs)){
259
					foreach ($installs as $key => $value) {
260
						$appInstalls[$value['UserAppInstall']['transaction_date']] = $value[0];					
261
					}
262
					$cashBacks[$temp['UserAppCashback']['status']]['installs'] = $appInstalls;
16628 anikendra 263
				}
264
			}
265
		}
19676 naman 266
 
267
// 		offerresponse start
268
 
269
		$cachekey = 'target-'.$userId;
270
		$getoffer = Cache::read($cachekey,'target');
271
 
272
		$offerresponse = "";
273
		$getcashback = 0;
274
		if($getoffer === false){
19677 naman 275
			$offerurl = $this->apihost."getOfferForUser/?user_id=".$userId;
19676 naman 276
			$offerresponse = $this->make_request($offerurl,null);
277
			Cache::write($cachekey , $offerresponse ,'target');
278
			if(empty($offerresponse)){
279
				$offerresponse = "";
280
			}
281
		}else{
282
			if(!empty($getoffer)){
283
				$offerresponse  = $getoffer;
284
 
285
				}
286
		}
287
 
288
 
289
		if(!empty($offerresponse)){
290
			$totalval = $offerresponse['delivered_order_value'] + $offerresponse['pending_order_value'];
291
 
292
			if($totalval< $offerresponse['target1']){
293
				$getcashback = 0;
294
			}
295
			else if($totalval< $offerresponse['target2']){
296
				if($offerresponse['maxCashBack']< intval(($totalval*$offerresponse['target1_cash_back_percetage'])/100)){
297
					$getcashback = $offerresponse['maxCashBack'];
298
				}
299
				else{
300
					$getcashback = intval(($totalval*$offerresponse['target1_cash_back_percetage'])/100);
301
				}
302
 
303
			}
304
			else{
305
				if($offerresponse['maxCashBack']< intval(($totalval*$offerresponse['target2_cash_back_percetage'])/100)){
306
					$getcashback = $offerresponse['maxCashBack'];
307
				}
308
				else{
309
					$getcashback = intval(($totalval*$offerresponse['target2_cash_back_percetage'])/100);
310
				}
311
 
312
			}
313
		}
314
// 		offerresponse end
315
 
19667 naman 316
		$targetuser = Configure::read('targetuser'); 
19676 naman 317
		$this->set(compact('getcashback','targetuser','userId','storemapping','activestores','pendingOrders','approvedOrders','creditedOrders','pendingCashbacks','creditedCashbacks','pendingAmount','approvedAmount','creditedAmount','cashBacks'));
13762 anikendra 318
	}
319
 
16840 naman 320
	public function getAppByDate($date) {
321
		$url = $this->apihost.'appUserBatchDateDrillDown/1/'.$date;
322
		$getApp = $this->make_request($url,null);
323
		echo $getApp;
324
	}
325
 
17354 naman 326
	public function usercashbacks($userId) {	
327
		$this->set('byUser',$userId);
15217 anikendra 328
		$this->layout = "innerpages";
17724 amit.gupta 329
		$url = $this->apihost."storeorder/user/".$userId."?page=1&window=50&searchMap=%7B\"subOrders.cashBackStatus\"%3A%20%7B\"%24in\"%3A%20%5B\"Approved\"%2C%20\"Pending\"%5D%7D%7D";
15217 anikendra 330
		$response = $this->make_request($url,null);
331
		// debug($response);
332
		$creditedOrders = $pendingOrders = $approvedOrders = array();
333
		$creditedAmount = $pendingAmount = $approvedAmount = 0;
17724 amit.gupta 334
		echo $response['data'];
15217 anikendra 335
		if(!empty($response['data'])){
336
			foreach ($response['data'] as $key => $order) {
337
				if(!empty($order['subOrders'])){
338
					foreach ($order['subOrders'] as $key => $suborder) {
339
						$suborder['storeId'] = $order['storeId'];
340
						if($order['storeId']!=4){
341
							$suborder['merchantOrderId'] = $order['merchantOrderId'];
342
						} else {
343
							$suborder['merchantOrderId'] = $suborder['merchantSubOrderId'];
344
						}
345
						if(!empty($order['orderTrackingUrl'])){
346
							$suborder['orderSuccessUrl'] = $order['orderTrackingUrl'];
347
						}
17724 amit.gupta 348
						$suborder['cashBackStatus'];
15217 anikendra 349
						switch($suborder['cashBackStatus']){
350
							// case 'Credited to wallet'://Credited
351
							// $creditedOrders[] = $suborder;
352
							// break;
353
							case 'Approved':
354
							$approvedOrders[] = $suborder;
355
							$approvedAmount += $suborder['cashBackAmount'];
356
							break;
357
							case 'Pending':
358
							$pendingOrders[] = $suborder;
359
							// $pendingAmount += $suborder['cashBackAmount'];
360
						}
361
					}
362
				}
363
			}
364
		}
365
		$url = $this->apihost.'pending-cashbacks/user/'.$userId;
366
		$result = $this->make_request($url,null);
367
		$pendingAmount = $result['amount'];
368
		//Get pending cashbacks
369
		$url = $this->apihost.'pending-refunds/user/'.$userId;
370
		$pendingCashbacks = $this->make_request($url,null);
371
		//Get credited cashbacks
372
		$url = $this->apihost.'refund/user/'.$userId;
373
		$creditedCashbacks = $this->make_request($url,null);
19499 naman 374
 
375
		$totalcreditedcashback = 0;
376
		if(!empty($creditedCashbacks)){
377
			$totalcreditedcashback = $creditedCashbacks['credited'];
378
		}
379
 
17201 naman 380
		$creditKeyArray = array();
381
		$creditValueArray = array();
382
		$total_credited_amount = 0;
15217 anikendra 383
		if(!empty($creditedCashbacks)){
384
			foreach ($creditedCashbacks['data'] as $key => $value) {
385
				$creditedAmount += $value['userAmount'];				
386
				$data = array('subOrders.batchId'=>$value['batch']);
387
				$jsonVar = json_encode($data);
17459 amit.gupta 388
				$url = $this->apihost."storeorder/user/".$userId."?page=1&window=50&searchMap=$jsonVar";
15217 anikendra 389
				$creditedOrders[$value['batch']] = $this->make_request($url,null);
17201 naman 390
				$total_credited_amount =$total_credited_amount + $value['userAmount'];
391
				if($value['type']== 'Order')
392
				{
393
					$creditValueArray['amount'] = $value['userAmount'];
394
					$creditValueArray['type'] = $value['type'];
395
					$creditValueArray['fortbatchid'] = $value['batch'];
396
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
397
					// $creditKeyArray[date('Y-m-d',strtotime($value['timestamp']))] = $creditValueArray;
19552 naman 398
					$creditValueArray['description'] = '';
399
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
17201 naman 400
				}
19499 naman 401
				elseif($value['type']== 'Refund'){
402
					$creditValueArray['amount'] = $value['userAmount'];
403
					$creditValueArray['type'] = $value['type'];
404
					$creditValueArray['fortbatchid'] = $value['batch'];
405
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
406
					$creditValueArray['description'] = $value['description'];
19552 naman 407
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
19499 naman 408
 
409
				}
410
				elseif($value['type']== 'Adjustment'){
411
					$creditValueArray['amount'] = $value['userAmount'];
412
					$creditValueArray['type'] = $value['type'];
413
					$creditValueArray['fortbatchid'] = $value['batch'];
414
					$creditValueArray['creditedDate'] = date('Y-m-d',strtotime($value['timestamp']));
415
					$creditValueArray['description'] = $value['description'];
19552 naman 416
					$creditKeyArray[$value['batch'].$value['type']] = $creditValueArray;
19499 naman 417
				}
17201 naman 418
 
15217 anikendra 419
			}
420
		}
17201 naman 421
 
15217 anikendra 422
		$storemapping = Configure::read('storemapping');
423
		$activestores = Configure::read('activestores');
17459 amit.gupta 424
		//App related cashbacks
425
		$this->loadModel('UserAppCashback');
426
		$this->loadModel('UserAppInstall');
427
		//Compute last two fortnight ids
428
		$fortnightIds = array();
429
		if(date('d',time())<=15){
430
			$fortnightIds[] = 2*(date('m',time())-1)-1;
431
			$fortnightIds[] = 2*(date('m',time())-1);
432
		}else{
433
			$fortnightIds[] = 2*(date('m',time())-1);
434
			$fortnightIds[] = 2*(date('m',time())-1)+1;
17201 naman 435
		}
17459 amit.gupta 436
		$cashBacks = array();
17354 naman 437
 
438
		// Approved Start
439
 
440
		$url = $this->apihost.'appUserCashBack/'.$userId.'/Approved';
441
		$getapproved = $this->make_request($url,null);
442
		$fortnight = array();
443
		$fortnight_amount = array();
444
		$counter = 0;
445
		$total_approved_amount = 0;
446
		$current_date =  date("Y");
447
		foreach ($getapproved["UserAppCashBack"] as $key => $value) {
448
			 $fortnight[$counter] = $value["fortnightOfYear"];
449
			 $fortnight_amount[$counter] = $value["amount"];
450
			 $total_approved_amount += $value["amount"];
451
			 $counter++;
452
		}
453
		$approvedFortnight = array();
454
		for($i=0; $i<count($fortnight); $i++){
18172 manish.sha 455
			$url = $this->apihost.'appUserBatchDrillDown/'.$userId.'/'.$getapproved["UserAppCashBack"][$i]['fortnightOfYear'].'/'.$getapproved["UserAppCashBack"][$i]['yearVal'];
17354 naman 456
			$approvedFortnight[$i] = $this->make_request($url,null);
457
		// $url = $this->apihost.'appUserBatchDrillDown/1/16/2015';
458
		// $approvedFortnight[] = $this->make_request($url,null);
459
		}
460
		// debug($approvedFortnight);
461
		$this->set(compact('fortnight','total_approved_amount','fortnight_amount','approvedFortnight'));		
462
	// Approved End	
463
 
17459 amit.gupta 464
	// App Credit Start
465
		$creditedFortnight = array();
466
		$url = $this->apihost.'appUserCashBack/'.$userId.'/Credited';
467
		$getcredited = $this->make_request($url,null);
468
		// debug($getcredited);
469
		foreach ($getcredited['UserAppCashBack'] as $key => $value) {
470
 
471
 
472
 
473
			$url = $this->apihost.'appUserBatchDrillDown/'.$userId.'/'.$value['fortnightOfYear'].'/'.$value['yearVal'];
474
			$creditedFortnight[$value['fortnightOfYear']] = $this->make_request($url,null);
475
 
476
			$creditValueArray['amount'] = $value['amount'];
477
			// $total_credited_amount = $total_credited_amount + $value['amount'];
478
			$creditValueArray['type'] = 'App';
479
			$creditValueArray['fortbatchid'] = $value['fortnightOfYear'];
480
			$creditValueArray['creditedDate'] = $value['creditedDate'];
19552 naman 481
			$creditValueArray['description'] = '';
482
			$creditKeyArray[$value['batchCreditId'].'App'] = $creditValueArray;
17459 amit.gupta 483
			// echo "total credit",$total_credited_amount;
484
			// echo $url;
15217 anikendra 485
		}
17459 amit.gupta 486
 
487
		ksort($creditKeyArray);
17656 amit.gupta 488
		$this->set(compact('getcredited','creditedFortnight','creditKeyArray','total_credited_amount', 'creditedOrders', 'pendingAmount', 'pendingOrders','approvedAmount', 'approvedOrders'));
17459 amit.gupta 489
 
15217 anikendra 490
	}
491
 
15227 anikendra 492
/*
13532 anikendra 493
	public function index() {
13591 anikendra 494
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 495
		$this->Order->recursive = 0;
496
		$this->set('orders', $this->Paginator->paginate());
497
	}
498
 
15227 anikendra 499
 
13532 anikendra 500
	public function view($id = null) {
13591 anikendra 501
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 502
		if (!$this->Order->exists($id)) {
503
			throw new NotFoundException(__('Invalid order'));
504
		}
505
		$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
506
		$this->set('order', $this->Order->find('first', $options));
507
	}
15227 anikendra 508
*/
509
 
13532 anikendra 510
/**
511
 * add method
512
 *
513
 * @return void
514
 */
13814 anikendra 515
 
516
	public function postOrders($order=null) {
13994 anikendra 517
		// Configure::load('live');
13814 anikendra 518
		$apihost = Configure::read('pythonapihost');
519
		$url = $apihost."storeorder";
520
		if(!empty($order)) {
521
			$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']);
522
			$jsonVar = json_encode($params);
523
			return $this->make_request($url,$jsonVar);
524
		}else{
525
			$result = array('success'=>false,'message'=>'Empty order array');
526
			return $result;
527
		}
528
	}
529
 
13532 anikendra 530
	public function add() {
14933 amit.gupta 531
		$this->log(print_r($this->request->data,1),'orders');
13532 anikendra 532
		if ($this->request->is('post')) {
14886 amit.gupta 533
			if($this->request->data['zip']){
14933 amit.gupta 534
				$this->request->data['rawhtml'] = gzuncompress(base64_decode($this->request->data['rawhtml'])); 
14886 amit.gupta 535
			}
536
			$this->log(print_r($this->request->data,1),'orders');
14315 anikendra 537
			if(empty($this->request->data['id'])) {
538
				$this->Order->create();
13633 anikendra 539
			}
15093 anikendra 540
			$this->request->data['ip'] = $_SERVER['HTTP_CF_CONNECTING_IP'];
13532 anikendra 541
			if ($this->Order->save($this->request->data)) {
14315 anikendra 542
				//$this->loadModel('PythonApi');	
543
				if(empty($this->request->data['id'])) {
544
					$id = $this->Order->getLastInsertID();
545
				}else{
546
					$id = $this->request->data['id'];
547
				}
548
				$order = $this->Order->find('first',array('conditions'=>array('id'=>$id),'recursive'=>-1));
13814 anikendra 549
				$response = $this->postOrders($order);
550
				$this->log(print_r($response,1),'orders');
551
				if(!empty($response) && $response['result']) {
14315 anikendra 552
					//if($response['result'] == 'HTML_REQUIRED' || $response['result'] == 'requireHtml') {
553
					if($response['htmlRequired'] == 1) {
13814 anikendra 554
						$this->loadModel('Rawhtml');
555
						$data = array('order_id' => $order['Order']['id'],'url' => $response['url'], 'status' => 'new');
556
						$this->Rawhtml->create();
557
						$this->Rawhtml->save($data); 
14315 anikendra 558
						//$result =array('success'=>true,'message'=>__('requireHtml'),'url' => $response['url'],'orderId' => $response['orderId']);
559
						$result =  $response;
560
						$sql = "UPDATE orders SET status = '".$response['result']."' WHERE id = ".$order['Order']['id'];
561
					}/* elseif($response['result'] == 'IGNORED') {
13814 anikendra 562
						$result =array('success'=>true,'message'=>__('IGNORED'));
563
						$sql = "UPDATE orders SET status = 'deleted' WHERE id = ".$order['Order']['id'];
564
					} elseif($response['result'] == 'PARSE_ERROR') {
565
						$result =array('success'=>true,'message'=>__('PARSE_ERROR'));
566
						$sql = "UPDATE orders SET status = 'deleted' WHERE id = ".$order['Order']['id'];
14315 anikendra 567
					} */
568
					else {
569
						$result =array('success'=>true,'message'=> $response['result']);
570
						$sql = "UPDATE orders SET status = '".$response['result']."' WHERE id = ".$order['Order']['id'];
13814 anikendra 571
					}
572
					$this->Order->query($sql);
573
				}
574
				//$result = array('success'=>true,'message'=>__('HTML_REQUIRED'),'url'=>'https://www.amazon.in/gp/css/summary/edit.html?orderID=404-7369214-6566739');
13633 anikendra 575
/*
576
				$options = array('conditions'=>array('status'=>'mapped'),'recursive'=>-1);
577
				$order = $this->Order->find('first',$options);
578
				if(!empty($orders)) {
579
					foreach($orders AS $order) {
580
						$response = $this->PythonApi->postOrders($order);
581
						if(!empty($response) && $response['result']) {
582
							$sql = "UPDATE orders SET status = 'processed' WHERE id = ".$order['Order']['id'];
583
							$this->Order->query($sql);
584
						}
585
					}
586
				}
587
*/
13532 anikendra 588
			} else {
14315 anikendra 589
				$this->log(print_r($this->Order->validationErrors,1),'orders');
13591 anikendra 590
				$result = array('success'=>false,'message'=>__('The order could not be saved. Please, try again.'));
13532 anikendra 591
			}
13591 anikendra 592
			$this->response->type('json');
593
			$this->layout = 'ajax';
594
			$this->set(array(
14315 anikendra 595
			    'result' => $response,
13591 anikendra 596
			    // 'callback' => $callback,
597
			    '_serialize' => array('result')
598
			));
599
			$this->render('/Elements/json');		
600
		}			
13532 anikendra 601
	}
602
 
15227 anikendra 603
/*
604
 
13532 anikendra 605
	public function edit($id = null) {
13591 anikendra 606
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 607
		if (!$this->Order->exists($id)) {
608
			throw new NotFoundException(__('Invalid order'));
609
		}
610
		if ($this->request->is(array('post', 'put'))) {
611
			if ($this->Order->save($this->request->data)) {
612
				$this->Session->setFlash(__('The order has been saved.'));
613
				return $this->redirect(array('action' => 'index'));
614
			} else {
615
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
616
			}
617
		} else {
618
			$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
619
			$this->request->data = $this->Order->find('first', $options);
620
		}
621
		$users = $this->Order->User->find('list');
622
		$stores = $this->Order->Store->find('list');
623
		$storeOrders = $this->Order->StoreOrder->find('list');
624
		$this->set(compact('users', 'stores', 'storeOrders'));
625
	}
626
 
15227 anikendra 627
 
13532 anikendra 628
	public function delete($id = null) {
13591 anikendra 629
		throw new NotFoundException(__('Access Denied'));
13532 anikendra 630
		$this->Order->id = $id;
631
		if (!$this->Order->exists()) {
632
			throw new NotFoundException(__('Invalid order'));
633
		}
634
		$this->request->onlyAllow('post', 'delete');
635
		if ($this->Order->delete()) {
636
			$this->Session->setFlash(__('The order has been deleted.'));
637
		} else {
638
			$this->Session->setFlash(__('The order could not be deleted. Please, try again.'));
639
		}
640
		return $this->redirect(array('action' => 'index'));
641
	}
15227 anikendra 642
*/
13532 anikendra 643
 
644
/**
645
 * admin_index method
646
 *
647
 * @return void
648
 */
649
	public function admin_index() {
15227 anikendra 650
		$this->checkAcl();
13532 anikendra 651
		$this->Order->recursive = 0;
652
		$this->set('orders', $this->Paginator->paginate());
653
	}
654
 
655
/**
656
 * admin_view method
657
 *
658
 * @throws NotFoundException
659
 * @param string $id
660
 * @return void
661
 */
662
	public function admin_view($id = null) {
15227 anikendra 663
		$this->checkAcl();
13532 anikendra 664
		if (!$this->Order->exists($id)) {
665
			throw new NotFoundException(__('Invalid order'));
666
		}
667
		$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
668
		$this->set('order', $this->Order->find('first', $options));
669
	}
670
 
671
/**
672
 * admin_add method
673
 *
674
 * @return void
675
 */
676
	public function admin_add() {
15227 anikendra 677
		$this->checkAcl();
13532 anikendra 678
		if ($this->request->is('post')) {
679
			$this->Order->create();
680
			if ($this->Order->save($this->request->data)) {
681
				$this->Session->setFlash(__('The order has been saved.'));
682
				return $this->redirect(array('action' => 'index'));
683
			} else {
684
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
685
			}
686
		}
687
		$users = $this->Order->User->find('list');
688
		$stores = $this->Order->Store->find('list');
689
		$storeOrders = $this->Order->StoreOrder->find('list');
690
		$this->set(compact('users', 'stores', 'storeOrders'));
691
	}
692
 
693
/**
694
 * admin_edit method
695
 *
696
 * @throws NotFoundException
697
 * @param string $id
698
 * @return void
699
 */
700
	public function admin_edit($id = null) {
15227 anikendra 701
		$this->checkAcl();
13532 anikendra 702
		if (!$this->Order->exists($id)) {
703
			throw new NotFoundException(__('Invalid order'));
704
		}
705
		if ($this->request->is(array('post', 'put'))) {
706
			if ($this->Order->save($this->request->data)) {
707
				$this->Session->setFlash(__('The order has been saved.'));
708
				return $this->redirect(array('action' => 'index'));
709
			} else {
710
				$this->Session->setFlash(__('The order could not be saved. Please, try again.'));
711
			}
712
		} else {
713
			$options = array('conditions' => array('Order.' . $this->Order->primaryKey => $id));
714
			$this->request->data = $this->Order->find('first', $options);
715
		}
716
		$users = $this->Order->User->find('list');
717
		$stores = $this->Order->Store->find('list');
718
		$storeOrders = $this->Order->StoreOrder->find('list');
719
		$this->set(compact('users', 'stores', 'storeOrders'));
720
	}
721
 
722
/**
723
 * admin_delete method
724
 *
725
 * @throws NotFoundException
726
 * @param string $id
727
 * @return void
728
 */
729
	public function admin_delete($id = null) {
15227 anikendra 730
		$this->checkAcl();
13532 anikendra 731
		$this->Order->id = $id;
732
		if (!$this->Order->exists()) {
733
			throw new NotFoundException(__('Invalid order'));
734
		}
735
		$this->request->onlyAllow('post', 'delete');
736
		if ($this->Order->delete()) {
737
			$this->Session->setFlash(__('The order has been deleted.'));
738
		} else {
739
			$this->Session->setFlash(__('The order could not be deleted. Please, try again.'));
740
		}
741
		return $this->redirect(array('action' => 'index'));
14354 anikendra 742
	}
743
 
744
	public function all() {
17287 amit.gupta 745
		$orderFilters = $this->getOrderFilters("monitor");
14354 anikendra 746
		$page = $this->request->query('page');
17287 amit.gupta 747
		$filter = $this->request->query('filter');
14354 anikendra 748
		$page = isset($page)?$page:1;
14509 anikendra 749
		// $userId = $this->request->query('user_id');
750
		// if(isset($userId) && !empty($userId)){
751
		// 	$this->loadModel('User');
752
		// 	$dbuser = $this->User->findById($userId);
753
		// 	$this->Auth->login($dbuser['User']);	
754
		// }
14354 anikendra 755
		$this->layout = "innerpages";
17287 amit.gupta 756
		$url = $this->apihost."orders/?page=$page&window=20";
757
		if (!empty($filter)) $url .= "&filter=".$filter."&filtertype=monitor";
14354 anikendra 758
		$response = $this->make_request($url,null);
14509 anikendra 759
		$totalPages = $response['totalPages'];		
14354 anikendra 760
		if(!empty($response['data'])){
761
			$this->set('orders',$response['data']);
762
		}
763
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
764
		$storemapping = Configure::read('storemapping');
765
		$activestores = Configure::read('activestores');
766
		$amazonorderurl = Configure::read('amazonorderurl');
767
		$allusers = $this->Order->User->find('all',array('fields'=>array('first_name','id'),'recursive'=>-1));
768
		foreach($allusers AS $user){
769
			$users[$user['User']['id']] = $user['User']['first_name'];
770
		}
15188 anikendra 771
		$this->layout = 'admin';
17287 amit.gupta 772
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl','users', 'orderFilters', 'type'));
14354 anikendra 773
	}
17290 amit.gupta 774
 
775
	public function monitor() {
776
		$orderFilters = $this->getOrderFilters("monitor");
777
		$page = $this->request->query('page');
778
		$filter = $this->request->query('filter');
17337 amit.gupta 779
		if(!empty($this->request->query('requiredetail'))){
780
				$orderId=$this->request->query('requiredetail');
781
		}
17290 amit.gupta 782
		$page = isset($page)?$page:1;
783
		$this->layout = "innerpages";
784
		$url = $this->apihost."orders/?page=$page&window=20";
17339 amit.gupta 785
		$apihost = 'http://104.200.25.40:8057/';
17290 amit.gupta 786
		if (!empty($filter)) $url .= "&filter=".$filter."&filtertype=monitor";
787
		$response = $this->make_request($url,null);
788
		$totalPages = $response['totalPages'];		
789
		if(!empty($response['data'])){
790
			$this->set('orders',$response['data']);
791
		}
792
		$ignoredFields = array('imgUrl','status','productTitle','estimatedDeliveryDate','productCode','merchantSubOrderId','productUrl','closed','tracingkUrl','detailedStatus');
793
		$storemapping = Configure::read('storemapping');
794
		$activestores = Configure::read('activestores');
795
		$amazonorderurl = Configure::read('amazonorderurl');
796
		$allusers = $this->Order->User->find('all',array('fields'=>array('first_name','id'),'recursive'=>-1));
797
		foreach($allusers AS $user){
798
			$users[$user['User']['id']] = $user['User']['first_name'];
799
		}
800
		$this->layout = 'admin';
17337 amit.gupta 801
		$this->set(compact('ignoredFields','page','totalPages','userId','activestores','storemapping','amazonorderurl','users', 'orderFilters', 'filter', 'apihost'));
17290 amit.gupta 802
	}
18446 manish.sha 803
 
804
	public function orderdetail(){
805
		$orderId = $this->request->query('order_id');
806
		$userId = $this->Auth->User('id');
807
		$next = "order/".$orderId;					
808
		$redirectUrl = $this->getAutoLoginUrl($userId,$next);
18449 manish.sha 809
		$this->layout = "innerpages";
18446 manish.sha 810
		$this->log($redirectUrl,'headers');
811
		$this->set(compact('redirectUrl','next'));
812
	}
17459 amit.gupta 813
}