<?php
require_once 'link.php';
require_once 'class/Database.class.php';
$params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link');
$database = new Database($params);
$queryDate = "SELECT * FROM `source_link` WHERE `project_link` = '8'";
$arrayQueryDate = $database->listRecord($database->query($queryDate));
$currentWorkMonth = $arrayQueryDate[0]['link_month'];
$currentWorkYear = $arrayQueryDate[0]['link_year'];
foreach ($working_data as $key => $value) {
array_pop($working_data[$key]);
$working_data[$key] = array_values($working_data[$key]);
}
$finalArray = array();
$arrayDate = array();
foreach ($working_data[0] as $key => $value) {
if (is_numeric($value) == 1 && trim($value) != '') {
if ($value > 0 && $value <= 9) {
$arrayDate[] = '0' . $value . '/' . $currentMonth . '/' . $currentWorkYear;
} else {
$arrayDate[] = $value . '/' . $currentMonth . '/' . $currentWorkYear;
}
} else {
continue;
}
}
unset($working_data[0]);
unset($working_data[1]);
$working_data = array_values($working_data);
for ($i = 0; $i < count($working_data); $i++) {
<?php
require_once 'function.php';
require_once 'class/Database.class.php';
$params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link');
$database = new Database($params);
$currentMonth = date('m');
/* New Custom */
for ($i = 1; $i <= 11; $i++) {
$queryProject = "SELECT * FROM `source_link` WHERE `project_link` = " . $i . " ORDER BY `link_month` DESC LIMIT 1";
$arraySource[] = $database->listRecord($database->query($queryProject));
}
/* End New Custom */
/* $querySource = "SELECT * FROM source_link WHERE `link_month` = '".$currentMonth."'";
$arraySource = $database->listRecord($database->query($querySource));
if(empty($arraySource)) {
$currentMonth = date('m') - 1;
$querySource = "SELECT * FROM source_link WHERE `link_month` = '".$currentMonth."'";
$arraySource = $database->listRecord($database->query($querySource));
} */
$today = date("d/m/Y");
for ($i = 0; $i < count($arraySource); $i++) {
switch ($arraySource[$i][0]['project_link']) {
case 1:
$maintenance_url = $arraySource[$i][0]['link'];
break;
case 2:
$newcoding_url = $arraySource[$i][0]['link'];
break;
case 3:
$domestic_url = $arraySource[$i][0]['link'];
<?php
require_once 'function.php';
require_once 'process_all.php';
require_once 'class/Database.class.php';
$paramsWork = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'work');
$paramsUser = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'user');
$paramsProject = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'project_type');
$databaseWork = new Database($paramsWork);
$databaseUser = new Database($paramsUser);
$databaseProject = new Database($paramsProject);
$queryUser = '******';
$queryProject = 'SELECT * FROM project_type';
$arrayUser = $databaseUser->listRecord($databaseUser->query($queryUser));
$arrayProject = $databaseProject->listRecord($databaseProject->query($queryProject));
//Import Maintenance Data
if (!empty($arrayMaintenance)) {
foreach ($arrayMaintenance['Maintenance'] as $key => $value) {
if (empty($arrayMaintenance['Maintenance'][$key])) {
unset($arrayMaintenance['Maintenance'][$key]);
} else {
$arrayMaintenance['Maintenance'][$key] = array_change_key_case($arrayMaintenance['Maintenance'][$key], CASE_LOWER);
foreach ($arrayUser as $k => $v) {
if ($arrayMaintenance['Maintenance'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayMaintenance['Maintenance'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach ($arrayProject as $e => $q) {
if ($arrayMaintenance['Maintenance'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayMaintenance['Maintenance'][$key]['project_type'] = $arrayProject[$e]['id'];
}
Update successful!
</div>';
}
} else {
$databaseSource->insert($arraySource, 'single');
if ($databaseSource->affectedRows() > 0) {
$message = '<div class="alert alert-success">
<button class="close" data-dismiss="alert"></button>
Insert successful!
</div>';
}
}
}
if (isset($_GET['type']) && $_GET['type'] == 'edit') {
$queryEdit = "SELECT * FROM source_link WHERE `id` = {$_GET['idLink']}";
$arrayEdit = $databaseSource->listRecord($databaseSource->query($queryEdit));
}
if (isset($_POST['form_edit']) && trim($_POST['form_edit']) != '') {
$arraySource = array();
$arrayDate = explode(' ', $_POST['google_date']);
$month = $arrayDate[0];
$year = $arrayDate[1];
foreach ($_POST as $key => $value) {
$arraySource['link'] = $_POST['google_link'];
$arraySource['link_month'] = $month;
$arraySource['link_year'] = $year;
$arraySource['project_link'] = $_POST['google_project'];
}
$arrayWhere = array(array('id', $_POST['form_edit'], null));
$databaseSource->update($arraySource, $arrayWhere);
if ($databaseSource->affectedRows() > 0) {
<?php
require_once 'function.php';
require_once 'class/Database.class.php';
$params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'source_link');
$database = new Database($params);
$currentMonth = date('m');
$querySource = "SELECT * FROM source_link WHERE `link_month` = '" . $currentMonth . "'";
$arraySource = $database->listRecord($database->query($querySource));
$today = date("d/m/Y");
for ($i = 0; $i < count($arraySource); $i++) {
switch ($arraySource[$i]['project_link']) {
case 1:
$maintenance_url = $arraySource[$i]['link'];
break;
case 2:
$newcoding_url = $arraySource[$i]['link'];
break;
case 3:
$domestic_url = $arraySource[$i]['link'];
break;
case 4:
$newton_url = $arraySource[$i]['link'];
break;
case 5:
$research_url = $arraySource[$i]['link'];
break;
case 6:
$other_url = $arraySource[$i]['link'];
break;
case 7:
<?php
require_once 'class/Database.class.php';
$params = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'manage_user', 'table' => 'news');
$database = new Database($params);
$position = $_GET['position'];
$item = $_GET['item'];
$query = "SELECT `id`, `title`, `description` FROM `news` LIMIT {$position}, {$item}";
$list = $database->listRecord($query);
$xhtml = '';
if (!empty($list)) {
foreach ($list as $key => $value) {
$xhtml .= '<div class="item">
<h3 class="title">' . $value['title'] . '</h3>
<p>' . $value['description'] . '</p>
</div>';
}
}
echo $xhtml;
$databaseProject = new Database($paramsProject);
$databaseWork = new Database($paramsWork);
$arrayUser = $databaseUser->listRecord($databaseUser->query('SELECT * FROM user'));
$arrayProject = $databaseProject->listRecord($databaseProject->query('SELECT * FROM project_type'));
$datePost = '';
$userPost = '';
$arrayWork = array();
/* echo '<pre>';
print_r($arrayUser);
echo '</pre>';
die(); */
if (isset($_POST['date_search']) && isset($_POST['user_name']) && trim($_POST['date_search']) != '' && trim($_POST['user_name']) != '') {
$datePost = $_POST['date_search'];
$userPost = $_POST['user_name'];
$queryWork = "SELECT * FROM `work` WHERE `work_date` = '{$_POST['date_search']}' AND `user` = {$_POST['user_name']}";
$arrayWork = $databaseWork->listRecord($databaseWork->query($queryWork));
foreach ($arrayWork as $key => $value) {
foreach ($arrayProject as $k => $v) {
if ($arrayWork[$key]['project_type'] == $arrayProject[$k]['id']) {
$arrayWork[$key]['project_type'] = $arrayProject[$k]['project_type'];
}
}
}
}
if (isset($_POST['date_show'])) {
$datePost = $_POST['date_show'];
$queryWork = "SELECT * FROM `work` WHERE `work_date` = '{$datePost}' ORDER BY `user` ASC";
$arrayWork = $databaseWork->listRecord($databaseWork->query($queryWork));
foreach ($arrayWork as $key => $value) {
foreach ($arrayProject as $k => $v) {
if ($arrayWork[$key]['project_type'] == $arrayProject[$k]['id']) {
<?php
require_once 'Database.class.php';
$paramsWorktime = array('server' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'management', 'table' => 'work_time');
$dbWorktime = new Database($paramsWorktime);
$queryWorktime = 'SELECT * FROM `work_time`';
$arraydbWorktime = $dbWorktime->listRecord($dbWorktime->query($queryWorktime));
