function getTestimonials()
{
$q = "SELECT * FROM testimonials WHERE publish='yes' ORDER BY id";
$r = mysql_query($q) or die("Cannot query {$q} line " . __LINE__ . " file " . __FILE__ . " sql said " . msyql_error());
$n = mysql_num_rows($r);
$out = array();
for ($i = 0; $i < $n; $i++) {
$out[] = mysql_fetch_array($r);
}
return $out;
}
}
//print_r($dataArr);
/*
$query2 = "SELECT * FROM KontrakAset ka
INNER JOIN Aset aset ON aset.Aset_ID = ka.Aset_ID
INNER JOIN Kontrak kontrak ON kontrak.Kontrak_ID = ka.Kontrak_ID";
*/
//query untuk ambil data apl_userasetlist
$query_apl = "SELECT aset_list FROM apl_userasetlist WHERE UserNm LIKE '$SessionUser[ses_uname]' AND UserSes = '$SessionUser[ses_uid]'";
//print_r($query_apl);
$result_apl = mysql_query($query_apl) or die (msyql_error());
$data_apl = mysql_fetch_object($result_apl);
$explode = explode(',',$data_apl->aset_list);
//print_r($explode);
// end apl_userasetlist
?>
<link href="./datepickercontrol.css" type="text/css" rel="stylesheet">
<link href="../../css/style.css" type="text/css" rel="stylesheet">
<link href="../../modules/transfer/transfer.css" type="text/css" rel="stylesheet">
<style>
?>
<div class="<?php if (isset($_GET['kr'])){if ($_GET['kr']==$dataSSP['Satker_ID']) echo 'datalist_inlist_selected';} ?>">
<a class="datalist_inlist" href="?page=4&pr=<?php echo $data['Satker_ID']?>&sp=<?php echo $dataSubParent['Satker_ID']?>&ssp=<?php echo $dataSubSubParent['Satker_ID']?>&sssp=<?php echo $dataRuangan['Satker_ID']?>&kr=<?php echo $dataSSP['Satker_ID']?>&a=v">
<div style="margin-left:60px;">» <?php echo "<span style='font-size:12px;'>$dataSSP[KodeSatker].$dataSSP[KodeUnit].$dataSSP[Gudang].$dataSSP[Kd_Ruang]-$dataSSP[NamaSatker]</span>"?></div>
</a>
</div>
<?php
if (isset($_GET['kr']))
{
if ($_GET['kr'] == $dataSSP['Satker_ID'])
{
$sql2 = "SELECT * FROM Satker WHERE Satker_ID =".$dataSSP['Satker_ID'];
// pr($sql2);
$res2 = mysql_query($sql2) or die (msyql_error());
$dataKR = mysql_fetch_array($res2);
// pr($dataSSP);
$KodeSektor = $data['KodeSektor'];
$oldKodeSatker = explode('.',$dataSubParent['KodeSatker']);
$KodeSatker = $oldKodeSatker[1];
$KodeUnit = $dataKR['KodeUnit'];
$NamaSatker = $dataKR['NamaSatker'];
$KotaSatker = $dataKR['KotaSatker'];
// $Gudang = $dataKR['Gudang'];
$BuatKIB = $dataKR['BuatKIB'];
$KodeUPB = $dataKR['Gudang'];
$KodeRuangan = $dataKR['Kd_Ruang'];
}
?>
<div class="messages">
<?php
$getallmessages = mysql_query("SELECT * FROM `bill_forward_underwriter` WHERE `user_id`='{$_REQUEST['uid']}' && `form_id`='{$_REQUEST['fid']}'") or die(mysql_error());
if (mysql_num_rows($getallmessages) > 0) {
$data = mysql_fetch_object($getallmessages);
$message = $data->underwriter_message;
}
?>
</div>
<?php
if (isset($_POST['forwardbill'])) {
$underwriter = $_POST['underwriter'];
$messagess = mysql_real_escape_string($_POST['document_message']);
$query = mysql_query("UPDATE `billing_info` SET `underwriter_id` = '{$underwriter}' WHERE `form_id` = '{$_REQUEST['fid']}' && `user_id`='{$_REQUEST['uid']}'") or die(mysql_error());
$temp_send = mysql_query("INSERT INTO `bill_forward_underwriter` (`form_id`,`user_id`,`underwriter_id`,`admin_message`,`date_time`) VALUES ('{$_REQUEST['fid']}','{$_REQUEST['uid']}','{$underwriter}','{$messagess}',now())") or die(msyql_error());
/* Notifications */
$notiFication = mysql_query("INSERT INTO `notifications` (`user_id`,`form_id`,`main_id`,`message`) VALUES ('{$_REQUEST['uid']}','{$_REQUEST['fid']}','{$underwriter}','New Billing to Approve')") or die(mysql_error());
/*
Get UserInformation By Id
*/
$user_id = $underwriter;
$p_name = $getdata->GetInfoPlantiffInformation("plantiff_name", $_REQUEST['fid']);
$u_f_name = $getdata->GetObjectById($user_id, "first_name");
$u_l_name = $getdata->GetObjectById($user_id, "last_name");
$email_id = $getdata->GetInfoPlantiffInformation("client_email", $_REQUEST['fid']);
/*underwriter email*/
$email_underwriter = $getdata->GetObjectById($user_id, "email_id");
$contact_n = $getdata->GetInfoPlantiffInformation("p_home_no", $_REQUEST['fid']);
$case_no = $_REQUEST['fid'];
/*
<?php
session_start();
$connect = mysql_connect('localhost', 'root', '') or die(msyql_error());
if ($connect) {
mysql_select_db('bornomala_db') or die(mysql_error());
}
}
if (!empty($param['sNilai'])) {
$sPo .= " and a.nilaiinvoice=" . $param['sNilai'];
}
if (!empty($param['sYm'])) {
$sPo .= " and a.tanggal like '%" . $param['sYm'] . "%'";
}
$sPo .= " order by a.tanggal asc";
//print_r($sPo);
$qPo = mysql_query($sPo) or die(mysql_error($conn));
$key = $no = 0;
while ($rPo = mysql_fetch_assoc($qPo)) {
if (isset($belumlunas[$rPo['noinvoice']]) and $rPo['noinvoice'] == $belumlunas[$rPo['noinvoice']]) {
$sJmlh = "select distinct sum(jumlah) as jmlhKas from " . $dbname . ".keu_kasbankdt where keterangan1='" . $rPo['noinvoice'] . "'";
//echo $sJmlh;
$qJmlh = mysql_query($sJmlh) or die(msyql_error($conn));
$rJmlh = mysql_fetch_assoc($qJmlh);
$sCek = "select distinct sum(nilaiinvoice+nilaippn) as jmlhinvoice from " . $dbname . ".keu_tagihanht where noinvoice='" . $rPo['noinvoice'] . "'";
$qCek = mysql_query($sCek) or die(mysql_error($conn));
$rCek = mysql_fetch_assoc($qCek);
$iDt = "select sum(nilai) as nilai from " . $dbname . ".keu_tagihandt where noakun in " . "(select nilai from " . $dbname . ".setup_parameterappl where kodeaplikasi='TX' and kodeparameter='PPNINV')" . " and noinvoice='" . $rPo['noinvoice'] . "' ";
$nDt = mysql_query($iDt) or die(mysql_error($conn));
$dDt = mysql_fetch_assoc($nDt);
$no += 1;
if (empty($rPo['kodesupplier'])) {
$dat .= "<tr class='rowcontent' title='PO still not valid, No Supplier'><td></td>";
$dat .= "<td style='background-color:red;'>" . $rPo['noinvoice'] . "</td>";
} elseif ($rPo['posting'] == 0) {
//$dat.="<tr class='rowcontent' title='Document not complete:".$rPo['namakaryawan']."'><td></td>";
$dat .= "<tr class='rowcontent' title='Invoice not posted yet'><td></td>";
$dat .= "<td style='background-color:red;'>" . $rPo['noinvoice'] . "</td>";
<?php
$path = $_SERVER['DOCUMENT_ROOT'] . "/path.php";
require_once $path;
include $config;
$cptIds = $_GET['cptId'];
$descTemp = mysql_query("SELECT * FROM `cpt_codes` WHERE `cpt_code`={$cptIds}") or die(msyql_error());
$desc = mysql_fetch_object($descTemp);
?>
<li>
<span class="form_label">
<label>Description</label>
</span>
<span class="form_input">
<textarea name="description" rows="10" cols="50"><?php
echo $desc->description;
?>
</textarea>
<span class="error"></span>
</span>
</li>
<?php
$getallmessages = mysql_query("SELECT * FROM `bill_forward_underwriter` WHERE `user_id`='$_REQUEST[uid]' && `form_id`='$_REQUEST[fid]'") or die(mysql_error());
if(mysql_num_rows($getallmessages)>0)
{
$data = mysql_fetch_object($getallmessages);
$message = $data->underwriter_message;
}
?>
</div>
<?php
if(isset($_POST['forwardbill']))
{
$underwriter = $_POST['underwriter'];
$messagess = $_POST['document_message'];
$query = mysql_query("UPDATE `billing_info` SET `underwriter_id` = '$underwriter' WHERE `form_id` = '$_REQUEST[fid]' && `user_id`='$_REQUEST[uid]'") or die(mysql_error());
$temp_send = mysql_query("INSERT INTO `bill_forward_underwriter` (`form_id`,`user_id`,`underwriter_id`,`admin_message`,`date_time`) VALUES ('$_REQUEST[fid]','$_REQUEST[uid]','$underwriter','$messagess',now())") or die(msyql_error());$dattime = date('d-M-Y h:i:s a');
/*
Get UserInformation By Id
*/
$user_id = $underwriter;
$u_f_name = $getdatas->GetObjectById($user_id,"first_name");
$u_l_name = $getdatas->GetObjectById($user_id,"last_name");
$email_id = $getdatas->GetObjectById($user_id,"email_id");
$fullname = $u_f_name." ".$u_l_name;
$case_no = $_REQUEST['fid'];
/*
End
*/
}
}
}
}
if ($cek != 0) {
echo "warning:Kodebarang : " . $cekBrg2 . " Lebih Dari Satu";
exit;
}
}
break;
case 'listBarangDetail':
$tab .= "<tr class=rowcontent><td colspan=7> </td></tr>";
$sPp = "select distinct * from " . $dbname . ". log_permintaanhargadt where nomor='" . $_POST['notransaksi'] . "' and nourut='" . $_POST['nourut'] . "'";
//echo $sPp;
//exit("error:".$sPp);
$qPp = mysql_query($sPp) or die(msyql_error($conn));
while ($rPp = mysql_fetch_assoc($qPp)) {
$no++;
$tab .= "<tr class=rowcontent>";
$tab .= "<td style=width:20px>" . $no . "</td>";
$tab .= "<td style='width:180px' id=nopplst_" . $no . ">" . $rPp['nopp'] . "</td>";
$tab .= "<td style='width:88px' id=kodebrg_" . $no . ">" . $rPp['kodebarang'] . "</td>";
$tab .= "<td style=width:380px>" . $optBarang[$rPp['kodebarang']] . "</td>";
$tab .= "<td style='width:62px' align=right id=jumlah_" . $no . ">" . $rPp['jumlah'] . "</td>";
$tab .= "<td style=width:55px>" . $optSat[$rPp['kodebarang']] . "</td>";
$tab .= "<td style='width:10px' align=center><input type=checkbox id=pilBrg_" . $no . " checked /></td></tr>";
}
echo $tab;
break;
case 'preview2':
$formPil = 1;
public function GetInfoPlantiffInformation($var1, $var2)
{
$query = mysql_query("SELECT {$var1} FROM `plantiff_information` WHERE `form_id`='{$var2}'") or die(msyql_error());
$getcase = mysql_fetch_object($query);
return $getcase->{$var1};
}
$sql = "SELECT title FROM " . TABLE_PREFIX . "forums WHERE forum_id='" . $fid[0] . "'";
$result2 = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result2)) {
$courseOptions .= "<option value='" . $fid[0] . "'>" . $row[0] . "</option>";
}
}
if ($courseOptions != "") {
print "<optgroup label='Course Forums'>";
print $courseOptions;
print "</optgroup>";
}
// ---Get group forums for the specific course id
$groupOptions = "";
// get type_id(s) for this course
$sql = "SELECT type_id FROM " . TABLE_PREFIX . "groups_types WHERE course_id='" . $course_id . "'";
$result = mysql_query($sql) or die(msyql_error());
while ($type_id = mysql_fetch_row($result)) {
// get group_id(s) for each type
$sql = "SELECT group_id, title FROM " . TABLE_PREFIX . "groups WHERE type_id='" . $type_id[0] . "'";
$result2 = mysql_query($sql) or die(mysql_error());
while ($group_id = mysql_fetch_row($result2)) {
// get forum_id for each group
$sql = "SELECT forum_id FROM " . TABLE_PREFIX . "forums_groups WHERE group_id='" . $group_id[0] . "'";
$result3 = mysql_query($sql) or die(mysql_error());
while ($fid = mysql_fetch_row($result3)) {
// get forum title for this fid
$sql = "SELECT title FROM " . TABLE_PREFIX . "forums WHERE forum_id='" . $fid[0] . "'";
$result4 = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_row($result4);
$groupOptions .= "<option value='" . $fid[0] . "'>" . $group_id[1] . "</option>";
}
/**
* Delete user.
* @param $cid The user's cid.
*/
function user_delete($cid)
{
$esc_cid = mysql_real_escape_string($cid);
$sql = "DELETE FROM `user` WHERE `cid`='{$esc_cid}'";
$res = mysql_query($sql);
if (!$res) {
crm_error(msyql_error());
}
$sql = "DELETE FROM `user_role` WHERE `cid`='{$esc_cid}'";
$res = mysql_query($sql);
if (!$res) {
crm_error(msyql_error());
}
message_register("Deleted user data for: " . theme('contact_name', $cid));
}
$kamusKar = array();
while ($bar = mysql_fetch_object($res)) {
$kamusKar[$bar->karyawanid]['id'] = $bar->karyawanid;
$kamusKar[$bar->karyawanid]['nama'] = $bar->namakaryawan;
$kamusKar[$bar->karyawanid]['kodecatu'] = $bar->kodecatu;
$kamusKar[$bar->karyawanid]['tipekaryawan'] = $bar->tipekaryawan;
$kamusKar[$bar->karyawanid]['namatipe'] = $bar->tipe;
$kamusKar[$bar->karyawanid]['kelompok'] = $bar->keterangan;
$kamusKar[$bar->karyawanid]['kode'] = $bar->kodecatu;
$kamusKar[$bar->karyawanid]['jabatan'] = $bar->namajabatan;
}
switch ($_GET['aksi']) {
case 'excel':
$stream = "Daftar Catu beras Periode " . $_GET['periode'] . "<br>\r\n Unit: " . $kodeorg . "\r\n <table class=sortable border=1 cellspacing=1>\r\n <thead>\r\n <tr class=rowheader>\r\n <td bgcolor=#DEDEDE align=center>No.</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['kodeorg'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['subbagian'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['periode'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['tipe'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jabatan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['status'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>Ltr/Hk</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jumlah'] . " HK</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['hargasatuan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['total'] . "(Rp)</td>\r\n </tr>\r\n </thead>\r\n <tbody>";
$sData = "select distinct * from " . $dbname . ".sdm_catu where \r\n kodeorg='" . $kodeorg . "' and periodegaji='" . $_GET['periode'] . "'";
$qData = mysql_query($sData) or die(msyql_error($conn));
$ttl = 0;
while ($rData = mysql_fetch_assoc($qData)) {
$no += 1;
$stream .= "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $kodeorg . "</td> \t\r\n <td>" . $rData['subbagian'] . "</td>\r\n <td>" . $rData['periodegaji'] . "</td>\r\n <td>" . $kamusKar[$rData['karyawanid']]['nama'] . "</td>\r\n <td>" . $kamusKar[$rData['karyawanid']]['namatipe'] . "</td>\r\n <td>" . $kamusKar[$rData['karyawanid']]['jabatan'] . "</td>\r\n <td>" . $kamusKar[$rData['karyawanid']]['kode'] . "</td> \r\n <td>" . number_format($rData['catuperhk'], 2, '.', ',') . "</td>\r\n <td align=right>" . number_format($rData['jumlahhk'], 0, '.', ',') . "</td>\r\n <td align=right>" . number_format($rData['hargacatu'], 0, '.', ',') . "</td> \r\n <td align=right>" . number_format($rData['jumlahrupiah'], 0, '.', ',') . "</td> \r\n ";
$ttl += $rData['jumlahrupiah'];
}
$stream .= "<tr class=rowheader>\r\n <td colspan=11>TOTAL</td> \r\n <td align=right>" . number_format($ttl, 0, '.', ',') . "</td> \r\n ";
$stream .= "</tbody></table>";
$stream .= "Print Time:" . date('Y-m-d H:i:s') . "<br>By:" . $_SESSION['empl']['name'];
$dte = date("Hms");
$nop_ = "listDataCatuBeras__" . $_GET['kodeorg'] . "__" . $dte;
$gztralala = gzopen("tempExcel/" . $nop_ . ".xls.gz", "w9");
gzwrite($gztralala, $stream);
gzclose($gztralala);
echo "<script language=javascript1.2>\r\n window.location='tempExcel/" . $nop_ . ".xls.gz';\r\n </script>";
