API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 30th, 2015
231
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.79 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3.     $master_branch = array('the branch with a long name'    =>  array(
  4.         // 'date',VAT,NET,COST
  5.             array('26-05-2014',1000,17600,4100),
  6.             array('27-05-2014',1000,17600,4100),
  7.             array('28-05-2014',1000,17600,4100),
  8.             array('29-05-2014',1000,16600,4100),
  9.             array('30-05-2014',1000,17600,4100),
  10.             array('31-05-2014',1000,17600,4100),
  11.             array('01-06-2014',1000,12000,3700),
  12.             array('02-06-2014',1000,12000,3700),
  13.             array('03-06-2014',1000,12000,3700),
  14.             array('04-06-2014',1000,12000,3700),
  15.             array('05-06-2014',1000,12000,3700),
  16.             array('06-06-2014',1000,12000,3700),
  17.             array('07-06-2014',1000,1000,3700),
  18.             array('08-06-2014',1000,12000,3500),
  19.             array('09-06-2014',1000,12000,3700),
  20.             array('10-06-2014',1000,12000,3700),
  21.             array('11-06-2014',1000,12000,3700),
  22.             array('12-06-2014',1000,12000,1700),
  23.             array('13-06-2014',1000,12000,1700),
  24.             array('14-06-2014',1000,12000,1700),
  25.             array('15-06-2014',1000,12000,3700),
  26.             array('16-06-2014',1000,12000,3700),
  27.             array('17-06-2014',1000,12000,3700),
  28.             array('18-06-2014',1000,12000,3700),
  29.             array('19-06-2014',1200,12000,3700), //
  30.             array('20-06-2014',1000,12000,3700),
  31.             array('21-06-2014',1000,12000,3700),
  32.             array('22-06-2014',1000,12000,3700),
  33.             array('23-06-2014',1000,12000,3700),
  34.             array('24-06-2014',1000,12000,3700),
  35.             array('25-06-2014',1200,11000,3200),
  36.             array('26-06-2014',1000,12000,3700),
  37.             array('27-06-2014',1000,12000,3700),
  38.             array('28-06-2014',1000,12000,3700),
  39.             array('29-06-2014',1000,14000,3700),
  40.             array('30-06-2014',1000,14000,3800),
  41.             array('31-06-2014',1000,14000,3800),
  42.             array('01-07-2014',1000,17600,4100),
  43.             array('02-07-2014',1000,17600,4100),
  44.             array('01-05-2015',1000,17600,4100),
  45.             array('02-05-2015',1000,17600,4100),
  46.             array('03-05-2015',1000,17600,4100),
  47.             array('04-05-2015',1000,17600,4100),
  48.             array('05-05-2015',1000,17600,4100),
  49.             array('06-05-2015',1000,17600,4100),
  50.             array('07-05-2015',1000,17600,4100),
  51.             array('08-05-2015',1000,17600,4100),
  52.             array('09-05-2015',1000,17600,4100),
  53.             array('10-05-2015',1000,17600,4100),
  54.             array('11-05-2015',1000,17600,4100),
  55.             array('12-05-2015',1000,17600,4100),
  56.             array('13-05-2015',1000,17600,4100),
  57.             array('14-05-2015',1000,17600,4100),
  58.             array('15-05-2015',1000,17600,4100),
  59.             array('16-05-2015',1000,17600,4100),
  60.             array('17-05-2015',1000,17600,4100),
  61.             array('18-05-2015',1000,17600,4100),
  62.             array('19-05-2015',1000,17600,4100),
  63.             array('20-05-2015',1000,17600,4100),
  64.             array('21-05-2015',1000,17600,4100),
  65.             array('22-05-2015',1000,17600,4100),
  66.             array('23-05-2015',1000,17600,4100),
  67.             array('24-05-2015',1000,17600,4100),
  68.             array('25-05-2015',1000,17600,4100),
  69.             array('26-05-2015',1000,17600,4100),
  70.             array('27-05-2015',1000,17600,4100),
  71.             array('28-05-2015',1000,17600,4100),
  72.             array('29-05-2015',1000,16600,4100),
  73.             array('30-05-2015',1000,17000,4100),
  74.             array('31-05-2015',1000,17100,4100),
  75.             array('01-06-2015',1000,17200,4100),
  76.             array('02-06-2015',1000,17300,4100),
  77.             array('03-06-2015',1000,17400,4100),
  78.             array('04-06-2015',1000,17500,4100),
  79.         //array('05-06-2015',1000,17600,4100), // removing some data for testing
  80.             array('06-06-2015',1000,17700,4100),
  81.             array('07-06-2015',1000,17800,4100),
  82.             array('08-06-2015',1000,17600,4100),
  83.             array('09-06-2015',1000,17600,4100),
  84.             array('10-06-2015',1000,17600,4100),
  85.             array('11-06-2015',1234,16600,4100),
  86.             array('12-06-2015',1234,16600,4100),
  87.             array('13-06-2015',1234,16600,4100),
  88.             array('14-06-2015',1234,16600,4100),
  89.             array('15-06-2015',1234,16600,4100),
  90.             array('16-06-2015',1234,16600,4100),
  91.             array('17-06-2015',1234,16600,4100),
  92.             array('18-06-2015',1234,16600,4100),
  93.             array('19-06-2015',1234,16600,4100),
  94.             array('20-06-2015',1234,16600,4100),
  95.             array('21-06-2015',1234,16600,4100),
  96.             array('22-06-2015',1234,16600,4100),
  97.             array('23-06-2015',1234,16600,4100),
  98.             array('24-06-2015',1234,16600,4100),
  99.             array('25-06-2015',5134,1100,300),
  100.             array('26-06-2015',1234,16600,4100),
  101.             array('27-06-2015',1214,16600,4100),
  102.             array('28-06-2015',1234,16600,3100),
  103.             array('29-06-2015',1234,12600,4100)
  104. ));
  105.     $date1 = new DateTime('first day of last year last month');
  106.     $date2 = new DateTime('NOW');
  107.     $this_month = $date2->format("m-Y"); // NOW formatted to month-year
  108.     $last_year = $date1->modify('+1 month');
  109.     $last_year_this_month = $last_year->format("m-Y");
  110.  
  111.     // Two foreach's to calculate necessary values
  112.     foreach ($branch_values as $key => $value) {
  113.         $cut_soap_date = substr($value[0], 3); //substr to match month
  114.         if ($cut_soap_date == $this_month) {
  115.             $this_month_date[] = substr($value[0], 0, -8); // get the day value at the current pointer
  116.             $this_month_vat[]  =  $value[1];
  117.             $this_month_net[] =  $value[2];
  118.             $this_month_cost[] =  $value[3];
  119.         }
  120.     } unset($key); unset($value); unset($cut_soap_date);
  121.  
  122.     foreach ($branch_values as $key => $value) { // this month last year
  123.         $cut_soap_date = substr($value[0], 3);
  124.         if ($cut_soap_date == $last_year_this_month) {
  125.             $last_year_this_month_date[] = substr($value[0], 0, -8); //substr to date only
  126.             $last_year_this_month_vat[]  =  $value[1];
  127.             $last_year_this_month_net[] =  $value[2];
  128.             $last_year_this_month_cost[] =  $value[3];
  129.         }
  130.     } unset($key); unset($value); unset($cut_soap_date);
  131.  
  132.     $data = array();
  133.    
  134.     for ($i = 0; $i < 31; $i++) { // Cycle through the days possible
  135.         if ($month_date = $i && $last_year_date = $i) { // so if both dates match the current iteration (we're cycling through dates, if we find a match then append the net)
  136.             $data[] = array($i, $month_net[$i], $last_year_net[$i]);
  137.         } elseif ($last_year_date = $i) { // check for last year
  138.             $data[] = array($i, '', $last_year_net[$i]);
  139.         } elseif ($month_date = $i) { // check for this month
  140.             $data[] = array($i, $month_net[$i], '');
  141.             }
  142.     }
  143.  
  144. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!