function notificacionesIniciales()
{
$conexion = connectDB();
$seccion = $_POST['seccion'];
$prioridad = $_POST['prioridad'];
$estado = $_POST['estado'];
$tipo = $_POST['tipo'];
$query = "call spCargaNotificacionesDir('" . $seccion . "','" . $prioridad . "','" . $estado . "','" . $tipo . "')";
echo '<div id="contAll">';
$hacer_consulta = mysqli_query($conexion, $query);
while ($result = mysqli_fetch_array($hacer_consulta, MYSQLI_ASSOC)) {
$id = utf8_encode($result['pinSubrogacion']);
echo '<div class="rowTable"><center>' . utf8_encode($result['servicioSubrogar']) . ' | ' . utf8_encode($result['estudioSubrogar']) . ' | ' . utf8_encode($result['nombre']) . ' ' . utf8_encode($result['apellidoPaterno']) . ' | ' . utf8_encode($result['estado']) . ' | ' . utf8_encode($result['seccion']) . ' | ' . utf8_encode($result['tipoServicio']) . '
</center><div id="Tit"></div>
<div class="rowButtons">
<input type="button" class="btnsNotif" id="' . $id . '" onclick="revisarSolicitud(this.id,0)" value="Ver" onclick=""></input>
<input type="button" class="btnsNotif" id="' . $id . '" onclick="revisarSolicitud(this.id,1)" value="Aprobar"></input>
<input type="button" class="btnsNotif" id="' . $id . '" onclick="revisarSolicitud(this.id,2)" value="Denegar"></input>
</div>
</div>
<br>
';
}
echo '</div>';
}
function cleanUp()
{
if ($_SESSION['cMethod'] == 'new' || $_SESSION['dbCreateMethod'] == 'new') {
if (!connectDB()) {
return false;
}
if (isset($_SESSION['dbInfo']['dbOHRMUserName'])) {
$query = dropUser();
}
$query[0] = dropDB();
$sucExec = $query;
$overall = true;
for ($i = 0; $i < count($query); $i++) {
$sucExec[$i] = mysql_query($query[$i]);
if (!$sucExec[$i]) {
$overall = false;
}
}
if (!$overall) {
connectDB();
for ($i = 0; $i < count($query); $i++) {
if (!$sucExec[$i]) {
$sucExec[$i] = mysql_query($query[$i]);
}
if (!$sucExec[$i]) {
$overall = false;
}
}
}
}
$sucExec[] = delConf();
return $sucExec;
}
function loginOverride($coreUserInfo)
{
global $gasDatabaseName;
if ($coreUserInfo["ErrorCode"] == 0) {
$tableName = "Employee";
$uid = $coreUserInfo["Result"]["Uid"];
connectDB($gasDatabaseName);
$sql = "select * from {$tableName} where Uid = '{$uid}'";
$data = getData($sql);
// 该用户是否已经注册
if (empty($data)) {
printResultByMessage("用戶未註冊", 1001);
}
$data = $data[0];
// 该gasman是否通过瓦斯行的审核
if ($data["Verify"] === "0") {
printResultByMessage("請通知瓦斯行進行審核", 1002);
}
$info = array();
foreach ($data as $key => $value) {
$info["{$key}"] = $value;
}
foreach ($coreUserInfo["Result"] as $key => $value) {
$info["{$key}"] = $value;
}
$_SESSION["Info"] = $info;
echo json_encode($coreUserInfo);
die;
}
}
function extractBase($build, $runid, $catFilterID = '0', $compFilterID = '0')
{
$link = connectDB();
$sql = "SELECT caseResults.caseID as caseid, versions.versionFull as build,caseStatus.caseStatus as status, caseResults.caseExecutionTime as time , " . "scriptResults.scriptCommandLine as runtype, runs.runner as user , cases.caseName as caseName, cases.categoryID as category, cases.componentID as component " . "FROM cases, caseResults, caseStatus, scriptResults, runs, versions " . "WHERE versions.versionID = runs.versionID and runs.runID = scriptResults.runID and caseResults.caseStatusID = caseStatus.caseStatusID " . "and cases.scriptID = scriptResults.scriptID and caseResults.scriptResultID = scriptResults.scriptResultID " . "and caseResults.caseID = cases.caseID and versions.buildNum = " . $build . " and runs.runID = " . $runid;
$sql .= $catFilterID ? $compFilterID ? ' and cases.categoryID = ' . $catFilterID . ' and cases.componentID = ' . $compFilterID . ';' : ' and cases.categoryID = ' . $catFilterID . ';' : ';';
//$sql .= ($compFilterID)?' and cases.componentID = ' .$compFilterID .';': ';';
$result = mysql_query($sql, $link);
$number = mysql_num_rows($result);
if ($number > 0) {
while ($cases = mysql_fetch_assoc($result)) {
$runtype = runTypeBaseline($cases['user'], $cases['runtype']);
$casename = caseNameIssue($cases['caseName']);
if ($runtype == "Nothing" or $casename) {
continue;
}
//means userid is nightly but runtype is not Smoke.
if ($runtype == "NoSmokeReg") {
mysql_close($link);
return 0;
}
$time = sec2Basetime($cases["time"]);
$baseline = $cases['status'] . "(" . $time . ")(" . $cases['build'] . ")(" . $runtype . ")";
updateBaseline($baseline, $cases['caseid'], $cases['category'], $cases['component'], $runtype);
}
baselineStatus($baseline);
mysql_close($link);
return 1;
} else {
return 0;
}
}
function checkout($id)
{
$now = date('Y-m-d H:i:s');
$now_day = date('d', strtotime($now));
$now_month = date('m', strtotime($now));
$now_year = date('Y', strtotime($now));
$connect = connectDB();
$db = mysql_select_db('contacttime', $connect);
if (!$db) {
die('データベース選択失敗です。' . mysql_error());
}
//前に開始していない場合にエラーを出す
$result = mysql_query("select * from time where id = " . $id . " and end is not NULL");
$row = mysql_fetch_assoc($result);
if (!empty($row)) {
echo '<div class="alert alert-block">すでに終了しています</div>';
} else {
//その日の23：59：59秒までしか有効ではない
$result = mysql_query("select * from time where id = " . $id);
$row = mysql_fetch_assoc($result);
$start = date('d', strtotime($row["start"]));
$start_month = date('m', strtotime($row["start"]));
$start_year = date('Y', strtotime($row["start"]));
if ($now_day > $start || $now_month > $start_month || $now_year > $start_year) {
$now = $start_year . '-' . $start_month . '-' . $start . ' 23:59:59';
var_dump($now);
}
$result = mysql_query("update time set end = '" . $now . "' where id = " . $id);
if (!$result) {
die('クエリーが失敗しました。' . mysql_error());
}
}
mysql_close($connect);
}
function reconnectDB()
{
global $db;
if (!$db->ping()) {
connectDB(false);
}
}
function executeDB($sql)
{
connectDB();
mysql_query("SET NAMES UTF8") or die('query failed:' . mysql_error());
mysql_query($sql);
return mysql_affected_rows();
}
function checkHowManyImages()
{
$con = connectDB();
$aantalImage = $con->query("SELECT COUNT(image) FROM image");
$row = $aantalImage->fetch_row();
return $row[0];
}
function run()
{
$go = new ShortURL();
if( isset( $this->request['action'] ) )
{
if( $this->request['action'] == 'add' )
{
$go->print_results();
}
elseif( $this->request['action'] == 'req' )
{
$go->print_request_form();
}
elseif( $this->request['action'] == 'email' )
{
$go->send_email();
}
}
else
{
$go->print_form();
}
//Since we connected to a different DB inside ShortURL, we need to
//reconnect to Reason after we are done.
connectDB( REASON_DB );
}
function getArraySQL($sql)
{
//Creamos la conexión con la función anterior
$conexion = connectDB();
//generamos la consulta
mysqli_set_charset($conexion, "utf8");
//formato de datos utf8
$result = mysqli_query($conexion, $sql);
if (!$sql) {
echo "La consulta no se logró: " . mysql_error();
die;
//si la conexión cancelar programa
}
//creamos un array
$rawdata = array();
//guardamos en un array multidimensional todos los datos de la consulta
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$rawdata[$i] = $row;
$i++;
}
header("Content-type: application/json");
header("Access-Control-Allow-Origin: *");
disconnectDB($conexion);
//desconectamos la base de datos
return $rawdata;
//devolvemos el array
}
function getArraySQL($sql, $DB)
{
//Creamos la conexión con la función anterior
$conexion = connectDB();
mysqli_select_db($conexion, $DB);
//selecciono la base de datos
//generamos la consulta
mysqli_set_charset($conexion, "utf8");
//formato de datos utf8
if (!($result = mysqli_query($conexion, $sql))) {
die;
}
//si la conexión cancelar programa
$rawdata = array();
//creamos un array
//guardamos en un array multidimensional todos los datos de la consulta
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$rawdata[$i] = $row;
$i++;
}
disconnectDB($conexion);
//desconectamos la base de datos
return $rawdata;
//devolvemos el array
}
function get_pronoun_id($subjP, $objP, $possDetP, $possP, $reflexP)
{
$pronoun_hash = hashPronouns($subjP, $objP, $possDetP, $possP, $reflexP);
$db = connectDB();
try {
$stmt = $db->prepare("SELECT pronoun_id FROM cr_pronouns WHERE pronoun_hash=:pronoun_hash;");
$stmt->bindValue(':pronoun_hash', $pronoun_hash, PDO::PARAM_STR);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (sizeOf($rows) != 0) {
$pronounID = $rows[0]['pronoun_id'];
} else {
$stmt = $db->prepare("INSERT INTO cr_pronouns(pronoun_id, pronoun_hash, subj, obj, poss_det, poss_pro,\n reflexive) VALUES('', :pronoun_hash, :subj, :obj, :poss_det, :poss_pro,\n :reflexive);");
$stmt->bindValue(':pronoun_hash', $pronoun_hash, PDO::PARAM_STR);
$stmt->bindValue(':subj', $subjP, PDO::PARAM_STR);
$stmt->bindValue(':obj', $objP, PDO::PARAM_STR);
$stmt->bindValue(':poss_det', $possDetP, PDO::PARAM_STR);
$stmt->bindValue(':poss_pro', $possP, PDO::PARAM_STR);
$stmt->bindValue(':reflexive', $reflexP, PDO::PARAM_STR);
$stmt->execute();
$stmt = $db->prepare("SELECT pronoun_id FROM cr_pronouns WHERE pronoun_hash=:pronoun_hash;");
$stmt->bindValue(':pronoun_hash', $pronoun_hash, PDO::PARAM_STR);
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$pronounID = $rows[0]['pronoun_id'];
}
} catch (PDOException $ex) {
header("Location: ./register?err=pronoun");
}
return $pronounID;
}
function login($username, $mdp)
{
session_start();
$link = connectDB();
// Requête qui va chercher dans la BDD la ligne qui correspond
// à la combinaison utilisateur/mot de passe
$query = 'SELECT id_Utilisateur
FROM Utilisateur
WHERE nom_Utilisateur = "' . mysqli_real_escape_string($link, $username) . '" AND
MDP_Utilisateur = "' . mysqli_real_escape_string($link, HashPassword($mdp)) . '"';
$row = queryDB($query);
// Si une seule combinaison utilisateur/mdp ressort de la requête,
// on le connecte
if (count($row) == 1) {
// Requête pour inserer l'id de l'utilisateur dans la table de connexion
$query = "INSERT INTO Connexion(User_Connexion)\n VALUES (" . $row['id_Utilisateur'] . ")";
queryDB($query);
// On met en variables de session
// Que l'utilisateur est connecté
$_SESSION['isloged'] = true;
// Son pseudo
$_SESSION['user'] = $username;
// Son id
$_SESSION['id_user'] = $row['id_Utilisateur'];
return true;
} else {
// Login Not Ok
$_SESSION['isloged'] = false;
return false;
}
}
function getTitle($type, $id)
{
$mysqli = connectDB();
$result = $mysqli->query("SELECT title FROM " . $type . "s WHERE " . $type . "_id = '" . $id . "'");
$row = $result->fetch_object();
return $row->title;
}
function emailExists($email)
{
$pdo = connectDB();
$stmt = $pdo->prepare('SELECT EXISTS(SELECT 1 FROM Users WHERE Email LIKE :email)');
$stmt->execute(array(':email' => $email));
$fetch = $stmt->fetch();
return (int) $fetch[0];
}
public function saveClothData()
{
$mysqli = connectDB();
$query = "UPDATE Clothes\n\t\t\t\t\tSET ActualAmount = {$this->actualAmount}\n\t\t\t\t\tWHERE id={$this->fk_Clothes}";
//echo "$query";
$mysqli->query($query);
$mysqli->close();
}
function getCountiesMap()
{
global $mysqli;
connectDB();
$result_set = $mysqli->query("\n SELECT * FROM `counties`\n WHERE NOT(`map` = ' ')\n ");
closeDB();
return resultSetToArray($result_set);
}
function getFile($limit)
{
global $mysqli;
connectDB();
$result = $mysqli->query("SELECT * FROM `office`.`tbl_uploads` ORDER BY `ID` DESC LIMIT {$limit}");
closeDB();
return resultToArray($result);
}
public function save()
{
$connection = connectDB();
$query = "UPDATE Transactions\n\t\t\t\tSET FirstName = '{$this->fname}',\n\t\t\t\tLastName = '{$this->lname}',\n\t\t\t\tEmail = '{$this->email}',\n\t\t\t\tPayment = '{$this->payment}',\n\t\t\t\tFinalToPay = '{$this->finalToPay}',\n\t\t\t\tPaypalMail = '{$this->PaypalMail}',\n\t\t\t\tBankNr = '{$this->BankNr}',\n\t\t\t\tAccountNr = '{$this->AccountNr}',\n\t\t\t\tStatusDate = '{$this->StatusDate}',\n\t\t\t\tRejectOption = '{$this->RejectOption}',\n\t\t\t\tOrderDate = '{$this->OrderDate}',\n\t\t\t\tReceptionDate = '{$this->ReceptionDate}',\n\t\t\t\tProcessedDate = '{$this->ProcessedDate}',\n\t\t\t\tPaymentDate = '{$this->PaymentDate}',\n\t\t\t\tFinishedDate = '{$this->FinishedDate}'\n\t\t\t\tWHERE id={$this->id}";
echo $query;
mysql_query($query);
closeDB($connection);
}
function getEntryById($id)
{
$db = connectDB();
$results = query($db, "SELECT * FROM " . DB_TABLE . " WHERE id = :id", array(":id" => $id));
//should only be one
$entry = Entry::createFromDBRow($results[0]);
close($db);
return $entry;
}
function isAdmin($email)
{
global $mysqli;
connectDB();
$result_set = $mysqli->query("SELECT * FROM 'users' WHERE 'email'='{$email}'");
$row = $result_set->fetch_assoc();
closedDB();
return $row["admin"];
}
function getList($table, $page, $pageSize)
{
global $mysqli;
connectDB();
$first = ($page - 1) * $pageSize;
$result = $mysqli->query("SELECT * FROM {$table} ORDER BY id DESC LIMIT {$first}, {$pageSize}");
closeDB();
return resultToArray($result);
}
function getRecruitData()
{
$db = connectDB();
foreach ($db->query('SELECT name, vote_count, creation_date FROM recruit') as $row) {
echo "<font color='white'>" . $row['name'] . ' Vote Count:' . $row['vote_count'] . ' Start Date:' . $row['creation_date'];
?>
<br> <?php
}
}
function exeSQL($sql)
{
global $dbHost, $dbUser, $dbPwd, $dbName;
$con = connectDB($dbHost, $dbUser, $dbPwd);
mysql_select_db($dbName, $con);
$result = mysql_query($sql, $con);
mysql_close($con);
return $result;
}
function getLocation($mySessionID){
connectDB();
$sql = "SELECT location from sessions WHERE id='".$mySessionID."'";
$result=mysql_query($sql);
if (!$result) {
return "error";
}
$r=mysql_fetch_assoc($result);
return $r['location'];
}
function setHistory($options = array())
{
$defaultOptions = array();
$defaultOptions['page_name'] = '';
$defaultOptions['action_type'] = '';
$defaultOptions['table'] = '';
$defaultOptions['id_name'] = 'id';
$defaultOptions['id_value'] = '';
$defaultOptions['remote'] = false;
$defaultOptions['pname'] = '';
$options = array_merge($defaultOptions, $options);
extract($options);
$localcn = connectDB();
$user_id = $_SESSION['UserID'];
$user_name = $_SESSION['UserName'];
if ($localcn == '' || trim($action_type) == '' || trim($table) == '' || trim($id_value) == '' || trim($remote) == true && trim($pname) == '' || trim($action_type) != "add" && trim($action_type) != "delete" && trim($action_type) == 'edit') {
return false;
}
$connection_string = $localcn;
$remote_name = NULL;
if ($remote === true) {
$remoteCn = remote_connectDB($pname);
$connection_string = $remoteCn;
$remote_name = $pname;
}
$qry = "Select * from `{$table}` where {$id_name} = '{$id_value}'";
$res = Sql_exec($connection_string, $qry);
$result = Sql_fetch_assoc($res);
$value_json = json_encode($result);
if ($remoteCn) {
ClosedDBConnection($remoteCn);
rollback_main_connectDB();
}
if ($action_type == 'update') {
$comments = 'Updated !';
} elseif ($action_type == 'add') {
$comments = 'Inserted !';
}
$row_value = $value_json;
$action_command = $action_type;
if ($page_name == "") {
$page_name = $table;
}
$table_name = $table;
$action_date = date("Y-m-d", strtotime("now"));
$action_time = date("H:i:s", strtotime("now"));
$ip_address = $_SERVER['REMOTE_ADDR'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$referrer = $_SERVER['HTTP_REFERER'];
$qry = "INSERT INTO tbl_audit_trail (user_id,user_name,action_command,pname,page_name,table_name,primary_key_column,action_date,action_time,rowvalue,comments,ip_address,browser,referer) VALUES";
$qry .= "('{$user_id}','{$user_name}','{$action_command}','{$remote_name}','{$page_name}','{$table_name}','{$id_name}','{$action_date}','{$action_time}','{$row_value}','{$comments}','{$ip_address}','{$browser}', '{$referrer}');";
$result = Sql_exec($localcn, $qry);
$insert_id = Sql_insert_id($localcn);
return $insert_id;
}
function run()
{
if (is_file($this->params['code_include'])) {
include_once $this->params['code_include'];
} else {
echo "Could not include " . $this->params['code_include'];
}
if ($this->db_conn) {
connectDB($this->db_conn);
}
}
function getZip($zip)
{
header('Content-Type: application/json');
connectDB();
$sql = "select StateFullName, City from sl_zipcodes where ZipCode = " . mysql_real_escape_string($zip) . " LIMIT 1";
$query = mysql_query($sql) or die(mysql_error());
$array = mysql_fetch_array($query);
$json = array("StateFullName" => $array['StateFullName'], "City" => $array['City']);
$json = array_map('utf8_encode', $json);
$json = json_encode($json);
return $json;
}
function addData($name, $detail, $price, $qty)
{
$conn = connectDB("localhost", "root", "root", "dbData");
if (!$conn) {
sendResponse("error", "เกิดปัญหาในการติดต่อฐานข้อมูล");
return;
}
$sql = "insert into products (id, name, detail, price, qty) values ('', '{$name}','{$detail}', {$price}, \n{$qty})";
mysqli_query($conn, $sql) or die(sendResponse("error", "บันทึกข้อมูลไม่ได้") . $sql);
sendResponse("success", "บันทึกข้อมูลเรียบร้อยแล้ว");
$sqlStr = "select * from products order by id asc";
$qry = mysqli_query($conn, $sqlStr) or die(sendResponse("error", "ไม่พบข้อมูล"));
?>
<table width="600" border="1" cellspacing="2" cellpadding="5">
<tr>
<td>รหัสสินค้า</td>
<td>ชื่อสินค้า</td>
<td>รายละเอียด</td>
<td>ราคา</td>
<td>จ านวน</td>
</tr>
<?php
while ($rs = mysqli_fetch_array($qry)) {
?>
<tr>
<td><?php
echo $rs["id"];
?>
</td>
<td><?php
echo $rs["name"];
?>
</td>
<td><?php
echo $rs["detail"];
?>
</td>
<td><?php
echo $rs["price"];
?>
</td>
<td><?php
echo $rs["qty"];
?>
</td>
</tr>
<?php
}
mysqli_close($conn);
}
function selectTop()
{
$i = 0;
$con = connectDB();
$result2 = $con->query("SELECT image, name, cool FROM IMAGE ORDER BY cool DESC");
while ($row = mysqli_fetch_array($result2)) {
$return[$i]['image'] = $row["image"];
$return[$i]['name'] = $row["name"];
$return[$i]['cool'] = $row["cool"];
$i++;
}
return $return;
}
