<?PHP

include('fpdfmysql1.php');

$now_from = $_POST['from'];
$now_to = $_POST['to'];
$province = $_POST['Province'];
$cancer = $_POST['Cancer'];
$gender = $_POST['Gender'];
$nature = $_POST['Nature'];
$age = $_POST['Age'];
$received = $_POST['Received'];
$documentType= $_POST['docType'];



$DB_Server = "";
$DB_Username = "";
$DB_Password = "";
$DB_DBName = "";
$DB_TBLName = "";


$provinceFilterSql = "";
$cancerTypeSql = "";
$genderTypeSql = "";
$natureTypeSql = "";
$ageTypeSql = "";
$receivedTypeSql ="";
$column_province ="";
$column_cancer ="";
$column_gender ="";
$column_nature ="";
$column_age = "";


if ($province!="") {
$provinceFilterSql = " and (`Province`='$province') ";
}

if ($cancer!="") {
$cancerTypeSql = " and (`Cancer Type`='$cancer')";
}
if ($gender!="") {
$genderTypeSql = " and (`Gender`='$gender')";
}
if ($nature!="") {
$natureTypeSql = " and (`Nature of call`='$nature')";
}
if ($age!="") {
$ageTypeSql = " and (`Age`='$age')";
}
if ($received!="") {
$receivedTypeSql = " and (`Received Via`='$received')";
}

$sql ="SELECT * ";
$sql .=" FROM $DB_TBLName";
$sql .=" WHERE (`Call date` BETWEEN '$now_from' AND '$now_to' ) ";
$sql .= $provinceFilterSql;
$sql .= $cancerTypeSql;
$sql .= $genderTypeSql;
$sql .= $natureTypeSql;
$sql .= $ageTypeSql;
$sql .= $receivedTypeSql;


if ($result=mysql_query($sql))
{

$rowcount=mysql_num_rows($result);


mysql_free_result($result);
}


$Use_Title = 0;

$title = "Dump For Table $DB_TBLName from Database $DB_DBName
on $now_from";

$Connect = @MYSQL_CONNECT($DB_Server, $DB_Username, $DB_Password)
or DIE("Couldn't connect to MySQL:<br>" . MYSQL_ERROR() . "<br>"
.MYSQL_ERRNO());

$Db = @MYSQL_SELECT_DB($DB_DBName, $Connect)
or DIE("Couldn't select database:<br>" . MYSQL_ERROR(). "<br>"
.MYSQL_ERRNO());

$result = @MYSQL_QUERY($sql,$Connect)
or DIE("Couldn't execute query:<br>" . MYSQL_ERROR(). "<br>"
. MYSQL_ERRNO());

switch ($documentType) {
case 'excel':
    $file_type = "vnd.ms-excel";
    $file_ending = "xls";

     IF ($Use_Title == 1)
     {
         ECHO("$titlen");
     }

     $sep = "t";


     FOR ($i = 0; $i < MYSQL_NUM_FIELDS($result); $i++)
     {
         ECHO MYSQL_FIELD_NAME($result,$i) . "t";
     }PRINT "Total Records:$rowcount";
     PRINT("n");


     WHILE($row = MYSQL_FETCH_ROW($result))
     {

         $schema_insert = "";
         FOR($j=0; $j<mysql_num_fields($result);$j++)
         {
             IF(!ISSET($row[$j]))
                 $schema_insert .= "NULL".$sep;
             ELSEIF ($row[$j] != "")
                 $schema_insert .= "$row[$j]".$sep;
             ELSE
                 $schema_insert .= "".$sep;
         }
         $schema_insert = STR_REPLACE($sep."$", "", $schema_insert);
         $schema_insert = PREG_REPLACE("/rn|nr|n|r/", " ",
         $schema_insert);
         $schema_insert .= "t";
         PRINT(TRIM($schema_insert));
         PRINT "n";
     }

    HEADER("Content-Type: application/$file_type");
    HEADER("Content-Disposition: attachment;
    filename=CANSA_DB_$now_from.$file_ending");
    HEADER("Pragma: no-cache");
    HEADER("Expires: 0");
    break;
    case 'word':
    $file_type = "doc";
    $file_ending = "doc";


     IF ($Use_Title == 1)
     {
         ECHO("$titlenn");
     }

     $sep = "n";

     WHILE($row = MYSQL_FETCH_ROW($result))
     {

         $schema_insert = "";
         FOR($j=0; $j<mysql_num_fields($result);$j++)
         {

         $field_name = MYSQL_FIELD_NAME($result,$j);
         //will show name of fields
         $schema_insert .= "$field_name:t";
             IF(!ISSET($row[$j])) {
                 $schema_insert .= "NULL".$sep;
                 }
             ELSEIF ($row[$j] != "") {
                 $schema_insert .= "$row[$j]".$sep;
                 }
             ELSE {
                 $schema_insert .= "".$sep;
                 }
         }
         $schema_insert = STR_REPLACE($sep."$", "", $schema_insert);
         $schema_insert .= "t";
         PRINT(TRIM($schema_insert));

         PRINT
 "n----------------------------------------------------n";
     }


    HEADER("Content-Type: application/$file_type");
    HEADER("Content-Disposition: attachment;
    filename=CANSA_DB_$now_from.$file_ending");
    HEADER("Pragma: no-cache");
    HEADER("Expires: 0");
    break;
    case 'pdf':
    $file_type = "pdf";
    $file_ending = "pdf";

    BuildFpdfOutput($result);

    break;




    ?>