<?phpPHP
  include "../conn9.php";
  $Date = $_GET["Date"]; 
  
   // Original PHP code by Chirp Internet: www.chirp.com.au
  // Please acknowledge use of this code by including this header.

  function cleanData(&$str)
  {
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  }

  // filename for download
  $filename = "Nutrition_divisionwise_" . date('Ymd') . ".xls";

  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");

  $flag = false;
  $result=mysql_query("Select division.div_code,div_name,
                    sum(pusti_iycf) IYCF,sum(pusti_ifapreg) IFA,sum(pusti_ifa0_23) IFA0_23,
                    sum(pusti_breastfeeding) Exclusive_Breastfeeding,sum(pusti_complemenfood0_23) Complementary_Food0_23,
                    sum(pusti_complemenfood24_59) pusti_complemenfood24_59,sum(pusti_mnp6_23) MNP_Sachet6_23,
                    sum(pusti_mnp24_59) MNP_Sachet24_59,sum(pusti_vita) Vitamin_A,sum(pusti_helmancia) Helminthics_Tab,
                    sum(pusti_zinkpill) Zinkpill,sum(pusti_gmp) GMP,sum(pusti_mam) MAM,sum(pusti_sam) SAM,
                    sum(pusti_stunting) Stunting,sum(pusti_wasting) Wasting,sum(pusti_underweight) Underweight
  From division,district,thana,pusti_details
  Where division.div_code=district.div_code And district.dist_code = thana.dist_code And thana.thana_code=pusti_details.thana_code 
  And division.div_code<>'20' And month_id='$Date'
  Group by division.div_code,div_name Order by division.div_code") or die('Query failed!');

  while(false !== ($row = mysql_fetch_assoc($result))) {
    if(!$flag) {
      // display field/column names as first row
      echo implode("\t", array_keys($row)) . "\r\n";
      $flag = true;
    }
    array_walk($row, 'cleanData');
    echo implode("\t", array_values($row)) . "\r\n";
  }
  exit;
?>