<?php


/*
 * Module Tutorial_rakib_chartjs
 * Tainee: Rakib
 */

/**  Error log file generate */
ini_set("log_errors", 1);
ini_set("error_log", "/var/www/bd/html/module/tutorial_rakib_chartjs/php-error.log");
error_log( "Hello, errors!" );

include '../../def_common/define.php';

/**Module Specific */
//include 'def_tutorial_rakib_device_info.php';
include 'db_chart_rakib_stu_info.php';
include 'db_chart_rakib_teacher_info.php';

$smarty = new Smarty();

/**Smarty Templating related Directories */
$smarty->template_dir = dirname( __FILE__ ).'/templates';
$smarty->compile_dir  = dirname( __FILE__ ).'/templates_c';


// DB Object Creation
$stu_ob = new chart_rakib_stu_info($db);
$tea_ob = new chart_rakib_teacher_info($db);

// Get the table name
$stuTableName = $stu_ob->getTableName();
$teaTableName = $tea_ob->getTableName();

// Creating array with all the table names
$allTableName = array($stuTableName, $teaTableName);

// for controling showing column-select options
$ColumnOption = false;

// Will fire after having selected table name by GET method
if(isset($_GET['selectedTalbeName']))
{
    $ColumnOption = true;
   
    session_start();
    $_SESSION['selectedName'] = $_GET['selectedTalbeName'];
    
    // checking the selected table name
    if($_GET['selectedTalbeName'] === "$stuTableName")
    {    
        // Getting all column for X axis [label in chart]
        $allXColumnName = $stu_ob->getXColumnName();
        $_SESSION['allXColumnName'] = $allXColumnName;

        // Getting all column for Y axis [data in chart]
        $allYColumnName = $stu_ob->getYColumnName();
        $_SESSION['allYColumnName'] = $allYColumnName;
    }

    // checking the selected table name
    if($_GET['selectedTalbeName'] === "$teaTableName")
    {
        // Getting all column for X axis [label in chart]
        $allXColumnName = $tea_ob->getXColumnName();
        $_SESSION['allXColumnName'] = $allXColumnName;

        // Getting all column for Y axis [data in chart]
        $allYColumnName = $tea_ob->getYColumnName();
        $_SESSION['allYColumnName'] = $allYColumnName;
    }
    
}


if(isset($_POST['selectXY']))
{
    session_start();
    $selectedName = $_SESSION['selectedName'];
    $ColumnOption = true;

    //chartOption is true for showing chart
    $chartOption = true;

    // FOR MIX CHART ORDER 1
    //Select the column name for set X-Axis for chart
    $selectedX_chart_1 = $_POST['selectedX_chart_1'];

    //Select the column name for set Y-Axis for chart
    $selectedY_chart_1 = $_POST['selectedY_chart_1'];

    //checking the present selected table name for getting appropriate data
    if($selectedName == $stuTableName){
        $columnValuesX_chart_1 = $stu_ob->getOneColumnValue($selectedX_chart_1);
        $columnValuesY_chart_1 = $stu_ob->getOneColumnValue($selectedY_chart_1);
    }
    if($selectedName == $teaTableName){
        $columnValuesX_chart_1 = $tea_ob->getOneColumnValue($selectedX_chart_1);
        $columnValuesY_chart_1 = $tea_ob->getOneColumnValue($selectedY_chart_1);
    }
    // Converting X column values array to string with proper format for chart label field
    $ans = "";
    foreach($columnValuesX_chart_1 as $item){
        // Wrapping the data label format such as: 'name_1' , 'name_2' , 'name_3' , 
        $ans .= "'".$item."' , ";  
    }
    // removing last two char from the above formatted string to eliminate colon (,) 
    $_SESSION['columnX_Values_chartLabel_chart_1'] = substr($ans, 0, -2);  
   
    // Converting Y column values array to string with proper format for chart data field
    $_SESSION['columnY_Values_chartData_chart_1'] = implode(', ', $columnValuesY_chart_1);

    // seting the selected chart option
    $chartSelect_chart_1 = $_POST['chartSelect_chart_1'];


    // FOR MIX CHART ORDER 2
    //Select the column name for set X-Axis for chart
    $selectedX_chart_2 = $_POST['selectedX_chart_2'];

    //Select the column name for set Y-Axis for chart
    $selectedY_chart_2 = $_POST['selectedY_chart_2'];

    //checking the present selected table name for getting appropriate data
    if($selectedName == $stuTableName){
        $columnValuesX_chart_2 = $stu_ob->getOneColumnValue($selectedX_chart_2);
        $columnValuesY_chart_2 = $stu_ob->getOneColumnValue($selectedY_chart_2);
    }
    if($selectedName == $teaTableName){
        $columnValuesX_chart_2 = $tea_ob->getOneColumnValue($selectedX_chart_2);
        $columnValuesY_chart_2 = $tea_ob->getOneColumnValue($selectedY_chart_2);
    }
    // Converting X column values array to string with proper format for chart label field
    $ans = "";
    foreach($columnValuesX_chart_2 as $item){
        // Wrapping the data label format such as: 'name_1' , 'name_2' , 'name_3' , 
        $ans .= "'".$item."' , ";  
    }
    // removing last two char from the above formatted string to eliminate colon (,) 
    $_SESSION['columnX_Values_chartLabel_chart_2'] = substr($ans, 0, -2);  
   
    // Converting Y column values array to string with proper format for chart data field
    $_SESSION['columnY_Values_chartData_chart_2'] = implode(', ', $columnValuesY_chart_2);

    // seting the selected chart option
    $chartSelect_chart_2 = $_POST['chartSelect_chart_2'];
}


$smarty->assign("alltalbeName", $allTableName);
// permission for showing column-select option
$smarty->assign("ColumnOption", $ColumnOption);

// permission for showing chart
$smarty->assign("chartOption", $chartOption);

// selected type of chart order 1
$smarty->assign("chartSelect_chart_1", $chartSelect_chart_1);

// selected type of chart order 1
$smarty->assign("chartSelect_chart_2", $chartSelect_chart_2);

// For chart type selection
$smarty->assign("selectedY_chart_1", $selectedY_chart_1);
$smarty->assign("selectedY_chart_2", $selectedY_chart_2);


$primaryChartType = "";
//for selecting primary chart type
if(($chartSelect_chart_1 == "pie" || $chartSelect_chart_1 == "doughnut" ) && ($chartSelect_chart_2 == "pie" || $chartSelect_chart_2 == "doughnut" ))
{
    $primaryChartType = "pie";
    //$smarty->assign("primaryChartType", $primaryChartType);
}
if(($chartSelect_chart_1 == "bar" || $chartSelect_chart_1 == "line" ) && ($chartSelect_chart_2 == "bar" || $chartSelect_chart_2 == "line" ))
{
    $primaryChartType = "bar";
    //$smarty->assign("primaryChartType", $primaryChartType);
}

$smarty->assign("primaryChartType", $primaryChartType);
// Displaying tpl
$smarty->display('index.tpl');


?>