本文整理汇总了PHP中bigintval函数的典型用法代码示例。如果您正苦于以下问题:PHP bigintval函数的具体用法?PHP bigintval怎么用?PHP bigintval使用的例子?那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了bigintval函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: T_
<div class="text"><input type='submit' name='submit' id='submit' value='<?php
echo T_("Add respondent");
?>
'/></div>
</form>
<div><a href="?"><?php
echo T_("Go back");
?>
</a></div>
<?php
} else {
print "<div class='text'>" . T_("Case id:") . " {$case_id}</div>";
print "<div class='text'>" . T_("Respondent:");
if (isset($_GET['respondent_id']) && $_GET['respondent_id'] != 0) {
$respondent_id = bigintval($_GET['respondent_id']);
$sql = "UPDATE `call_attempt` \r\n\t\t\tSET respondent_id = '{$respondent_id}'\r\n\t\t\tWHERE call_attempt_id = '{$call_attempt_id}'";
$db->Execute($sql);
}
/* List respondents
*
*/
$sql = "SELECT r.firstName, r.lastName, r.respondent_id,r.Time_zone_name,CASE WHEN c.respondent_id = r.respondent_id THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM respondent AS r\r\n\t\tLEFT JOIN call_attempt AS c ON ( c.call_attempt_id = '{$call_attempt_id}' )\r\n\t\tWHERE r.case_id = '{$case_id}'";
$rs = $db->GetAll($sql);
$timezone = "";
if (ALLOW_RESPONDENT_SELECTOR) {
print "<select id='respondent' name='respondent' onchange=\"LinkUp('respondent')\"><option value='?respondent_id=0' class='addresp'>" . T_("Add respondent") . "</option>";
if (!empty($rs)) {
foreach ($rs as $r) {
if (!empty($r['selected'])) {
$timezone = $r['Time_zone_name'];
示例2: _
}
} else {
$pw_meldung = _('Bitte gib mindestens 6 Zeichen für das Passwort ein!');
}
}
}
if (isset($_POST['urlaub_ende']) && $cookie_id != CONFIG_DEMO_USER) {
if ($cookie_team != '__' . $cookie_id) {
if (!isset($_SESSION['urlaub_min'])) {
$_SESSION['urlaub_min'] = 0;
}
if (!isset($_SESSION['urlaub_max'])) {
$_SESSION['urlaub_max'] = 0;
}
$ul_meldung = _('Du kannst leider keinen Urlaub beantragen, der so lange dauert.');
$urlaub_ende = bigintval($_POST['urlaub_ende']);
$temp = ceil(($urlaub_ende - time()) / 86400);
if ($temp >= 1 && $temp <= 30 && $aktueller_urlaub == '') {
// ART DES URLAUBS ANFANG
if ($temp >= 1 && $temp <= 10 && $_SESSION['urlaub_min'] <= $temp && $_SESSION['urlaub_max'] >= $temp) {
$sql1 = "UPDATE " . $prefix . "users SET last_urlaub_kurz = " . time() . " WHERE ids = '" . $cookie_id . "'";
$sql2 = mysql_query($sql1);
} elseif ($temp >= 11 && $temp <= 30 && $_SESSION['urlaub_min'] <= $temp && $_SESSION['urlaub_max'] >= $temp) {
$sql1 = "UPDATE " . $prefix . "users SET last_urlaub_lang = " . time() . " WHERE ids = '" . $cookie_id . "'";
$sql2 = mysql_query($sql1);
} else {
exit;
}
// ART DES URLAUBS ENDE
$sql3 = "INSERT INTO " . $prefix . "urlaub (user, team, ende) VALUES ('" . $cookie_id . "', '" . $cookie_team . "', '" . $urlaub_ende . "')";
$sql4 = mysql_query($sql3);
示例3: isset
$status_gambar_gs = isset($_REQUEST['status_gambar_gs']) ? to_number($_REQUEST['status_gambar_gs']) : '0';
$program = isset($_REQUEST['program']) ? to_number($_REQUEST['program']) : '0';
$luas_tanah = isset($_REQUEST['luas_tanah']) ? to_decimal($_REQUEST['luas_tanah']) : '0';
$disc_tanah = isset($_REQUEST['disc_tanah']) ? to_decimal($_REQUEST['disc_tanah'], 16) : '0';
$harga_disc_tanah = isset($_REQUEST['harga_disc_tanah']) ? to_number($_REQUEST['harga_disc_tanah']) : '0';
$ppn_tanah = isset($_REQUEST['ppn_tanah']) ? to_decimal($_REQUEST['ppn_tanah']) : '0';
$luas_bangunan = isset($_REQUEST['luas_bangunan']) ? to_decimal($_REQUEST['luas_bangunan']) : '0';
$disc_bangunan = isset($_REQUEST['disc_bangunan']) ? to_decimal($_REQUEST['disc_bangunan'], 16) : '0';
$ppn_bangunan = isset($_REQUEST['ppn_bangunan']) ? to_decimal($_REQUEST['ppn_bangunan']) : '0';
// HARGA DI TABEL SK
$kode_sk = isset($_REQUEST['kode_sk']) ? $_REQUEST['kode_sk'] : '';
$harga_cash_keras = isset($_REQUEST['harga_cash_keras']) ? bigintval($_REQUEST['harga_cash_keras']) : '0';
$CB36X = isset($_REQUEST['harga_CB36X']) ? bigintval($_REQUEST['harga_CB36X']) : '0';
$CB48X = isset($_REQUEST['harga_CB48X']) ? bigintval($_REQUEST['harga_CB48X']) : '0';
$KPA24X = isset($_REQUEST['harga_KPA24X']) ? bigintval($_REQUEST['harga_KPA24X']) : '0';
$KPA36X = isset($_REQUEST['harga_KPA36X']) ? bigintval($_REQUEST['harga_KPA36X']) : '0';
$lokasi = '';
$jenis_unit = '';
$harga_tanah_sk = '';
$faktor_strategis = '';
$tipe_bangunan = '';
$harga_bangunan_sk = '';
$jenis_penjualan = '';
$tgl_bangunan = '';
$tgl_selesai = '';
$progress = '';
$base_harga_tanah = 0;
$nilai_tambah = 0;
$nilai_kurang = 0;
$fs_harga_tanah = 0;
$disc_harga_tanah = 0;
示例4: die_login
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
try {
die_login();
// die_app('');
// die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$conn->begintrans();
$error = false;
if ($act == 'Apply') {
$query = "DELETE FROM RENCANA WHERE KODE_BLOK = '{$id}'";
ex_false($conn->execute($query), $query);
for ($a = 1; $a <= $max; $a++) {
$tgl_bayar = isset($_REQUEST['tanggal_bayar_' . $a]) ? clean($_REQUEST['tanggal_bayar_' . $a]) : '';
$nilai = isset($_REQUEST['nilai_' . $a]) ? bigintval($_REQUEST['nilai_' . $a]) : '';
$jb = isset($_REQUEST['jenis_bayar_' . $a]) ? bigintval($_REQUEST['jenis_bayar_' . $a]) : '';
$query = "INSERT INTO RENCANA (KODE_BLOK,TANGGAL,KODE_BAYAR, NILAI, KETERANGAN)\n\t\t\t\t\t\t\t\tVALUES('{$id}',\n\t\t\t\t\t\t\t\tCONVERT(DATETIME,'{$tgl_bayar}',105),\n\t\t\t\t\t\t\t\t'{$jb}',\n\t\t\t\t\t\t\t\t'{$nilai}',\n\t\t\t\t\t\t\t\t''\n\t\t\t\t\t\t\t)";
ex_false($conn->execute($query), $query);
}
$msg = 'Rencana pembayaran berhasil dibuat';
}
$conn->committrans();
} catch (Exception $e) {
$msg = $e->getmessage();
$error = TRUE;
if ($conn) {
$conn->rollbacktrans();
}
}
close($conn);
$json = array('act' => $act, 'error' => $error, 'msg' => $msg);
示例5: mysql_query
mysql_query($vomTMrunter3);
}
$close7 = "INSERT INTO " . $prefix . "helferLog (helfer, managerBestrafen, zeit, chatSperre, transferSperre, geldStrafe, verstoss) VALUES ('" . $cookie_id . "', '" . $managerBestrafen . "', " . time() . ", " . $chatSperre . ", " . $transferSperre . ", " . $geldStrafe . ", " . $verstoss . ")";
$close8 = mysql_query($close7);
} else {
$close7 = "INSERT INTO " . $prefix . "helferLog (helfer, managerBestrafen, zeit, chatSperre, transferSperre, geldStrafe, verstoss) VALUES ('" . $cookie_id . "', '" . $managerBestrafen . "', " . time() . ", " . $chatSperre . ", " . $transferSperre . ", " . $geldStrafe . ", " . $verstoss . ")";
$close8 = mysql_query($close7);
}
$anzSanktionen1 = "UPDATE " . $prefix . "users SET anzSanktionen = anzSanktionen+1 WHERE ids = '" . $managerBestrafen . "'";
mysql_query($anzSanktionen1);
addInfoBox('Die Strafe wurde ausgeführt.');
}
}
if (isset($_GET['un1']) && isset($_GET['un2'])) {
$un1 = mysql_real_escape_string(trim(strip_tags($_GET['un1'])));
$un2 = bigintval($_GET['un2']);
$unData1 = "SELECT geldStrafe FROM " . $prefix . "helferLog WHERE managerBestrafen = '" . $un1 . "' AND zeit = " . $un2;
$unData2 = mysql_query($unData1);
if (mysql_num_rows($unData2) == 1) {
$unData3 = mysql_fetch_assoc($unData2);
$geldStrafeBack = intval($unData3['geldStrafe']);
if ($geldStrafeBack != 0) {
$unData1 = "SELECT team FROM " . $prefix . "users WHERE ids = '" . $un1 . "'";
$unData2 = mysql_query($unData1);
if (mysql_num_rows($unData2) == 1) {
$unData3 = mysql_fetch_assoc($unData2);
$unGeld1 = "UPDATE " . $prefix . "teams SET konto = konto-" . $geldStrafeBack . " WHERE ids = '" . $unData3['team'] . "'";
mysql_query($unGeld1);
}
}
$un3 = "UPDATE " . $prefix . "helferLog SET chatSperre = zeit, transferSperre = zeit, geldStrafe = -1 WHERE managerBestrafen = '" . $un1 . "' AND zeit = " . $un2;
示例6: display_outcomes
/**
* Display appropriate outcomes based on current call attempt status
*
* @param int $contacted 0 for not contacted, 1 for contacted (a person on the phone)
* @param int $ca Call attempt id
* @param int $case_id The Case id
*
*/
function display_outcomes($contacted, $ca, $case_id)
{
global $db;
$completed = limesurvey_is_completed($case_id);
//see if the case is completed
if ($completed) {
$sql = "SELECT outcome_id,description\r\n\t\t\tFROM outcome\r\n\t\t\tWHERE outcome_id = 10";
} else {
if (limesurvey_is_quota_full($case_id)) {
$sql = "SELECT outcome_id,description\r\n\t\t\tFROM outcome\r\n\t\t\tWHERE outcome_id = 32";
} else {
//see if we have made an appointment on this call attempt
$sql = "SELECT appointment_id\r\n\t\t\tFROM appointment\r\n\t\t\tWHERE completed_call_id IS NULL\r\n\t\t\tAND call_attempt_id = '{$ca}'";
$rs = $db->GetAll($sql);
$outcomes = $db->GetOne("SELECT q.outcomes FROM `questionnaire` as q JOIN `case` as c ON (c.questionnaire_id =q.questionnaire_id) WHERE c.case_id = {$case_id}");
if (!empty($rs)) {
//we have an appointment made ... only select appointment ID's
$sql = "SELECT outcome_id,description\r\n\t\t\t\tFROM outcome\r\n\t\t\t\tWHERE outcome_type_id = '5'\r\n\t\t\t\tAND outcome_id IN ({$outcomes})";
} else {
if ($contacted === false) {
$ctd = "";
} else {
$contacted = bigintval($contacted);
$ctd = "AND contacted = '{$contacted}'";
}
$sql = "SELECT outcome_id,description\r\n\t\t\t\t\tFROM outcome\r\n\t\t\t\t\tWHERE outcome_type_id != '5'\r\n\t\t\t\t\t{$ctd}\r\n\t\t\t\t\tAND outcome_id IN ({$outcomes})\r\n\t\t\t\t\tAND outcome_id NOT IN(10,32,42,43,44,45)";
//don't show completed if not, Lime_Quota_full if not, hide max calls as they supposed to be automatic or admin-privileged
}
}
}
$rs = $db->GetAll($sql);
print "<div>";
if (!empty($rs)) {
$lime_sid = get_limesurvey_id(get_operator_id());
//Check to see if we have sent an email on this call and set the default outcome
$sql = "SELECT 41\r\n\t\t\tFROM `case` as c, " . LIME_PREFIX . "tokens_{$lime_sid} as t\r\n\t\t\tWHERE t.sent = '{$ca}'\r\n\t\t\tAND c.case_id = {$case_id}\r\n\t\t\tAND t.token = c.token";
$do = $db->GetOne($sql);
if (isset($_GET['defaultoutcome'])) {
$do = bigintval($_GET['defaultoutcome']);
}
foreach ($rs as $r) {
if ($do == $r['outcome_id']) {
$selected = "checked='checked'";
} else {
$selected = "";
}
print "<div><label class='label'><input type='radio' class='radio' name='outcome' id='outcome-{$r['outcome_id']}' value='{$r['outcome_id']}' {$selected}/>" . T_($r['description']) . "</label></div>";
}
}
print "</div>";
}
示例7: getChatroomData
function getChatroomData($chatroomid, $prelimit = 0, $lastMessages = 0)
{
global $guestsMode, $crguestsMode, $guestnamePrefix;
global $language;
global $userid;
global $cookiePrefix;
$usertable = TABLE_PREFIX . DB_USERTABLE;
$usertable_username = DB_USERTABLE_NAME;
$usertable_userid = DB_USERTABLE_USERID;
$messages = array();
$moremessages = array();
$guestpart = '';
$prependCondition = '';
$limitClause = " limit " . mysqli_real_escape_string($GLOBALS['dbh'], $lastMessages) . " ";
if (empty($prelimit) && empty($lastMessages)) {
if (!empty($_SESSION['cometchat']['cometchat_chatroom_' . $chatroomid])) {
$moremessages = $moremessages + $_SESSION['cometchat']['cometchat_chatroom_' . $chatroomid];
}
$messages = $messages + $moremessages;
krsort($messages);
return $messages;
} else {
if ($prelimit != '-1') {
$prelimit = bigintval($prelimit);
$prependCondition = "and (cometchat_chatroommessages.id < '" . mysqli_real_escape_string($GLOBALS['dbh'], $prelimit) . "')";
}
if ($guestsMode && $crguestsMode) {
$guestpart = " UNION select DISTINCT cometchat_chatroommessages.id id, cometchat_chatroommessages.message, cometchat_chatroommessages.sent, CONCAT('" . $guestnamePrefix . "',m.name) `from`, cometchat_chatroommessages.userid fromid, m.id userid from cometchat_chatroommessages join cometchat_guests m on m.id = cometchat_chatroommessages.userid where cometchat_chatroommessages.chatroomid = '" . mysqli_real_escape_string($GLOBALS['dbh'], $chatroomid) . "' and cometchat_chatroommessages.message not like '%banned_%' and cometchat_chatroommessages.message not like '%kicked_%' and cometchat_chatroommessages.message not like '%deletemessage_%' " . $prependCondition;
}
$sql = "select DISTINCT cometchat_chatroommessages.id id, cometchat_chatroommessages.message, cometchat_chatroommessages.sent, m.{$usertable_username} `from`, cometchat_chatroommessages.userid fromid, m.{$usertable_userid} userid from cometchat_chatroommessages join {$usertable} m on m.{$usertable_userid} = cometchat_chatroommessages.userid where cometchat_chatroommessages.chatroomid = '" . mysqli_real_escape_string($GLOBALS['dbh'], $chatroomid) . "' and cometchat_chatroommessages.message not like '%banned_%' and cometchat_chatroommessages.message not like '%kicked_%' and cometchat_chatroommessages.message not like '%deletemessage_%' " . $prependCondition . $guestpart . " order by id desc " . $limitClause;
$query = mysqli_query($GLOBALS['dbh'], $sql);
if (defined('DEV_MODE') && DEV_MODE == '1') {
echo mysqli_error($GLOBALS['dbh']);
}
while ($chat = mysqli_fetch_assoc($query)) {
if (function_exists('processName')) {
$chat['from'] = processName($chat['from']);
}
if ($lastMessages == 0) {
$chat['message'] = '';
}
if ($userid == $chat['userid']) {
$chat['from'] = $language[10];
} else {
if (!empty($_COOKIE[$cookiePrefix . 'lang']) && !(strpos($chat['message'], "CC^CONTROL_") > -1)) {
$translated = text_translate($chat['message'], '', $_COOKIE[$cookiePrefix . 'lang']);
if ($translated != '') {
$chat['message'] = strip_tags($translated) . ' <span class="untranslatedtext">(' . $chat['message'] . ')</span>';
}
}
}
$messages[$chat['id']] = array('id' => $chat['id'], 'from' => $chat['from'], 'fromid' => $chat['fromid'], 'message' => $chat['message'], 'sent' => $chat['sent']);
}
}
header('Content-type: application/json; charset=utf-8');
echo json_encode($messages);
}
示例8: bigintval
if (substr($key, 0, 5) == "start") {
$num = bigintval(substr($key, 6));
if (isset($_POST["use_{$num}"])) {
$sql = "UPDATE shift as s, operator as o\r\n\t\t\t\t\tSET s.start = CONVERT_TZ(CONCAT(STR_TO_DATE(CONCAT({$year}, ' ',{$woy},' ', {$_POST["dow_{$num}"]}),'%x %v %w'),' ','" . $_POST["start_{$num}"] . "'), o.Time_zone_name, 'UTC'),\r\n\t\t\t\t\ts.end = CONVERT_TZ(CONCAT(STR_TO_DATE(CONCAT({$year}, ' ',{$woy},' ', {$_POST["dow_{$num}"]}),'%x %v %w'),' ','" . $_POST["end_{$num}"] . "'), o.Time_zone_name, 'UTC')\r\n\t\t\t\t\tWHERE o.operator_id = '{$operator_id}'\r\n\t\t\t\t\tAND shift_id = '{$num}'";
$db->Execute($sql);
} else {
$sql = "DELETE FROM shift\r\n\t\t\t\t\tWHERE shift_id = '{$num}'";
$db->Execute($sql);
}
}
}
//insert new shifts
foreach ($_POST as $key => $val) {
if (substr($key, 0, 7) == "NEW_use") {
if ($val == "on") {
$num = bigintval(substr($key, 8));
$sql = "INSERT INTO shift (shift_id,questionnaire_id,start,end)\r\n\t\t\t\t\tSELECT NULL,'{$questionnaire_id}', CONVERT_TZ(CONCAT(STR_TO_DATE(CONCAT({$year}, ' ',{$woy},' ', {$_POST["NEW_dow_{$num}"]}),'%x %v %w'),' ','" . $_POST["NEW_start_{$num}"] . "'), Time_zone_name, 'UTC') , CONVERT_TZ(CONCAT(STR_TO_DATE(CONCAT({$year}, ' ',{$woy},' ', {$_POST["NEW_dow_{$num}"]}),'%x %v %w'),' ','" . $_POST["NEW_end_{$num}"] . "'), Time_zone_name, 'UTC')\r\n\t\t\t\t\tFROM operator\r\n\t\t\t\t\tWHERE operator_id = '{$operator_id}'";
$db->Execute($sql);
}
}
}
}
xhtml_head(T_("Shift management"), true, array("../include/bootstrap/css/bootstrap.min.css", "../include/clockpicker/dist/bootstrap-clockpicker.min.css", "../include/bootstrap-toggle/css/bootstrap-toggle.min.css", "../css/custom.css"), array("../include/jquery/jquery.min.js", "../include/bootstrap/js/bootstrap.min.js", "../include/clockpicker/dist/bootstrap-clockpicker.js", "../include/bootstrap-toggle/js/bootstrap-toggle.min.js", "../js/window.js"));
//"../css/shifts.css",
/**
* Display warning if timezone data not installed
*
*/
$sql = "SELECT CONVERT_TZ(NOW(),'SYSTEM','UTC') as t";
$rs = $db->GetRow($sql);
if (empty($rs) || !$rs || empty($rs['t'])) {
示例9: session_start
<?php
include 'zzserver.php';
session_start();
$hadresse = '/index.php?loggedout=1';
if (isset($_SESSION['loggedin'])) {
if ($_SESSION['loggedin'] == 1) {
$loggedOutTime = bigintval(getTimestamp('-301 seconds'));
$last_login1 = "UPDATE " . $prefix . "users SET last_login = " . $loggedOutTime . " WHERE ids = '" . $_SESSION['userid'] . "' AND last_login > " . $loggedOutTime;
$last_login2 = mysql_query($last_login1);
if ($_SESSION['status'] == 'Bigpoint' or isset($_SESSION['bigpoint'])) {
$hadresse = 'http://de.bigpoint.com/';
}
session_destroy();
unset($_SESSION['loggedin']);
unset($_SESSION['userid']);
unset($_SESSION['username']);
unset($_SESSION['liga']);
unset($_SESSION['team']);
unset($_SESSION['teamname']);
unset($_SESSION['anzeigen_wo']);
unset($_SESSION['transferGesperrt']);
}
}
$expired = getTimestamp('-1 hour');
setcookie("PHPSESSID", "", $expired, "/", str_replace('www.', '.', CONFIG_SITE_DOMAIN), FALSE, TRUE);
header("Location: " . $hadresse);
示例10: T_
//print "<h2>" . T_("Overall") . "</h2>";
//xhtml_table($rs,array("firstName","completions","totalcalls","time","callt","CPH","CALLSPH","effectiveness"),array(T_("Operator"),T_("Completions"),T_("Calls"),T_("Total time"),T_("Call time"),T_("Completions p/h"),T_("Calls p/h"),T_("Effectiveness")));
$questionnaire_id = false;
print "<h3 class='form-inline pull-left'>" . T_("Please select a questionnaire") . " </h3>";
if (isset($_GET['questionnaire_id'])) {
$questionnaire_id = bigintval($_GET['questionnaire_id']);
}
display_questionnaire_chooser($questionnaire_id, false, "form-inline clearfix", "form-control");
if ($questionnaire_id) {
$rs = get_stats_total(get_stats_by_questionnaire($questionnaire_id));
print "<h2>" . T_("This project") . "</h2>";
xhtml_table($rs, array("firstName", "completions", "totalcalls", "time", "callt", "CPH", "CALLSPH", "effectiveness"), array(T_("Operator"), T_("Completions"), T_("Calls"), T_("Total time"), T_("Call time"), T_("Completions p/h"), T_("Calls p/h"), T_("Effectiveness")));
$operator_id = get_operator_id();
$shift_id = false;
if (isset($_GET['shift_id'])) {
$shift_id = bigintval($_GET['shift_id']);
}
$sql = "SELECT s.shift_id as value,CONCAT(DATE_FORMAT(CONVERT_TZ(s.start,'UTC',o.Time_zone_name),'" . DATE_TIME_FORMAT . "'),' " . TQ_("till") . " ',DATE_FORMAT(CONVERT_TZ(s.end,'UTC',o.Time_zone_name),'" . TIME_FORMAT . "')) as description,CASE WHEN s.shift_id = '{$shift_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM shift as s\r\n\t\tLEFT JOIN (operator as o) on (o.operator_id = '{$operator_id}')\r\n\t\tWHERE s.questionnaire_id = '{$questionnaire_id}'\r\n\t\tORDER BY s.start ASC";
$rs = $db->GetAll($sql);
print "</br><h3 class='form-inline pull-left'>" . T_("Please select a shift") . " </h3>";
display_chooser($rs, "shift_id", "shift_id", true, "questionnaire_id={$questionnaire_id}", true, true, false, true, "form-inline form-group");
//,false,true,false,true,"pull-left"
if ($shift_id) {
$rs = get_stats_total(get_stats_by_shift($questionnaire_id, $shift_id));
print "<h2>" . T_("This shift") . "</h2>";
xhtml_table($rs, array("firstName", "completions", "totalcalls", "time", "callt", "CPH", "CALLSPH", "effectiveness"), array(T_("Operator"), T_("Completions"), T_("Calls"), T_("Total time"), T_("Call time"), T_("Completions p/h"), T_("Calls p/h"), T_("Effectiveness")));
}
}
xhtml_foot();
?>
示例11: to_money
?>
"></td>
</tr>
<tr>
<?php
?>
<td>Jumlah Diterima</td><td>:</td>
<td>Rp. <input type="text" name="jumlah" id="jumlah" size="15" value="<?php
echo to_money($jumlah);
?>
"></td>
</tr>
<tr>
<td>Terbilang </td><td>:</td>
<td colspan="2"><input type="text" name="terbilang" id="terbilang" size="98" readonly="readonly" style="text-transform:uppercase" value="<?php
echo ucfirst($terbilang->eja(bigintval($jumlah)));
?>
rupiah"></td>
</tr>
<tr>
<td>Koordinator</td><td>:</td>
<td>
<select name="koordinator" id="koordinator">
<option value=""> -- Koordinator -- </option>
<?php
$obj = $conn->execute("\t\t\n\t\t\t\t\tSELECT * FROM CLUB_PERSONAL\n\t\t\t\t\tWHERE JABATAN_KLUB = 4\n\t\t\t\t\tORDER BY NAMA \n\t\t\t\t\t");
while (!$obj->EOF) {
$ov = $obj->fields['NOMOR_ID'];
$oj = $obj->fields['NAMA'];
echo "<option value='{$ov}'" . is_selected($ov, $koordinator) . "> {$oj} </option>";
$obj->movenext();
示例12: questionnaire_prefill
if (!empty($_GET['svar']) && empty($_GET['value'])) {
$value = $svar;
}
$sql = "INSERT INTO questionnaire_prefill(questionnaire_id,lime_sgqa,value)\r\n\t\tVALUES('{$questionnaire_id}',{$sgqa},{$value})";
$db->Execute($sql);
}
if (isset($_GET['questionnaire_id']) && isset($_GET['questionnaire_prefill_id'])) {
//need to remove prefill from questionnaire
$questionnaire_id = bigintval($_GET['questionnaire_id']);
$questionnaire_prefill_id = bigintval($_GET['questionnaire_prefill_id']);
$sql = "DELETE FROM questionnaire_prefill\r\n\t\tWHERE questionnaire_prefill_id = '{$questionnaire_prefill_id}'";
$db->Execute($sql);
}
$questionnaire_id = false;
if (isset($_GET['questionnaire_id'])) {
$questionnaire_id = bigintval($_GET['questionnaire_id']);
}
$subtitle = T_("Set values for questionnaire to prefill");
xhtml_head(T_("Prefill questionnaire:"), true, array("../include/bootstrap/css/bootstrap.min.css", "../css/custom.css"), array("../js/window.js"), false, false, false, $subtitle);
print "<h3 class='form-inline pull-left'>" . T_("Select a questionnaire") . ": </h3>";
$sql = "SELECT questionnaire_id as value,description, \r\n\tCASE WHEN questionnaire_id = '{$questionnaire_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n \tFROM questionnaire\r\n\tWHERE enabled = 1";
display_chooser($db->GetAll($sql), "questionnaire", "questionnaire_id", true, false, true, true, false, true, "form-inline form-group");
if ($questionnaire_id != false) {
print "<h2>" . T_("Current pre fills") . "</h2>";
$sql = "SELECT questionnaire_prefill_id,lime_sgqa,value\r\n\t\tFROM questionnaire_prefill\r\n\t\tWHERE questionnaire_id = '{$questionnaire_id}'";
$r = $db->GetAll($sql);
if (empty($r)) {
print "<p class='well text-info'>" . T_("Currently no pre fills") . "</p>";
} else {
foreach ($r as $v) {
print "<ul class='form-group clearfix'><p class='col-sm-2'>" . T_("SGQA code") . ": <b class='text-primary'>{$v['lime_sgqa']}</b></p><p class='col-sm-4'>" . T_("Sample variable") . ": <b class='text-primary'>{$v['value']}</b></p><a href='?questionnaire_id={$questionnaire_id}&questionnaire_prefill_id={$v['questionnaire_prefill_id']}'><i class='fa fa-lg text-danger'>" . T_("Delete") . "</i></a></ul>";
示例13: T_
print "<h3 class='form-inline pull-left'>" . T_("Select a questionnaire") . ": </h3>";
$questionnaire_id = false;
if (isset($_GET['questionnaire_id'])) {
$questionnaire_id = bigintval($_GET['questionnaire_id']);
}
display_questionnaire_chooser($questionnaire_id, false, "form-inline form-group", "form-control");
if ($questionnaire_id) {
print "<h3 class='form-inline pull-left'>" . T_("Select a sample") . ": </h3>";
$sample_import_id = false;
if (isset($_GET['sample_import_id'])) {
$sample_import_id = bigintval($_GET['sample_import_id']);
}
display_sample_chooser($questionnaire_id, $sample_import_id, false, "form-inline form-group clearfix", "form-control");
if ($sample_import_id) {
if (isset($_GET['rowquota'])) {
$qsq = bigintval($_GET['rowquota']);
$qr = 0;
if (isset($_GET['close'])) {
$qr = 1;
}
$sql = "UPDATE questionnaire_sample_quota_row\r\n\t\t\t\tSET quota_reached = {$qr}\r\n\t\t\t\tWHERE questionnaire_sample_quota_row_id = '{$qsq}'";
$db->Execute($sql);
if ($qr == 1) {
close_row_quota($qsq);
} else {
open_row_quota($qsq, false);
}
}
//Display report of quotas
$report = array();
//Rows to display: Strata Status Quota Sample Sample Used Sample Remaining Completes % Complete
示例14: isset
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$kode = isset($_REQUEST['kode']) ? clean($_REQUEST['kode']) : '';
$kode_blok = isset($_REQUEST['kode_blok']) ? to_number($_REQUEST['kode_blok']) : '';
$no_va = isset($_REQUEST['no_va']) ? clean(trim($_REQUEST['no_va'])) : '';
$no_va_ph = isset($_REQUEST['no_va_ph']) ? clean($_REQUEST['no_va_ph']) : '';
$harga_awal = isset($_REQUEST['harga_awal']) ? bigintval($_REQUEST['harga_awal']) : '';
$no_ppjb_awal = isset($_REQUEST['no_ppjb_awal']) ? clean($_REQUEST['no_ppjb_awal']) : '';
$no_ppjb_hak = isset($_REQUEST['no_ppjb_hak']) ? clean($_REQUEST['no_ppjb_hak']) : '';
$tanggal_awal = isset($_REQUEST['tanggal_awal']) ? clean($_REQUEST['tanggal_awal']) : '';
$tanggal_sekarang = date("d-m-Y H:i:s");
$tanggal = isset($_REQUEST['tanggal']) ? clean($_REQUEST['tanggal']) : '';
$tanggal_permohonan = isset($_REQUEST['tanggal_permohonan']) ? clean($_REQUEST['tanggal_permohonan']) : '';
$tanggal_persetujuan = isset($_REQUEST['tanggal_persetujuan']) ? clean($_REQUEST['tanggal_persetujuan']) : '';
$harga_hak = isset($_REQUEST['harga_hak']) ? bigintval($_REQUEST['harga_hak']) : '';
$biaya = isset($_REQUEST['biaya']) ? bigintval($_REQUEST['biaya']) : '';
$masa_bangun = isset($_REQUEST['masa_bangun']) ? to_number($_REQUEST['masa_bangun']) : '';
$keterangan = isset($_REQUEST['keterangan']) ? clean($_REQUEST['keterangan']) : '';
$pihak_pertama = isset($_REQUEST['pihak_pertama']) ? clean($_REQUEST['pihak_pertama']) : '';
$no_id = isset($_REQUEST['no_id']) ? clean($_REQUEST['no_id']) : '';
$alamat = isset($_REQUEST['alamat']) ? clean($_REQUEST['alamat']) : '';
$tlp1 = isset($_REQUEST['tlp1']) ? clean($_REQUEST['tlp1']) : '';
$tlp3 = isset($_REQUEST['tlp3']) ? clean($_REQUEST['tlp3']) : '';
$email = isset($_REQUEST['email']) ? clean($_REQUEST['email']) : '';
$suami_istri = isset($_REQUEST['suami_istri']) ? clean($_REQUEST['suami_istri']) : '';
$no_fax = isset($_REQUEST['no_fax']) ? clean($_REQUEST['no_fax']) : '';
$pihak_kedua = isset($_REQUEST['pihak_kedua']) ? clean($_REQUEST['pihak_kedua']) : '';
$no_id_hak = isset($_REQUEST['no_id_hak']) ? clean($_REQUEST['no_id_hak']) : '';
$alamat_hak = isset($_REQUEST['alamat_hak']) ? clean($_REQUEST['alamat_hak']) : '';
$tlp1_hak = isset($_REQUEST['tlp1_hak']) ? clean($_REQUEST['tlp1_hak']) : '';
$tlp3_hak = isset($_REQUEST['tlp3_hak']) ? clean($_REQUEST['tlp3_hak']) : '';
示例15: mysql_real_escape_string
if ($email_valide == TRUE) {
$username = mysql_real_escape_string(trim(strip_tags($_POST['reg_benutzername'])));
$username = str_replace('_', '', $username);
$password = mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9);
$password_db = md5('1' . $password . '29');
$blackList1 = "SELECT COUNT(*) FROM " . $prefix . "blacklist WHERE email = '" . md5($email) . "' AND until > " . time();
$blackList2 = mysql_query($blackList1);
$blackList3 = mysql_result($blackList2, 0);
$schon_vorhandene_user = $blackList3;
$sql1 = "SELECT COUNT(*) FROM " . $prefix . "users WHERE email = '" . $email . "' OR username = '" . $username . "'";
$sql2 = mysql_query($sql1);
$sql3 = mysql_result($sql2, 0);
$schon_vorhandene_user += $sql3;
if ($schon_vorhandene_user == 0) {
$uniqueIDHash = md5($email . time());
$sql4 = "INSERT INTO " . $prefix . "users (email, username, password, regdate, last_login, last_ip, ids, liga, team) VALUES ('" . $email . "', '" . $username . "', '" . $password_db . "', " . time() . ", " . bigintval(getTimestamp('-14 days')) . ", '" . $last_ip . "', '" . $uniqueIDHash . "', '', '__" . $uniqueIDHash . "')";
$sql5 = mysql_query($sql4);
if ($sql5 != FALSE) {
if (isset($_SESSION['referralID'])) {
$refID = mysql_real_escape_string(trim($_SESSION['referralID']));
if (mb_strlen($refID) == 32) {
$addReferral1 = "INSERT INTO " . $prefix . "referrals (werber, geworben, zeit) VALUES ('" . $refID . "', '" . $uniqueIDHash . "', " . time() . ")";
$addReferral2 = mysql_query($addReferral1);
}
}
$fehler_gemacht = FALSE;
if (CONFIG_IS_LOCAL_INSTALLATION) {
echo '<p><strong>' . _('Dein Passwort lautet:') . '</strong> ' . htmlspecialchars($password) . '</p>';
echo '<p>' . _('Du brauchst dieses Passwort unbedingt für den ersten Login. Danach kannst Du es in den Einstellungen ändern, wenn Du möchtest.') . '</p>';
} else {
echo '<p>' . _('Vielen Dank, die Registrierung war erfolgreich! Wir senden Dir nun an die angegebene Adresse eine E-Mail mit Deinem Passwort zu. Mit dem Benutzernamen und dem zugeschickten Passwort kannst Du Dich danach einloggen.') . '</p>';