<?php
include_once '../common/DatabaseConnection.php';
include 'mail.php';
require 'PHPMailerAutoload.php';
$db1 = new DatabaseConnection();
$db1->createConnection();
$res = wwwcopy("todayTask.php");
$sqlC = "select\n\t\t\t\ts.ScheduleMaintenancePK,\n\t\t\t\ts.ArtefactCode,\n\t\t\t\ta.ArtefactName,\n\t\t\t\ts.ScheduledServiceDate\n\t\t\t\tfrom scheduledmaintenance s\n\t\t\t\tinner join artefact a\n\t\t\t\ton s.ArtefactCode = a.ArtefactCode\n\t\t\t\twhere s.ScheduleMaintenancePK\n\t\t\t\tnot in (select ScheduleMaintenanceFK from tasklist)\n\t\t\t\tand s.ScheduledServiceDate <= current_date()\n\t\t\t\tand a.visiblestatus='on'";
$resu1 = $db1->setQuery($sqlC);
if ($resu1->num_rows > 0) {
$sql1 = "select FirstName,LastName,EmailId\n\t\t\t\t\tfrom user";
$resu1 = $db1->setQuery($sql1);
if ($resu1->num_rows > 0) {
while ($r = $resu1->fetch_assoc()) {
$name = $r['FirstName'] . " " . $r['LastName'];
$email = $r['EmailId'];
$res1 = str_replace("{{user}}", $name, $res);
echo sendMail($email, $res1);
}
}
}
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
for ($i = 0; $i < 2; $i++) {
if ($i == 0) {
$release = true;
$folder = '../../../../_release/' . $app_version . '/_demo_site/';
} else {
$release = false;
$folder = '../../../../_release/' . $app_version . '/altair_v' . $app_version . '/admin/dist/';
}
if (is_dir($folder)) {
array_map('unlink', glob($folder . "*.html"));
}
wwwcopy($server_url . "login.php?generate&release=" . $release, $folder . "login.html");
wwwcopy($server_url . "error_404.php?generate&release=" . $release, $folder . "error_404.html");
wwwcopy($server_url . "error_500.php?generate&release=" . $release, $folder . "error_500.html");
$files = glob('../../php/views/*.php', GLOB_BRACE);
foreach ($files as $file) {
$file = str_replace('../../php/views/', '', $file);
$file = str_replace('.php', '', $file);
wwwcopy($server_url . "index.php?generate&release=" . $release . "&page=" . $file, $folder . $file . ".html");
}
}
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$finish = $time;
$total_time = round($finish - $start, 4);
echo "All done!<br>";
echo "Pages generated in " . $total_time . " seconds<br>";
<?php
//abyasiId=ghj&firstName=ghj&middleName=j&lastName=jgh&email=fghf%40emnail.com&location=421&roles=2
include '../common/DatabaseConnection.php';
include '../mail/mail.php';
$db = new DatabaseConnection();
$db->createConnection();
$abyasiId = $_GET['abyasiId'];
$fname = $_GET['firstName'];
$nname = $_GET['middleName'];
$lname = $_GET['lastName'];
$password = $_GET['password'];
$email = $_GET['email'];
$location = $_GET['location'];
$role = $_GET['roles'];
$sql = "INSERT INTO user VALUES\n\t\t\t\t\t\t(NULL,\n\t\t\t\t\t\t'{$location}',\n\t\t\t\t\t\t'{$role}',\n\t\t\t\t\t\t'{$password}',\n\t\t\t\t\t\tNULL,\n\t\t\t\t\t\t'{$abyasiId}',\n\t\t\t\t\t\t'{$fname}',\n\t\t\t\t\t\t'{$nname}',\n\t\t\t\t\t\t'{$lname}',\n\t\t\t\t\t\t'{$email}',\n\t\t\t\t\t\t'1',\n\t\t\t\t\t\tCURRENT_TIMESTAMP,\n\t\t\t\t\t\t'1',\n\t\t\t\t\t\tCURRENT_TIMESTAMP,\n\t\t\t\t\t\t'on')";
$result = $db->setQuery($sql);
if ($result) {
$res = wwwcopy("mailfile.php");
$res1 = str_replace("{{user}}", $fname, $res);
$res2 = str_replace("{{username}}", $abyasiId, $res1);
$res3 = str_replace("{{password}}", $password, $res2);
sendMail($email, $res3);
echo 'success';
} else {
echo $sql;
}
