graph generator

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); // } // if(($chartSelect_chart_1 == "horizontalBar") && ($chartSelect_chart_2 == "horizontalBar")) // { // $primaryChartType = "horizontalBar"; // } // $smarty->assign("primaryChartType", $primaryChartType); // // Displaying tpl // $smarty->display('index6.tpl'); ?> template_dir = dirname( __FILE__ ).'/templates'; // $smarty->compile_dir = dirname( __FILE__ ).'/templates_c'; /**Database Object */ // $db_table_content = new content($db); // $db_table_content_1 = new content_1($db); // /*create content object for Content_2 database*/ // $db_table_content_2 = new content_2($db); // $numTableName = $db_table_content_2->getTableName(); // $columnOption = False; // if(isset($_GET['selectedTableName'])) // { // $columnOption = true; // session_start(); // $_SESSION['selectedName'] = $_GET['selectedTableName']; // if($_GET['selectedTableName'] === $numTableName) // { // $allXColumnName = $db_table_content_2->getXColumn(); // $_SESSION['allXColumnName'] = $allXColumnName; // $allYColumnName = $db_table_content_2->getYColumn(); // $_SESSION['allYColumnName'] = $allYColumnName; // } // } // if(isset($_POST['selectXY'])) // { // session_start(); // $selectedName = $_SESSION['selectedName']; // $columnOption = true; // $chartOption = true; // $selectedX = $_POST['selectedX']; // $selectedY = $_POST['selectedY']; // if($selectedName == $numTableName){ // $columnValuesX = $db_table_content_2->getOneColumnValue($selectedX); // $columnValuesY = $db_table_content_2->getOneColumnValue($selectedY); // } // $ans = ""; // foreach($columnValuesX as $item){ // $ans .= "'".$item."' , "; // } // $_SESSION['columnX_Values_chartLabel'] = substr($ans, 0, -2); // $_SESSION['columnY_Values_chartData'] = implode(', ', $columnValuesY); // $chartSelect = $_POST['chartSelect']; // } /**Data create in Content table */ /** Randomly data generated for each table */ // if( DATA_CREATE_CONTROL == "0" ) // { // $rowData = array( // "content_name" => "テスト".rand(1,10000), // "description" => "テスト用".rand(1,10000), // "memo" => "Smartyの使い方".rand(1,10000) // ); // $rowData1 = array( // "user_name" => "rabby".rand(1,10000), // "password" => "password".rand(1,10000) // ); // $rowData2 = array( // "number1" => rand(1,10), // "number2" => rand(1,10), // "number3" => rand(1,10), // "number4" => rand(1,10) // ); // $create_success = $db_table_content->create($rowData); // $create_success_1 = $db_table_content_1->create1($rowData1); // $create_success_2 = $db_table_content_2->create2($rowData2); // $smarty->assign("success", "ID " . $create_success . " is created."); // $smarty->assign("success_1", "ID" .$create_success_1 . " is created."); // $smarty->assign("success_2", "ID" .$create_success_2 . " is created."); // } // else // { // /** new data creation is disabled */ // $smarty->assign("success", "[New data creation is disabled for Tutorial.]
But it can be enable by module's specified define file."); // $smarty->assign("success_1", "[New data creation is disabled for Tutorial.]
But it can be enable by module's specified define file."); // $smarty->assign("success_2", "[New data creation is disabled for Tutorial.]
But it can be enable by module's specified define file."); // } /** */ // $d = array(); // /**Data display for content table */ // $read_data = $db_table_content->read(); // $read_data_1 = $db_table_content_1->read1(); // $read_data_2 = $db_table_content_2->read2(); // $allColumnName = $db_table_content_2->getColumnName(); // $getXColumn = $db_table_content_2->getXColumn(); // $getYColumn = $db_table_content_2->getYColumn(); //echo $tableName; //print_r($allColumnName); //$i=json_encode($read_data_2); //print_r($i); //print_r($getXColumn); //print_r($getYColumn); // $smarty->assign("numTableName", $numTableName); // $smarty->assign("columnOption", $columnOption); // $smarty->assign("chartOption", $chartOption); // $smarty->assign("chartSelect", $chartSelect); // $smarty->assign("getXColumn",$getXColumn); // $smarty->assign("getYColumn",$getYColumn); // $smarty->assign("content_data_all", $read_data); // $smarty->assign("content_data_all_1", $read_data_1); // $smarty->assign("content_data_all_2", $read_data_2); /** */ /**Module Program Start */ // $smarty->assign("app", APP_NAME); // $smarty->assign("db", DB_NAME); // $smarty->assign("dbtable", TABLE_NAME); // $smarty->assign("dbtable1", TABLE_NAME_1); // $smarty->assign("dbtable2", TABLE_NAME_2); // $smarty->assign("module", MODULE_NAME); // $smarty->assign("title", MODULE_HTML_TITLE); // $smarty->assign("name", MODULE_HTML_TITLE_NAME); //$smarty->display('index.tpl'); //$smarty->display('index1.tpl'); //$smarty->display('index2.tpl'); //$smarty->display('index3.tpl'); //$smarty->display('index4.tpl'); // $smarty->display('index5.tpl'); /**Module Program End */ ?>