";
                // print_r($data);exit;*/

            }
        } elseif($this->request->is('Post')) {

            $uniqueURL = $this->request->data('unique_url');
            $expenseType = trim(substr($uniqueURL, 0, 1));

            if ($expenseType == "1" || $expenseType == "2") {
                $data = $this->Expense->getGroupExpenseInfoByURL($uniqueURL);

                // added by Bijoy
                if(isset($this->request->data['participant_id']) && !empty($this->request->data('participant_id'))){
	                $current_perticipants = $this->request->data('participant_id');
	            } else {
	            	$current_perticipants = '';
	            }
                if(!empty($data['Participant'])){
					foreach ($data['Participant'] as $key => $perticipant) {
						// unset($data['Participant'][$key]);
						$newdata['Participant'][$perticipant['participant_id']] = $perticipant;
						$newdata['Participant'][$perticipant['participant_id']]['total_charge'] = 0;
						$newdata['Participant'][$perticipant['participant_id']]['total_paid'] = 0;
						$newdata['Participant'][$perticipant['participant_id']]['currency'] = $data['Expense']['currency'];

						$perticipants[$perticipant['participant_id']] = $perticipant['name'];
					}
				}
				$this->set("perticipants",$perticipants);

                if ($expenseType == "1" ) {
					if(!empty($data['GroupExpense'])){ $expCounter = 1;
						foreach ($data['GroupExpense'] as $keya => $groupExpense) {
							$aa = array();
							$aa = explode(',', $groupExpense['participant_amount']);
							foreach ($aa as $keyb => $vala) {
								$bb = array();
								$bb = explode('|', $vala);
								$newdata['Participant'][$bb[0]]['total_charge'] += $bb[2];
							}
							$newdata['Participant'][$groupExpense['paid_by_participant_id']]['total_paid'] += $groupExpense['amount'];

							$data['GroupExpense'][$keya]['involve_list'] = $this->getInvolves($data, $groupExpense['participant_amount']);

		                    foreach ($newdata['Participant'] as $participant) {
		                        if ($participant['participant_id'] == $groupExpense['paid_by_participant_id']) {
		                            $data['GroupExpense'][$keya]['participent_name'] = $participant['name'];
		                        }
		                    }
						}
					}
					if($current_perticipants != ''){
						$tempGroupExpense = $data['GroupExpense'];
						if(!empty($tempGroupExpense)){
							foreach ($tempGroupExpense as $keya => $groupExpense) {
								if( $groupExpense['paid_by_participant_id'] == $current_perticipants || strpos($groupExpense['participant_amount'], $current_perticipants.'|') !== false ) {
									// echo 'Yes';
								} elseif($current_perticipants != '') {
									unset($data['GroupExpense'][$keya]);
									// echo 'NO';
								}
							}
						}
					}
					$hasMeal = 1;
				}
				if ($expenseType == "2" ) {
					if(!empty($data['GroupExpense'])){ $total_expense = 0;
						foreach ($data['GroupExpense'] as $keya => $groupExpense) {
							$total_expense = $total_expense + $groupExpense["amount"];
							$newdata['Participant'][$groupExpense['paid_by_participant_id']]['total_paid'] += $groupExpense['amount'];
						}
					}


					$total_meal = 0; $tempParticipantMeal = array();
		            foreach ($data['Meal'] as $value) {
		                $meal_participants = explode(',', $value['meal_amount']);
		                foreach ($meal_participants as $meal_participant) {
		                    $meal_amounts = explode('|', $meal_participant);
		                    if(!isset($tempParticipantMeal[$meal_amounts[0]]['meal'])){
		                        $tempParticipantMeal[$meal_amounts[0]]['meal'] = 0;
		                    }
		                    $tempParticipantMeal[$meal_amounts[0]]['meal'] += $meal_amounts[1] + $meal_amounts[2] + $meal_amounts[3];
		                    $total_meal += $meal_amounts[1] + $meal_amounts[2] + $meal_amounts[3];
		                }
		            }
		            if(!empty($newdata['Participant'])){
		            	if($total_meal != 0)
				            $meal_rate = $total_expense / $total_meal;
		            	foreach ($newdata['Participant'] as $key => $value) {
		            		if(isset($tempParticipantMeal[$key])){
				                $newdata['Participant'][$key]["total_charge"] = $tempParticipantMeal[$key]['meal'] * $meal_rate;
		            		}
		            	}
		            }
		            $hasMeal = 2;
				}
				$this->set("hasMeal",$hasMeal);
				$this->set("current_perticipants",$current_perticipants);
				$this->set("allGroupExpense",$data['GroupExpense']);
				$this->set("allParticipant",$newdata['Participant']);
				$pieDataFinal = array();
				if($newdata['Participant']){ $counter = 0;
				 	foreach ($newdata['Participant'] as $key => $val) {
				 		// if( (($current_perticipants != '') && ($val['participant_id'] == $current_perticipants)) || ($current_perticipants == '') ) {
					 		$pieDataFinal[$counter]['name'] = $val['name'];
					 		$pieDataFinal[$counter]['y'] = $val['total_charge'];
					 		$counter++;
				 		// }
				 	}
				}
				$this->set("pieChartDataFinal",json_encode($pieDataFinal));

            } elseif($expenseType == "3") {
            	// added by Bijoy
            	// pr($this->request->data);
                if(isset($this->request->data['current_perticipants']) && !empty($this->request->data['current_perticipants'])){
	                $current_perticipants = $this->request->data['current_perticipants'];
	            } else {
	            	$current_perticipants = '';
	            }
                $data = $this->Expense->getFamilyExpenseInfoByURL($uniqueURL);
                if(!empty($data)){
                    $data["Category"] =  $this->getCategories();
                }
                $total_family_income = 0;
                $total_family_expense = 0;
                if(!empty($data['FamilyExpense']) && isset($data['FamilyExpense'])){
                    foreach ($data['FamilyExpense'] as $family_expense) {
                        if($family_expense['record_type'] == 1){
                            $total_family_expense = $total_family_expense + $family_expense['amount'];
                        } elseif ($family_expense['record_type'] == 2) {
                            $total_family_income = $total_family_income + $family_expense['amount'];
                        }
                    }
                }
                $this->set('total_family_income', $total_family_income);
                $this->set('total_family_expense', $total_family_expense);
                $this->set('data', $data);


				if(!empty($data)){ 
					$fcounter = 0;
					$temp_total_income = 0;
					$temp_total_expense = 0;
					$total_income_str = '';
					$total_balance_str = '';
					$total_expense_str = '';
					foreach ($data['FamilyExpense'] as $key => $familyExpense) {
						if(!isset($newData[$fcounter]['total_income'])){
							$newData[$fcounter]['total_income'] = 0;
						}
						if(!isset($newData[$fcounter]['total_expense'])){
							$newData[$fcounter]['total_expense'] = 0;
						}
						$newData[$fcounter]['expense_date'] = $familyExpense['expense_date'];

						if($familyExpense['record_type'] == 1)
						{
							$temp_total_expense += $familyExpense['amount'];
							$newData[$fcounter]['expense'] = $familyExpense['amount'];
							$newData[$fcounter]['income'] = 0;
							$newData[$fcounter]['total_expense'] = $temp_total_expense;
							$newData[$fcounter]['total_income'] = $temp_total_income;
						} 
						elseif($familyExpense['record_type'] == 2)
						{
							$temp_total_income += $familyExpense['amount'];
							$newData[$fcounter]['expense'] = 0;
							$newData[$fcounter]['income'] = $familyExpense['amount'];
							$newData[$fcounter]['total_income'] = $temp_total_income;
							$newData[$fcounter]['total_expense'] = $temp_total_expense;
						}

							$newData[$fcounter]['balance'] = $temp_total_income - $temp_total_expense;

						$newData[$fcounter]['record_type'] = $familyExpense['record_type'];
						$total_income_str[] = $newData[$fcounter]['total_income'];
						$total_expense_str[] = $newData[$fcounter]['total_expense'];
						$total_balance_str[] = $newData[$fcounter]['balance'];
						$fcounter++;
					}
				}
				// pr($newData);
				$total_income_str = implode(',', $total_income_str);
				$total_expense_str = implode(',', $total_expense_str);
				$total_balance_str = implode(',', $total_balance_str);
				$this->set('total_income_str', $total_income_str);
                $this->set('total_expense_str', $total_expense_str);
                $this->set('total_balance_str', $total_balance_str);
				$this->set("current_perticipants", $current_perticipants);


                $this->render('print_family_report');
            }
            if(isset($this->request->data['participant_id']) && !empty($this->request->data('participant_id'))){
                $participant_id = $this->request->data('participant_id');
                if($expenseType == "1") {
                	$data = $this->filterExpenseData($participant_id, $data);
                }
                $this->set('participant_id', $participant_id);
            }
            if(!empty($data['GroupExpense'])){
	            foreach ($data['GroupExpense'] as $key => $groupExpense) {
	                $data['GroupExpense'][$key]['involve_list'] = $this->getInvolves($data, $groupExpense['participant_amount']);

	                foreach ($data['Participant'] as $participant) {
	                    if($participant['participant_id'] == $groupExpense['paid_by_participant_id']){
	                        $data['GroupExpense'][$key]['participent_name'] = $participant['name'];
	                    };
	                }
	            }
            }
            if(!empty($data)){
                $this->set('data', $data);

            }
        }
    }

    private function getInvolves($data, $involves)
    {
        $involveStrAll =[];
        $involveStrExcept = "";
        $involvesArray = explode(',', $involves);
        foreach ($involvesArray as $involve)
        {
            $involve_id = explode('|', $involve);
            foreach($data['Participant'] as $participant){
               if($participant['participant_id'] == $involve_id[0]) {
                    $involveStrAll[] = $participant['name'];
                }
            }
        }
        if(count($involveStrAll) == count($data['Participant'])){
            $involveStrExcept = "all";
        } else {
            foreach($data['Participant'] as $participant) {
                if(!in_array($participant['name'], $involveStrAll)) {
                    if($involveStrExcept == "") {
                        $involveStrExcept = "All except ".$participant['name'];
                    } else {
                        $involveStrExcept .= ", ".$participant['name'];
                    }
                }
            }
        }
        $involveStrAll = implode(', ', $involveStrAll);
        if(strlen($involveStrExcept) > strlen($involveStrAll)) {
            $involveStrExcept = $involveStrAll;
        }
       return $involveStrExcept;
    }

    private function filterExpenseData($participant_id, $data)
    {

        $tempGroupExpense = $data['GroupExpense'];

        foreach ($tempGroupExpense as $key => $groupExpense){
            $participanyArray = [];
            $involvesArray = explode(',', $groupExpense['participant_amount']);
            foreach ($involvesArray as $involve)
            {
                $involve_id = explode('|', $involve);
                $participanyArray[] = $involve_id[0];
                if($involve_id[0] == $participant_id) {
                    $data['GroupExpense'][$key]['my_expense'] =  $involve_id[2];
                }
            }
            if(!in_array($participant_id, $participanyArray)){

                unset($data['GroupExpense'][$key]);
            }
        }
        /*echo "
";
        print_r($data);exit;*/

        return $data;
    }

    public function generatePdf()
    {
        $html = $this->request->data['whole_content'];
        // pr($html); die;
        $mpdf = new mPDF();
        $mpdf->SetProtection(array("print"));
        $stylesheet = file_get_contents(CDN_URL.'css/print_report.css');
        $mpdf->WriteHTML($stylesheet,1);
        $mpdf->WriteHTML($html, 2);
        $rand = rand(1000, 10000);
        $reportUrl = "reports/";
        if(!is_dir($reportUrl)){
            mkdir($reportUrl,0777,true);
        }
        $filename = $reportUrl.$rand."_".time()."_"."expenses.pdf";
        // echo $html; die;
        $mpdf->Output($filename);

        if (file_exists($filename)) {
            header('Content-type: application/pdf');
            header('Content-Disposition: attachment; filename='.$filename);
            readfile($filename);
            @unlink($filename);
            exit;
        }
    }

    public function generateCSV()
    {
        $data = $this->request->data['csv_content'];
        $data_summary = $this->request->data['csv_summary_content'];
        $data_meal = $this->request->data['csv_meal_content'];
        $hasMeal = $this->request->data['hasMeal'];

        $adata = unserialize($data);
        $adata_summary = unserialize($data_summary);
        $adata_meal = unserialize($data_meal);
        // echo "
";        print_r($adata_meal);exit;
        $rand = rand(1000, 10000);
        $filename = $rand.'_'.time().'_expense.csv';
        ob_start();
        header('Content-Encoding: UTF-8');
        header('Content-Type: text/csv; charset=UTF-8');
        header('Content-Disposition: attachment; filename=' . $filename);
        $fp = fopen('php://output', 'w');

        if(!empty($adata)){
            fputcsv($fp, ['', 'All Expenses', '','','','']);
            if($adata[0]['my_expense']>0)
       			fputcsv($fp, ['Who Paid?', 'How Much?', 'For what reasons?', 'When', 'Involves', 'My Expense']);
       		else
       			fputcsv($fp, ['Who Paid?', 'How Much?', 'For what reasons?', 'When', 'Involves', '']);

            $totalAmount = 0;
            $my_expenseAmount = 0;
	        foreach ($adata as $data) {
	        	$totalAmount += $data['amount'];
	        	$my_expenseAmount += $data['my_expense'];
	            $transaction_row = array();
	            if (!empty($data)) {
	                $transaction_row = [
	                    $data['participent_name'],
	                    $data['amount'] . " " . $data['currency'],
	                    $data['what'],
	                    $data['expense_date_new'],
	                    $data['involve_list'],
	                    ($data['my_expense']>0) ? $data['my_expense'] . " " . $data['currency']:''
	                ];
	            }
	            fputcsv($fp, $transaction_row);
	        }
	        if($my_expenseAmount > 0)
	            fputcsv($fp, ['Total:', $totalAmount . " " . $data["currency"], '','','Total',$my_expenseAmount . " " . $data["currency"]]);
	        else
	            fputcsv($fp, ['Total:', $totalAmount . " " . $data["currency"], '','','','']);
            fputcsv($fp, ['', '', '','','','']);
        } else {
        	fputcsv($fp, ['', 'All Expenses', '','','','']);
       		fputcsv($fp, ['Who Paid?', 'How Much?', 'For what reasons?', 'When', 'Involves', '']);
       		fputcsv($fp, ['No Data Available in table', '', '', '', '', '']);
       		fputcsv($fp, ['', '', '','','','']);
        }

        if($hasMeal == 2){
	        if(!empty($adata_meal)){
	            fputcsv($fp, ['','Meal','','','','']);					
	       		fputcsv($fp, ['Date', 'Day', 'Breakfast', 'Lunch', 'Dinner', 'Total']);

	            $total = 0;
		        foreach ($adata_meal as $data) {
		        	$total += $data['subtotal'];
		            $transaction_row = array();
		            if (!empty($data)) {
		                $transaction_row = [
		                    $data['create_date'],
		                    $data['day'],
		                    $data['breakfast'],
		                    $data['lunch'],
		                    $data['dinner'],
		                    $data['subtotal']
		                ];
		            }
		            fputcsv($fp, $transaction_row);
		        }

	            fputcsv($fp, ['','','','','Total:',$total]);
	            fputcsv($fp, ['','','','','','']);
	        } else {
	        	fputcsv($fp, ['','Meal','','','','']);					
	       		fputcsv($fp, ['Date', 'Day', 'Breakfast', 'Lunch', 'Dinner', 'Total']);
	       		fputcsv($fp, ['No meal available', '', '', '', '', '']);
	       		fputcsv($fp, ['', '', '','','','']);
	        }
        }

        if(!empty($adata_summary)){
            fputcsv($fp, ['', 'Summary Report', '','','','']);
            fputcsv($fp, ['Participants', 'Charged', 'Paid', 'Due']);

	        foreach ($adata_summary as $data) {
	            $transaction_row = array();
	            if (!empty($data)) {
	                $transaction_row = [
	                    $data['name'],
	                    $data['total_charge'] . " " . $data['currency'],
	                    $data['total_paid'] . " " . $data['currency'],
	                    $data['due'] . " " . $data['currency']
	                ];
	            }
	            fputcsv($fp, $transaction_row);
	        }

        }
        fclose($fp);
        exit;
    }

    public function generateFamilyCSV()
    {
        $csv_expense_heading = $this->request->data['csv_expense_heading'];
        $csv_income_heading = $this->request->data['csv_income_heading'];
        $income_data = $this->request->data['csv_income_content'];
        $expense_data = $this->request->data['csv_expense_content'];

        $aincome_data = unserialize($income_data);
        $aexpense_data = unserialize($expense_data);
        $aexpense_heading = unserialize($csv_expense_heading);
        $aincome_heading = unserialize($csv_income_heading);
        // echo "
";        print_r($aexpense_heading);
        // echo "
";        print_r($aexpense_data);
        // echo "
";        print_r($aincome_heading);
        // echo "
";        print_r($aincome_data);
        // exit;
        $rand = rand(1000, 10000);
        $filename = $rand.'_'.time().'_expense.csv';
        ob_start();
        header('Content-Encoding: UTF-8');
        header('Content-Type: text/csv; charset=UTF-8');
        header('Content-Disposition: attachment; filename=' . $filename);
        $fp = fopen('php://output', 'w');

        if(!empty($aincome_data)){
            fputcsv($fp, ['', 'All Incomes', '','']);
       		fputcsv($fp, [$aincome_heading['nameHeading'], $aincome_heading['categoryHeading'], $aincome_heading['dateHeading'],$aincome_heading['amountHeading']]);

            $totalAmount = 0;
	        foreach ($aincome_data as $data) {
	        	$totalAmount += $data['amount'];
	            $transaction_row = array();
	            if (!empty($data)) {
	                $transaction_row = [
	                    $data['expenseName'],
	                    $data['expenseCategory'],
	                    $data['expenseDate'],
	                    $data['amount'] . " " . $data['currency'],
	                ];
	            }
	            fputcsv($fp, $transaction_row);
	        }
	            fputcsv($fp, ['','','Total:', $totalAmount . " " . $data["currency"]]);
            fputcsv($fp, ['', '', '', '']);
        }
        if(!empty($aexpense_data)){
            fputcsv($fp, ['', 'All Expenses', '','']);
       		fputcsv($fp, [$aexpense_heading['nameHeading'], $aexpense_heading['categoryHeading'], $aexpense_heading['dateHeading'],$aexpense_heading['amountHeading']]);

            $totalAmount = 0;
	        foreach ($aexpense_data as $data) {
	        	$totalAmount += $data['amount'];
	            $transaction_row = array();
	            if (!empty($data)) {
	                $transaction_row = [
	                    $data['expenseName'],
	                    $data['expenseCategory'],
	                    $data['expenseDate'],
	                    $data['amount'] . " " . $data['currency'],
	                ];
	            }
	            fputcsv($fp, $transaction_row);
	        }
	            fputcsv($fp, ['','','Total:', $totalAmount . " " . $data["currency"]]);
            fputcsv($fp, ['', '', '', '']);
        }


        fclose($fp);
        exit;
    }
	 
}
?>