function ModelTest()
{
pr($_SESSION['Auth']['User']);
// $_SESSION['Auth']['User']['id_empresa'] = '1';
// $_SESSION['Auth']['User']['empresa'] = 'Bonampak';
// $_SESSION['Auth']['User']['id_empresa'] = '2';
// $_SESSION['Auth']['User']['empresa'] = 'ATM';
// pr($_SESSION['Auth']['User']);
exit;
// pr('current month is :'. $_SESSION['week']['month']);
// pr($this->Flujo->getFlujo($week='31',$year='2014',$status='Active',$month='08'));
// pr($this->FlujoSaldo->getSaldo($week='31',$year='2014',$status='Active',$month='7'));
pr($this->GetSaldo());
exit;
App::Import('Shell', 'Shell');
App::Import('Vendor', array('shells/calendar'));
$myCalendar = new CalendarShell(new Object());
$myCalendar->initialize();
$calendar = $myCalendar->main($year = date('Y'), false);
$ical = $myCalendar->DaysInMonth($year);
//Get the days in CurrentMonth from specific method in CalendarShell
// pr($calendar);pr($ical);
exit;
}
function DailyReport($concepto = null, $area = null, $mes = null, $flota = null, $fraccion = null, $year = null)
{
// for switch between method in the shell only change the object->method call example $myShell->months();
// grab the vars
$filter['get_area'] = $area;
$filter['get_mes'] = $mes;
$filter['concepto'] = $concepto;
if (!isset($_SESSION['projections']['months'])) {
$_SESSION['projections']['months'] = $this->months($return = true, $set = false, $year = date('Y'));
}
$months = $_SESSION['projections']['months'];
// $fraction = $myShell->Fraccion->find('list',array('fields'=>array('id','fraccion')));
if (!isset($_SESSION['projections']['fraction'])) {
$_SESSION['projections']['fraction'] = $this->Fraccion->find('list', array('fields' => array('id', 'fraccion')));
}
$fraction = $_SESSION['projections']['fraction'];
// pr($fraction);
$id_empresa = $_SESSION['Auth']['User']['id_empresa'];
// $months = $this->months(true,false,$year);
// import the shell that calculates->toneladas and main method
// App::Import('Shell', 'Shell');
// App::Import('Vendor',array('shells/sniffer_data'));
// $myShell = new SnifferDataShell(new Object());
// $myShell->initialize();
// // Select the method to call
// $Shell = $myShell->main($view=true,$debug=false);
// // pr($Shell);exit();
// $getShell = $Shell['Toneladas']; // Fix for compability
// // pr($getShell);exit();
// $kms = $Shell['kms'];
// // pr($kms);exit();
// $ingresos = $Shell['ingresos'];
// // pr($ingresos);exit();
$ingresos = null;
// pr($concepto);
App::Import('Shell', 'Shell');
App::Import('Vendor', array('shells/calendar'));
$myCalendar = new CalendarShell(new Object());
$myCalendar->initialize();
$calendar = $myCalendar->main($year = date('Y'), false);
$ical = $myCalendar->DaysInMonth($year);
//Get the days in CurrentMonth from specific method in CalendarShell
if (!isset($_SESSION['projections']['operacion'])) {
$this->operations();
}
if (isset($area)) {
// comes from detail.ctp view for toneladas
if ($area == '0') {
// for all areas
$Calendar = $calendar['days'][$mes];
$cal_viajes = $cal_ingresos = $cal_kms = $cal_tons = $Calendar;
// $DailyReport = $getShell['DailyReport']['report_day'][$id_empresa];// Set All areas for Toneladas
$DailyReport = $_SESSION['projections']['operacion']['toneladasDaily'][$id_empresa];
foreach ($DailyReport as $area_name => $month) {
foreach ($month as $month_name => $fraccion_) {
if (!empty($fraccion_)) {
foreach ($fraccion_ as $fraccion_name => $day) {
if (!empty($day)) {
foreach ($day as $day_num => $DailyTons) {
if (!isset($days_all_tons[$month_name][$fraccion_name][$day_num])) {
$days_all_tons[$month_name][$fraccion_name][$day_num] = null;
}
$days_all_tons[$month_name][$fraccion_name][$day_num] += $DailyTons;
}
}
}
}
}
}
// Then build the calendar
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($days_all_tons[$mes][$fraction_desc])) {
foreach ($days_all_tons[$mes][$fraction_desc] as $day => $tonsValue) {
if (isset($days_all_tons[$mes][$fraction_desc][$day])) {
$cal_tons[$day][$fraction_desc] = $tonsValue;
$_fraccion['toneladas'][$id_fraction] = $fraction_desc;
}
}
}
}
}
$cal = $cal_tons;
// Set All areas for Kilometros
// $DailyReportKms = $kms['report_daily'][$id_empresa];
$DailyReportKms = $_SESSION['projections']['operacion']['kilometrosDaily'][$id_empresa];
foreach ($DailyReportKms as $area_name => $month) {
foreach ($month as $month_name => $fraccion_) {
if (!empty($fraccion_)) {
foreach ($fraccion_ as $fraccion_name => $day) {
if (!empty($day)) {
foreach ($day as $day_num => $DailyKms) {
// if($days_all_kms[$month_name][$fraccion_name][$day_num] == 0){
// unset($days_all_kms[$month_name][$fraccion_name][$day_num]);
// }
if (!isset($days_all_kms[$month_name][$fraccion_name][$day_num])) {
$days_all_kms[$month_name][$fraccion_name][$day_num] = null;
}
$days_all_kms[$month_name][$fraccion_name][$day_num] += $DailyKms;
}
}
}
}
}
}
// Then build the calendar
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($days_all_kms[$mes][$fraction_desc])) {
foreach ($days_all_kms[$mes][$fraction_desc] as $day => $kmsValue) {
if (isset($days_all_kms[$mes][$fraction_desc][$day])) {
$cal_kms[$day][$fraction_desc] = $kmsValue;
$_fraccion['kilometros'][$id_fraction] = $fraction_desc;
}
}
}
}
}
$kms_days = $cal_kms;
// $DailyReportIngresos = $ingresos['report_daily'][$id_empresa];
$DailyReportIngresos = $_SESSION['projections']['operacion']['ingresosDaily'][$id_empresa];
foreach ($DailyReportIngresos as $area_name => $month) {
foreach ($month as $month_name => $fraccion_) {
if (!empty($fraccion_)) {
foreach ($fraccion_ as $fraccion_name => $day) {
if (!empty($day)) {
foreach ($day as $day_num => $DailyIngresos) {
if (!isset($days_all_ingresos[$month_name][$fraccion_name][$day_num])) {
$days_all_ingresos[$month_name][$fraccion_name][$day_num] = null;
}
$days_all_ingresos[$month_name][$fraccion_name][$day_num] += $DailyIngresos;
}
}
}
}
}
}
// Then build the calendar
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($days_all_ingresos[$mes][$fraction_desc])) {
foreach ($days_all_ingresos[$mes][$fraction_desc] as $day => $ingresosValue) {
if (isset($days_all_ingresos[$mes][$fraction_desc][$day])) {
$cal_ingresos[$day][$fraction_desc] = $ingresosValue;
$_fraccion['ingresos'][$id_fraction] = $fraction_desc;
}
}
}
}
}
$ingresos_days = $cal_ingresos;
// // // // // // // // // // // // // // // // // // // // // // // // // // // // //
// Set All areas for Kilometros
// $DailyReportKms = $kms['report_daily'][$id_empresa];
$DailyReportViajes = $_SESSION['projections']['operacion']['viajesDaily'][$id_empresa];
foreach ($DailyReportViajes as $area_name => $month) {
foreach ($month as $month_name => $fraccion_) {
if (!empty($fraccion_)) {
foreach ($fraccion_ as $fraccion_name => $day) {
if (!empty($day)) {
foreach ($day as $day_num => $DailyViajes) {
// if($days_all_kms[$month_name][$fraccion_name][$day_num] == 0){
// unset($days_all_kms[$month_name][$fraccion_name][$day_num]);
// }
if (!isset($days_all_viajes[$month_name][$fraccion_name][$day_num])) {
$days_all_viajes[$month_name][$fraccion_name][$day_num] = null;
}
$days_all_viajes[$month_name][$fraccion_name][$day_num] += $DailyViajes;
}
}
}
}
}
}
// Then build the calendar
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($days_all_viajes[$mes][$fraction_desc])) {
foreach ($days_all_viajes[$mes][$fraction_desc] as $day => $viajesValue) {
if (isset($days_all_viajes[$mes][$fraction_desc][$day])) {
$cal_viajes[$day][$fraction_desc] = $viajesValue;
$_fraccion['viajes'][$id_fraction] = $fraction_desc;
}
}
}
}
}
$viajes_days = $cal_viajes;
// // // // // // // // // // // // // // // // // // // // // // // // // // // //
} else {
// Toneladas <---- bug
$DailyReport = $_SESSION['projections']['operacion']['toneladasDaily'][$id_empresa][$this->areas()[$area]][$mes];
$Calendar = $calendar['days'][$mes];
// Get only the selected month come from detail.ctp
$viajes_days = $ingresos_days = $kms_days = $cal = $Calendar;
//create the array that's containt the toneladas data
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($DailyReport[$fraction_desc])) {
if (isset($DailyReport[$fraction_desc][$day])) {
$cal[$day][$fraction_desc] = $DailyReport[$fraction_desc][$day];
$_fraccion['toneladas'][$id_fraction] = $fraction_desc;
}
}
}
}
// Kilometros <----
$DailyReportKms = $_SESSION['projections']['operacion']['kilometrosDaily'][$id_empresa][$this->areas()[$area]][$mes];
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($DailyReportKms[$fraction_desc])) {
if (isset($DailyReportKms[$fraction_desc][$day])) {
$kms_days[$day][$fraction_desc] = $DailyReportKms[$fraction_desc][$day];
$_fraccion['kilometros'][$id_fraction] = $fraction_desc;
}
}
}
}
// Ingresos <----
$DailyReportIngresos = $_SESSION['projections']['operacion']['ingresosDaily'][$id_empresa][$this->areas()[$area]][$mes];
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($DailyReportIngresos[$fraction_desc])) {
if (isset($DailyReportIngresos[$fraction_desc][$day])) {
$ingresos_days[$day][$fraction_desc] = $DailyReportIngresos[$fraction_desc][$day];
$_fraccion['ingresos'][$id_fraction] = $fraction_desc;
}
}
}
}
// Viajes <----
$DailyReportViajes = $_SESSION['projections']['operacion']['viajesDaily'][$id_empresa][$this->areas()[$area]][$mes];
foreach ($Calendar as $day => $details) {
foreach ($fraction as $id_fraction => $fraction_desc) {
if (isset($DailyReportViajes[$fraction_desc])) {
if (isset($DailyReportViajes[$fraction_desc][$day])) {
$viajes_days[$day][$fraction_desc] = $DailyReportViajes[$fraction_desc][$day];
$_fraccion['viajes'][$id_fraction] = $fraction_desc;
}
}
}
}
}
}
// pr($ingresos_days);exit();
foreach ($months as $num => $data) {
if (in_array($mes, $data)) {
$mes = $data['spanish'];
$id_mes = $data['num'];
// pr($data);
}
}
if (isset($cal)) {
$filter['toneladas'] = $cal;
// set the Toneladas bug => compability
}
if (isset($kms_days)) {
$filter['kilometros'] = $kms_days;
// Set kilometros daily;
}
if (isset($ingresos_days)) {
$filter['ingresos'] = $ingresos_days;
}
if (isset($viajes_days)) {
$filter['viajes'] = $viajes_days;
}
/** WARNING work from hir
$filter['kilometros'] = $kms; // set the kms ==> fixed
$filter['ingresos'] = $ingresos; // set the ingresos ==> fixed
**/
$filter['_fraccion'] = $_fraccion;
$filter['fraction'] = $fraction;
// pr($_fraccion);exit();
$filter['graphs']['ingresos'] = $ingresos;
$filter['area'] = $this->areas()[$area];
$filter['mes'] = $mes;
$filter['id_mes'] = $id_mes;
$filter['year'] = $year;
// $filter['ical'] = $ical[substr($mes,0,3)];
$filter['daysArray'] = $calendar['daysArray'];
// Send var to view
$this->set('filter', $filter);
$this->set('months', $months);
// exit();
}