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>";