$ws_number = 1;
// Установка, чтобы обработать только первый рабочий лист
for ($ws_n = 0; $ws_n < $ws_number; $ws_n++) {
$ws = $exc->worksheet['data'][$ws_n];
// Получение данных из рабочего листа
if (!$exc->worksheet['unicode'][$ws_n]) {
$db_table = $ws_name = $exc->worksheet['name'][$ws_n];
} else {
$ws_name = uc2html($exc->worksheet['name'][$ws_n]);
$db_table = convertUnicodeString($exc->worksheet['name'][$ws_n]);
}
echo "<div align=\"center\">Рабочий лист: <b>{$ws_name}</b></div><br>";
$max_row = $ws['max_row'];
$max_col = $ws['max_col'];
if ($max_row > 0 && $max_col > 0) {
getTableData(&$ws, &$exc);
} else {
fatal("Пустой рабочий лист");
}
}
}
if ($_POST['step'] == 2) {
// вставка данных в mysql (шаг 2)
echo "<br>";
extract($_POST);
$db_table = ereg_replace("[^a-zA-Z0-9\$]", "", $db_table);
$db_table = ereg_replace("^[0-9]+", "", $db_table);
if (empty($db_table)) {
$db_table = "Table1";
}
// Проверка соединения с базой данных
function drawGraph($tableName)
{
require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph.php';
require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_scatter.php';
require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_line.php';
require_once 'vendor/jpgraph/jpgraph/lib/JpGraph/src/jpgraph_utils.inc.php';
$GDT = getTableData($tableName);
$datax = $GDT['kp'];
$datay = $GDT['kpe'];
$x1 = array(0, 12);
$y1 = array(6.58, 22.78);
// $f = new FuncGenerator('cos($x)+1.5*cos(2*$x)');
// list($x1,$y1) = $f->E(0,10);
$graph = new Graph(400, 400);
$graph->SetScale("linlin");
$graph->img->SetMargin(60, 30, 30, 30);
//$graph->img->SetPadding(10,10,10,10)
$graph->SetShadow();
$graph->title->Set("Залежність між Кп та Кпе");
//$graph->title->SetFont(DejaVuSans);
$graph->yaxis->title->Set('Кп');
$graph->xaxis->title->Set('Кпе');
$sp1 = new ScatterPlot($datay, $datax);
$sp2 = new LinePlot($x1, $y1);
$graph->Add($sp1);
$graph->Add($sp2);
$sp2->SetColor("#f00");
$sp2->SetWeight(2);
$graph->Stroke();
}
unset($settings_data['promotes']);
unset($settings_data['tblvers']);
}
// load or update settings
foreach ($settings_data as $key => $value) {
$smcFunc['db_insert']('replace', '
{db_prefix}portamx_settings', array('varname' => 'string', 'config' => 'string'), array($key, $value), array('varname'));
}
_dbinst_write($dbstr);
}
}
}
if (!empty($drop)) {
// table exist ?
if (!empty($exist)) {
$updated[$tblname] = getTableData($tblname, $tblvers);
}
// drop table
$smcFunc['db_drop_table']('{db_prefix}' . $tblname);
$exist = false;
_dbinst_write('.. Table not identical, dropped.' . $newline);
}
if (empty($exist)) {
// create the table
$created[] = $tblname;
list($cols, $index, $params) = $tbldef;
$smcFunc['db_create_table']('{db_prefix}' . $tblname, $cols, $index, $params, 'error');
_dbinst_write('.. Table successful created.' . $newline);
if (!empty($updated[$tblname])) {
foreach ($updated[$tblname] as $id => $value) {
if ($tblname == 'portamx_blocks') {
} else {
Errors::report("Invalid value for action varriable.");
return;
}
}
$al->tp->assign('rep', $rep);
$al->tp->assign('err', $err);
$al->tp->assign('title', 'List of articles');
$al->tp->assign('selMenu', 'article');
$catList = getTableData('categories', $al->db);
if (is_string($catList)) {
$al->tp->assign('rep', $catList);
$catList = null;
}
if ($catList === false) {
$catList = null;
}
$al->tp->assign('catList', $catList);
$data = getTableData("articles", $al->db);
if (is_string($data)) {
$al->tp->assign('rep', $data);
$data = null;
}
if ($data === false) {
$data = null;
}
$al->tp->assign('data', $data);
$body = $al->tp->fetch('admin_menu.tpl');
$body .= $al->tp->fetch("view_arttable.tpl");
$al->tp->assign('body', $body);
$al->tp->display('admin.tpl');
}
}
if (isset($view)) {
switch ($view) {
case 'delete':
if (deleteTable()) {
$path = sprintf('location: ' . HTTP_PATH . 'public/views/%s.php', $_POST['page']);
header($path);
}
break;
case 'edit':
$list = getItemData($page, $_POST['id']);
break;
case 'list':
case 'add':
$list = getTableData($page);
break;
}
}
//returns a list of all filled rows in the specific table
function getTableData($page)
{
global $db;
if (!($_SESSION['user']['user_id'] == 1)) {
switch ($page) {
case 'appointments':
$sql = sprintf('SELECT tbl_%s.* FROM tbl_%s
LEFT JOIN tbl_customers
ON tbl_%s.customer_id = tbl_customers.customer_id
WHERE tbl_customers.deleted_at IS NULL', $page, $page, $page);
break;
function showTableDependings($tableName)
{
$dataTable = <<<EOT
<table class="table">
<thead>
<tr>
<td>№</td>
<td>Рівняння</td>
<td>Умова розрахунку</td>
<td>Граничний параметр</td>
<td>Значення граничного параметру</td>
<td>Коеф. кореляції</td>
</tr>
</thead>
<tbody>
EOT;
$GTD = getTableData($tableName);
$corelCoeficient = corellationCoeficient($GTD['kpe'], $GTD['kp']);
$CAB = calculateAB($GTD['kpe'], $GTD['kp']);
$A = $CAB['A'];
$B = $CAB['B'];
$corelCoeficientValue = number_format($corelCoeficient['value'], 2);
$corelCoeficientID = number_format($corelCoeficient['id'], 2);
$functionText = "Кп = " . number_format($A, 2) . " * Кп.еф + " . number_format($B, 2);
$umovaRoz = $_GET['dependence-data-2'];
$granychParam = number_format($A * $umovaRoz + $B, 2);
// $x1 = array(0, 12);
// $y1 = array(6.58, 22.78);
$dataTable .= <<<EOT
<tr>
<td>1</td>
<td>{$functionText}</td>
<td>{$umovaRoz}</td>
<td>Кп</td>
<td>{$granychParam}</td>
<td>{$corelCoeficientValue}</td>
</tr>
EOT;
$dataTable .= <<<EOT
</tbody>
</table>
EOT;
echo $dataTable;
}
$al->tp->assign('rep', "The category permission for id = " . $params[3] . " has been updated.");
} else {
Errors::report("Parameter 3: " . $params[2] . " is invalid for category toggle operation.");
break;
}
} else {
Errors::report("Second parameter of url: " . $params[1] . " is not valid.");
break;
}
}
}
if (!$al->tp->template_exists($tpl)) {
Errors::report("Template file: {$tpl} is missing.");
break;
}
$data = getTableData($table, $al->db);
if (is_string($data)) {
$al->tp->assign('rep', $data);
$data = null;
}
if ($data === false) {
$data = null;
}
$al->tp->assign('data', $data);
$body = $al->tp->fetch('admin_menu.tpl');
$body .= $al->tp->fetch($tpl);
$al->tp->assign('body', $body);
$al->tp->display('admin.tpl');
break;
default:
$al->tp->assign('title', 'Invalid request for page.');
if ($action == "edit") {
$fields = array('catname', 'mtype', 'date_updated');
$values = array(addslashes(trim($cname)), $mtype, date("Y-m-d H:i:s"));
$isUpdated = setRow('categories', $fields, $values, 'update', $al->db, $id);
if ($isUpdated) {
$rep .= "Category has been updated.";
} else {
$err .= "Your category was not updated. Please try again.";
}
} else {
Errors::report("Invalid value for action varriable.");
return;
}
}
$al->tp->assign('rep', $rep);
$al->tp->assign('err', $err);
$al->tp->assign('title', 'List of category');
$al->tp->assign('selMenu', 'category');
$data = getTableData("categories", $al->db);
if (is_string($data)) {
$al->tp->assign('rep', $data);
$data = null;
}
if ($data === false) {
$data = null;
}
$al->tp->assign('data', $data);
$body = $al->tp->fetch('admin_menu.tpl');
$body .= $al->tp->fetch("view_cattbl.tpl");
$al->tp->assign('body', $body);
$al->tp->display('admin.tpl');
list($month, $day, $year) = explode("/", $_POST['birthdate']);
$fields = array("email", "pass", "firstname", "lastname", "gender", "date_ofbirth", "utype", "ustatus", "date_updated");
$values = array(addslashes(trim($email)), addslashes(trim($password)), addslashes(trim($fname)), addslashes(trim($lname)), $sex, $year . "-" . $month . "-" . $day, $utype, $ustatus, date("Y-m-d G:i:s"));
$isUpdated = setRow('users', $fields, $values, 'update', $al->db, $uid);
if ($isUpdated) {
$rep .= "User has been updated.";
} else {
$err .= "Your user was not updated. Please try again.";
}
} else {
Errors::report("Invalid value for action varriable.");
return;
}
}
$al->tp->assign('rep', $rep);
$al->tp->assign('err', $err);
$al->tp->assign('title', 'List of users');
$al->tp->assign('selMenu', 'category');
$data = getTableData("users", $al->db);
if (is_string($data)) {
$al->tp->assign('rep', $data);
$data = null;
}
if ($data === false) {
$data = null;
}
$al->tp->assign('data', $data);
$body = $al->tp->fetch('admin_menu.tpl');
$body .= $al->tp->fetch("view_usertbl.tpl");
$al->tp->assign('body', $body);
$al->tp->display('admin.tpl');
include "../FORMS/usermodal.html";
}
//saves the edited values that were submitted from user update modal
if ($_POST['change'] === "edit") {
$email = $_POST['email'];
$fname = $_POST['firstname'];
$lname = $_POST['lastname'];
$userid = $_POST['primarykey'];
$accountlocked = $_POST['accountlocked'];
$loginattempts = $_POST['loginattempts'];
$sqlupdate = "UPDATE {$table} SET FirstName='{$fname}', LastName = '{$lname}', Email = '{$email}', AccountLocked = {$accountlocked}, LoginAttempts = {$loginattempts} WHERE {$PK}= '{$userid}'";
query($conn, $sqlupdate);
}
//adds a comment to a request
if ($_POST['change'] === 'editrequest') {
$comment = $_POST['comment'];
$requestid = $_POST['primarykey'];
$sqlupdate = "UPDATE {$table} SET Comment = '{$comment}' WHERE {$PK}={$requestid}";
query($conn, $sqlupdate);
}
//simply generates the table for the admin page. Works for both the requests and users table
if ($_POST['change'] === 'none') {
$sqlData = "SELECT * FROM {$table}";
$sqlTitles = "SHOW COLUMNS FROM {$table}";
$rsData = getTableData($conn, $sqlData);
$rsTitles = getTableData($conn, $sqlTitles);
$arrayData = getResultSet($rsData);
$arrayTitles = getResultSet($rsTitles);
generateTable($table, $PK, $arrayTitles, $arrayData);
}
}
switch ($_GET['method']) {
case 'get_table_names':
getTableNames($conn);
break;
case 'get_table_columns':
if (isset($_GET['table_name']) && $_GET['table_name'] != "") {
getTableColumns($conn, $_GET['table_name']);
} else {
$post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]');
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
echo $post_data;
}
break;
case 'get_table_data':
if (isset($_GET['table_name']) && $_GET['table_name'] != "") {
getTableData($conn, $_GET['table_name']);
} else {
$post_data = array('message' => 'missing parameters', 'comment' => 'require param [table_name]');
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
echo $post_data;
}
break;
case 'login':
if (isset($_GET['user_name']) && $_GET['user_name'] != "" && isset($_GET['password']) && $_GET['password'] != "") {
login($conn, $_GET['user_name'], $_GET['password']);
} else {
$post_data = array('message' => 'missing parameters', 'comment' => 'require param [user_name,password]');
$post_data = json_encode(array('error' => $post_data), JSON_FORCE_OBJECT);
echo $post_data;
}
break;
<?php
$URLS = [["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5C&sem=S2&yr=14", "IT5C"], ["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5B&sem=S2&yr=14", "IT5B"], ["https://tafetimetables.rmit.edu.au/btsTT/btstimetables.asp?desc=7&group=IT5A&sem=S2&yr=14", "IT5A"]];
foreach ($URLS as $URL) {
echo "<h1>" . $URL[0] . "</h1>";
$table = getTable($URL[0]);
$course = getTableData($table);
dbStore($course, $URL[1]);
}
function getTable($URL)
{
$page = file_get_contents($URL);
$key = "table_wrap'>";
$page = stristr($page, $key);
$end = stripos($page, "</div>");
$page = substr($page, strlen($key), $end);
return $page;
}
function getTableData($table)
{
$rows = explode("<tr", $table);
$i = 0;
foreach ($rows as $row) {
$course_rough[$i] = explode("<td>", $row);
$i++;
}
$count = count($course_rough);
$n = 0;
$line = array();
$course = array();
for ($i = 2; $i < $count; $i++) {
