public function defineByName($columnName, &$variable, $type = SQLT_CHR)
{
set_error_handler(static::getErrorHandler());
$isSuccess = oci_define_by_name($this->resource, $columnName, $variable, $type);
restore_error_handler();
return $isSuccess;
}
function count_rows(&$conn, $select, $binds)
{
$sql = "SELECT COUNT(*) AS num_rows FROM({$select})";
$stmt = oci_parse($conn, $sql);
foreach ($binds as $handle => $var) {
oci_bind_by_name($stmt, $handle, $binds[$handle]);
}
oci_define_by_name($stmt, "NUM_ROWS", $num_rows);
oci_execute($stmt);
oci_fetch($stmt);
return $num_rows;
}
function isUserPresent($userName, $password)
{
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "select count(*) as NUM_ROWS from users where login_id = '{$userName}' and password ='******'");
oci_define_by_name($stmt, 'NUM_ROWS', $this->num_rows);
oci_execute($stmt);
oci_fetch($stmt);
oci_close($conn);
if ($this->num_rows > 0) {
return true;
} else {
return false;
}
}
function getMoviesBasedOnMovieName($searchText, $conn)
{
$inside = "false";
$searchQuery = "select * from movies where upper(moviename) like '%" . strtoupper($searchText) . "%'";
$movieMatches = oci_parse($conn, $searchQuery);
oci_execute($movieMatches);
while (($row = oci_fetch_array($movieMatches, OCI_BOTH)) != false) {
$movieshows = oci_parse($conn, "select showid,movieid,screenid,theatreid,to_char(starttime, 'yyyy-mm-dd hh24:mi:ss') as starttime, price from movieshow where starttime >=sysdate and movieid = " . $row['MOVIEID'] . "order by starttime");
oci_execute($movieshows);
while (($movieshowRow = oci_fetch_array($movieshows, OCI_BOTH)) != false) {
$inside = "true";
$starttime = date_format(date_create($movieshowRow['STARTTIME']), 'Y-m-d H:i:s');
$theatreDetails = oci_parse($conn, "select theatrename from theatres where theatreid=" . $movieshowRow['THEATREID']);
oci_define_by_name($theatreDetails, 'THEATRENAME', $theatrename);
oci_execute($theatreDetails);
echo "<br>";
echo "<div class='movie'>";
echo "<form action='/ticket-booking/ticket-selection.php' method='post'>";
echo "<a class='review' href= '/ticket-booking/view-reviews.php?type=theatre&theatreid=" . $movieshowRow['THEATREID'] . "'>View Review</a>";
if (isset($_SESSION['username'])) {
echo " <a class='review' href='/ticket-booking/reviews.php?type=theatre&theatreid=" . $movieshowRow['THEATREID'] . "'>Write Review</a>";
}
echo "<br>";
while (oci_fetch($theatreDetails)) {
echo "<span class='title'>Theatre: </span><span class='titleValue'>" . $theatrename . "</span>";
echo "<input type=hidden name='theatrename' value=\"" . $theatrename . "\">";
}
echo "<br>";
echo "<span class='title'>Movie: </span><span class='titleValue'>" . $row['MOVIENAME'] . "</span><span class='rating'> <img src='includes/likes.png'/ title='Users Rating'>" . number_format($row['RATING'] / 10 * 100, 0) . "%</span>";
echo "<br>";
echo "<span class='title'>Show Start Time: </span><span class='titleValue'>" . $movieshowRow['STARTTIME'] . "</span>";
echo "<span class='movieOrder'><input type='submit' value='Select'></span>";
echo "<input type=hidden name='showid' value=\"" . $movieshowRow['SHOWID'] . "\">";
echo "<input type=hidden name='theatreid' value=\"" . $movieshowRow['THEATREID'] . "\">";
echo "<input type=hidden name='movieid' value=\"" . $movieshowRow['MOVIEID'] . "\">";
echo "<input type=hidden name='screenid' value=\"" . $movieshowRow['SCREENID'] . "\">";
echo "<input type=hidden name='moviename' value=\"" . $row['MOVIENAME'] . "\">";
echo "<input type=hidden name='moviestarttime' value=\"" . $movieshowRow['STARTTIME'] . "\">";
echo "<input type=hidden name='ticketprice' value=\"" . $movieshowRow['PRICE'] . "\">";
echo "<input type=hidden name='movierating' value=\"" . number_format($row['RATING'] / 10 * 100, 0) . "\">";
echo "</form>";
echo "</div>";
}
}
return $inside;
}
function getReview($flightDesc)
{
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "Select u.fname,f.flight_desc,r.travel_date,r.description from review r join flight f on R.FLIGHT_ID = F.FLIGHT_ID join users u on R.USER_ID = u.user_id where F.FLIGHT_DESC = '" . $flightDesc . "'");
oci_define_by_name($stmt, 'NUM_ROWS', $this->num_rows);
oci_execute($stmt);
oci_close($conn);
$arrayOfReviewDetails = array();
while ($row = oci_fetch_row($stmt)) {
$review = new Review();
$review->setFlightName($row[0]);
$review->setFlightDescription($row[1]);
$review->setTravelDate($row[2]);
$review->setReviewDescription($row[3]);
array_push($arrayOfReviewDetails, $review);
}
return $arrayOfReviewDetails;
}
/**
* Voer insert uit en return last inserted id
*
* @param string $sequence
* @param bool $commit
* @return int|false $lastId
*/
public function insert($sequence = null, $commit = self::COMMIT)
{
if ($this->statement->getStatementType() != 'INSERT') {
return false;
}
if (empty($sequence)) {
return false;
}
if (!$this->execute($commit)) {
return false;
}
// try to return the currval of the given sequence
$resource = oci_parse($this->statement->getConnectionResource(), "select " . $sequence . ".currval cv from dual");
oci_define_by_name($resource, 'CV', $lastId);
$flag = $commit === true ? OCI_COMMIT_ON_SUCCESS : OCI_DEFAULT;
if (!oci_execute($resource, $flag)) {
return false;
}
oci_fetch($resource);
return $lastId;
}
oci_bind_by_name($insertIntoFabQcParse, ":PROJNAME", $projName);
oci_bind_by_name($insertIntoFabQcParse, ":UPDATEQTY", $updateQty);
$modRes = oci_execute($modParse);
$insertIntoFabRes = oci_execute($insertIntoFabParse);
$insertIntoFabQcRes = oci_execute($insertIntoFabQcParse);
if ($modRes && $insertIntoFabRes && $insertIntoFabQcRes) {
oci_commit($conn);
} else {
oci_rollback($conn);
}
$checkerSql = "SELECT MD.TOTAL_QTY AS TOTALQTY, MDA.SUMASSIGNEDQTY \r\n FROM MASTER_DRAWING MD \r\n INNER JOIN (SELECT MDA.HEAD_MARK, MDA.PROJECT_NAME, SUM(MDA.ASSIGNED_QTY) AS SUMASSIGNEDQTY \r\n FROM MASTER_DRAWING_ASSIGNED MDA \r\n GROUP BY MDA.HEAD_MARK, MDA.PROJECT_NAME)\r\n MDA ON MD.HEAD_MARK = MDA.HEAD_MARK AND MD.PROJECT_NAME = MDA.PROJECT_NAME \r\n WHERE MD.HEAD_MARK = :HEADMARK AND MD.PROJECT_NAME = :PROJNAME";
$checkerParse = oci_parse($conn, $checkerSql);
oci_bind_by_name($checkerParse, ":HEADMARK", $headMarkSelect);
oci_bind_by_name($checkerParse, ":PROJNAME", $projName);
oci_define_by_name($checkerParse, "TOTALQTY", $totalQuantity);
oci_define_by_name($checkerParse, "SUMASSIGNEDQTY", $totalAssignedQuantity);
oci_execute($checkerParse);
while (oci_fetch($checkerParse)) {
$totalQuantity;
}
while (oci_fetch($checkerParse)) {
$totalAssignedQuantity;
}
if ($totalAssignedQuantity == $totalQuantity) {
$updateStatusMdSql = "UPDATE MASTER_DRAWING SET SUBCONT_STATUS = 'ASSIGNED' " . "WHERE HEAD_MARK = :HEADMARK AND PROJECT_NAME = :PROJNAME";
$updateStatusMdParse = oci_parse($conn, $updateStatusMdSql);
oci_bind_by_name($updateStatusMdParse, ":HEADMARK", $headMarkSelect);
oci_bind_by_name($updateStatusMdParse, ":PROJNAME", $projName);
$updateStatusMdRes = oci_execute($updateStatusMdParse);
if ($updateStatusMdRes) {
oci_commit($conn);
oci_execute($subcontTotalTonnFourDaysParse);
while (oci_fetch($subcontTotalTonnFourDaysParse)) {
$tonnSubcontFourDays;
}
$subcontTotalTonnFiveDaysSql = "SELECT SUM(FAB.WEIGHT) AS CURRENTTONNSUBCONTFIVEDAYS, FAB.SUBCONT_ID " . "FROM FABRICATION_HIST, VW_FAB_INFO FAB WHERE FAB.HEAD_MARK = FABRICATION_HIST.HEAD_MARK " . "AND TO_CHAR(FAB_ENTRY_DATE, 'MM/DD/YYYY') = TO_CHAR(SYSDATE - 5, 'MM/DD/YYYY') " . "AND FAB.PROJECT_NAME = :PROJNAME AND FAB.SUBCONT_ID = '{$row['SUBCONT_ID']}' " . "GROUP BY FAB.SUBCONT_ID";
$subcontTotalTonnFiveDaysParse = oci_parse($conn, $subcontTotalTonnFiveDaysSql);
oci_bind_by_name($subcontTotalTonnFiveDaysParse, ":PROJNAME", $projectName);
oci_define_by_name($subcontTotalTonnFiveDaysParse, "CURRENTTONNSUBCONTFIVEDAYS", $tonnSubcontFiveDays);
oci_execute($subcontTotalTonnFiveDaysParse);
while (oci_fetch($subcontTotalTonnFiveDaysParse)) {
$tonnSubcontFiveDays;
}
$subcontTotalTonnSixDaysSql = "SELECT SUM(FAB.WEIGHT) AS CURRENTTONNSUBCONTSIXDAYS, FAB.SUBCONT_ID " . "FROM FABRICATION_HIST, VW_FAB_INFO FAB WHERE FAB.HEAD_MARK = FABRICATION_HIST.HEAD_MARK " . "AND TO_CHAR(FAB_ENTRY_DATE, 'MM/DD/YYYY') = TO_CHAR(SYSDATE - 6, 'MM/DD/YYYY') " . "AND FAB.PROJECT_NAME = :PROJNAME AND FAB.SUBCONT_ID = '{$row['SUBCONT_ID']}' " . "GROUP BY FAB.SUBCONT_ID";
$subcontTotalTonnSixDaysParse = oci_parse($conn, $subcontTotalTonnSixDaysSql);
oci_bind_by_name($subcontTotalTonnSixDaysParse, ":PROJNAME", $projectName);
oci_define_by_name($subcontTotalTonnSixDaysParse, "CURRENTTONNSUBCONTSIXDAYS", $tonnSubcontSixDays);
oci_execute($subcontTotalTonnSixDaysParse);
while (oci_fetch($subcontTotalTonnSixDaysParse)) {
$tonnSubcontSixDays;
}
$averageSubcontProdThisWeek = ($tonnSubcontToday + $tonnSubcontYesterday + $tonnSubcontTwoDays + $tonnSubcontThreeDays + $tonnSubcontFourDays + $tonnSubcontFiveDays + $tonnSubcontSixDays) / 7;
$no = $no + 1;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$baris}", $row['SUBCONT_ID'])->setCellValue("B{$baris}", $subcontStatus)->setCellValue("C{$baris}", number_format($tonnSubcont, 2))->setCellValue("D{$baris}", number_format($tonnSubcontToday, 2))->setCellValue("E{$baris}", number_format($tonnSubcontYesterday, 2))->setCellValue("F{$baris}", number_format($tonnSubcontTwoDays, 2))->setCellValue("G{$baris}", number_format($tonnSubcontThreeDays, 2))->setCellValue("H{$baris}", number_format($tonnSubcontFourDays, 2))->setCellValue("I{$baris}", number_format($tonnSubcontFiveDays, 2))->setCellValue("J{$baris}", number_format($tonnSubcontSixDays, 2))->setCellValue("K{$baris}", number_format($averageSubcontProdThisWeek, 2));
$baris = $baris + 1;
}
// nama dari sheet yang aktif
$objPHPExcel->getActiveSheet()->setTitle('SUBCONTRACTOR REPORT');
$objPHPExcel->setActiveSheetIndex(0);
$formattedFileName = date("m/d/Y_h:i", time());
// simpan file excel dengan nama umr2013.xls
//saat file berhasil di buat, otomatis pop up download akan muncul
$qtySql = "SELECT TOTAL_QTY AS UNIT_QTY FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME AND COMP_TYPE = :COMP AND HEAD_MARK = :HM";
$qtyParse = oci_parse($conn, $qtySql);
oci_bind_by_name($qtyParse, ":PROJNAME", $projectName);
oci_bind_by_name($qtyParse, ":COMP", $componentType);
oci_bind_by_name($qtyParse, ":HM", $headmarkType);
oci_define_by_name($qtyParse, "UNIT_QTY", $unitQty);
oci_execute($qtyParse);
?>
<?php
$assignedQtySql = "SELECT SUM (MDA.ASSIGNED_QTY) AS ASSIGN_QTY " . " FROM MASTER_DRAWING_ASSIGNED MDA INNER JOIN MASTER_DRAWING MD ON MD.HEAD_MARK = MDA.HEAD_MARK AND MD.DWG_STATUS = 'ACTIVE' " . " WHERE MD.PROJECT_NAME = :PROJNAME AND MD.COMP_TYPE = :COMP AND MD.HEAD_MARK = :HM";
$assignedQtyParse = oci_parse($conn, $assignedQtySql);
oci_bind_by_name($assignedQtyParse, ":PROJNAME", $projectName);
oci_bind_by_name($assignedQtyParse, ":COMP", $componentType);
oci_bind_by_name($assignedQtyParse, ":HM", $headmarkType);
oci_define_by_name($assignedQtyParse, "ASSIGN_QTY", $assignmentQty);
oci_execute($assignedQtyParse);
?>
<?php
while (oci_fetch($qtyParse)) {
$unitQty;
}
?>
<?php
while (oci_fetch($assignedQtyParse)) {
$assignmentQty;
}
?>
<?php
<h2>Bitácora de Administrador</h2>
<p>Consulta de todas las operaciones ejecutadas.</p>
<div class="row-fluid">
<div class="span8">
<hr>
<!--Construir tabla para reporte de bitácora-->
<?php
$conn = oci_connect('dranzer', 'fabulousmax', 'localhost/XE');
if ($conn) {
$query = "SELECT * FROM BITACORA WHERE ROL = 'admin'";
$stid = oci_parse($conn, $query);
oci_define_by_name($stid, 'ROL', $rol);
oci_define_by_name($stid, 'USUARIO', $usuario);
oci_define_by_name($stid, 'FECHA', $fecha);
oci_define_by_name($stid, 'DESCRIPCION', $descripcion);
oci_execute($stid);
echo "<table class=\"table table-striped\">\n\t\t\t\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Rol</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Usuario</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Fecha</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Descripción</th>\n\t\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t\t\t\t\t<tbody>";
while (oci_fetch($stid)) {
echo "<tr><td>{$rol}</td><td>{$usuario}</td><td>{$fecha}</td><td>{$descripcion}</td></tr>";
}
echo "</tbody>\n\t\t\t\t\t\t\t\t\t</table>";
oci_free_statement($stid);
oci_close($conn);
}
?>
<!--fin tabla-->
</div><!--/span-->
<div class="span4">
<p><a class="btn btn-large btn-inverse" href="#">Bitácora de Administrador »</a></p>
</div><!--/span-->
// 5 Испорчен
// 7 Уничтожен
// 6 Похищен
// 8 Передан
// 266 Утратил силу
include "../../config.php";
include "../../function.php";
include "../../ibs_connector.php";
connect_to_base();
#Было до 28.09.2015
//$query_a7 = mysql_query("SELECT `a7`.*, `user`.`id_in_ibs` FROM `user`, `a7` WHERE `unit_id` = 0 AND `a7`.`user_id` > 0 AND `user`.`user_id` = `a7`.`user_id` AND `user`.`id_in_ibs` > 0");
$query_a7 = mysql_query("\n\tSELECT `a7`.*, `user`.`id_in_ibs` \n\tFROM `user`, `a7`\n\t WHERE `unit_id` = 0\n\t AND `a7`.`user_id` > 0 \n\tAND `user`.`user_id` = `a7`.`user_id` \n\tAND `user`.`id_in_ibs` > 0\n\tAND NOT EXISTS \n\t(SELECT 1 \n\tFROM user_unit uu, unit u\n\tWHERE uu.unit_id = u.unit_id\n\tAND u.unit_id = 44\n\tAND uu.user_id =`a7`.`user_id` )\n");
if (mysql_num_rows($query_a7) == 0) {
echo 'Не обнаруженно бланков БСО';
exit;
}
while ($row = mysql_fetch_assoc($query_a7)) {
//В этой част проверяем есть ли в базе IBS полис с таким номером у данного пользователя и с такой же серией в статусе выдан
$oracle_sql_count = oci_parse($conn, "\n select count(*) AS NUM_ROWS\n from bso_document bd,\n bso_doc_cont bdc,\n ins.bso b,\n bso_series bs,\n ins.bso_hist bh\n where b.bso_id = bh.bso_id\n and b.bso_hist_id = bh.bso_hist_id\n and b.num >= bdc.num_start\n and (b.num <= bdc.num_end or bdc.num_end is null)\n and bh.bso_doc_cont_id = bdc.bso_doc_cont_id\n and bd.bso_document_id = bdc.bso_document_id\n and b.bso_series_id = bs.bso_series_id\n and bdc.bso_series_id = bs.bso_series_id\n and b.num = '" . $row['number'] . "'\n and bs.bso_type_id = 3 --А7\n and bd.contact_to_id = " . $row['id_in_ibs'] . " --AGENT_ID\n and bh.hist_type_id = 1 -- статус полиса выдан\n and bh.num = (select max(bh1.num)\n from ins.bso_hist bh1\n where bh1.bso_id = b.bso_id)\n ");
oci_define_by_name($oracle_sql_count, 'NUM_ROWS', $num_rows);
oci_execute($oracle_sql_count);
oci_fetch($oracle_sql_count);
//echo $num_rows;
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($num_rows == 0) {
mysql_query("DELETE FROM `a7` WHERE `number` = '" . $row['number'] . "'");
echo 'Удалён A7 №' . $row['number'];
}
//oci_free_statement($oracle_sql_count);
//oci_close($oracle_sql_count);
}
<table class="table" style="border:1px solid #ddd;" align="center">
<caption class="text-center"><h4>注册用户信息表</h4></caption>
<tr>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">用户名</th>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">申请权限</th>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">操作</th>
</tr>
<?php
session_start();
if ($_SESSION['priority'] == 0) {
if ($_SESSION['username']) {
include "../conn.php";
// $conn = ocilogon('scott','123','192.168.100.34:1521/linuxorcl','AL32UTF8');
$stmt = oci_parse($conn, "select * from T_USER where VERIFY='0'");
oci_define_by_name($stmt, "USERNAME", $username);
oci_define_by_name($stmt, "PRIORITY", $priority);
oci_execute($stmt);
while (oci_fetch($stmt)) {
?>
<tr>
<td style="border:1px solid #ddd;" align="center"><?php
echo $username;
?>
</td>
<td style="border:1px solid #ddd;" align="center"><?php
echo $priority;
?>
</td>
<td style="border:1px solid #ddd;" align="center"><a href="../application/modverify.php?post=<?php
echo $username;
?>
}
// GENERATE THE APPLICATION PAGE
$conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
// 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
// 2. USING UNIQUE VALUE FOR BACK END USER
oci_set_client_identifier($conn, $_SESSION['username']);
$username = htmlentities($_SESSION['username'], ENT_QUOTES);
?>
<?php
$projectName = strval($_GET['ProjectName']);
$prjSql = "SELECT PROJECT_NO,PROJECT_CODE FROM PROJECT WHERE PROJECT_NAME = :projectName ";
$PrjParse = oci_parse($conn, $prjSql);
oci_bind_by_name($PrjParse, ":projectName", $projectName);
oci_define_by_name($PrjParse, "PROJECT_NO", $PROJECT_NO);
oci_define_by_name($PrjParse, "PROJECT_CODE", $PROJECT_CODE);
oci_execute($PrjParse);
$query = "SELECT HEAD_MARK FROM MASTER_DRAWING WHERE PROJECT_NAME = :projectName ";
$result = oci_parse($conn, $query);
oci_bind_by_name($result, ":projectName", $projectName);
oci_execute($result);
?>
<?php
while (oci_fetch($PrjParse)) {
$PROJECT_CODE;
$PROJECT_NO;
}
?>
<label for="name" class="col-sm-2 control-label"><font color="red">COLI NUMBER</font></label>
public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null)
{
// this defining by name doesn't seem to work when used in this manner,
// so we will store the types bound here and handle type conversion in fetch
if (!is_null($type)) {
$this->bindTypeMap[$column] = $type;
}
return oci_define_by_name($this->sth, $column, $param, null);
}
/**
* {@inheritdoc}
*/
public function bindColumn($column, &$param, $type = null)
{
return oci_define_by_name($this->_sth, strtoupper($column), $param, $type);
}
/**
* Binds a column to a PHP variable
* @param mixed $column The number of the column or name of the column
* @param mixed $param The PHP variable to which the column should be bound
* @param int $type
* @param int $maxLength
* @param mixed $options
* @return bool
*/
public function bindColumn($column, &$param, $type = PDO::PARAM_STR, $maxlen = -1, $driverdata = null)
{
$type = $this->removeBitFlag(${$type}, PDO::PARAM_INPUT_OUTPUT);
$ociParamType = $this->pdo2OciParamConst($type);
// LOBs
if ($lob_desc = $this->oci_lob_desc($ociParamType)) {
$this->_lobs[$this->_lobsCount]['type'] = $ociParamType;
$this->_lobs[$this->_lobsCount]['lob'] = @oci_new_descriptor($this->ociPdoAdapter->getOciConnection(), $lob_desc);
$res = $this->_lobs[$this->_lobsCount]['lob'];
$this->checkError($res);
$res = @oci_define_by_name($this->stmt, $column, $this->_lobs[$this->_lobsCount]['lob'], $ociParamType);
$this->checkError($res);
$this->_lobs[$this->_lobsCount]['var'] = $param;
$this->_lobs[$this->_lobsCount]['input'] = false;
$this->_lobsCount++;
} else {
$res = @oci_define_by_name($this->stmt, $column, $param, $ociParamType);
$this->checkError($res);
}
return $res;
}
$username = htmlentities($_SESSION['username'], ENT_QUOTES);
$projectName = strval($_GET['var1']);
?>
<?php
$compProfileSql = "SELECT MASTER_DRAWING.PROJECT_NAME, MASTER_DRAWING.COMP_TYPE, COMP_TYPE_SUMM.JUMLAH JML_DWG,\r\n SUM(FABRICATION.MARKING) JML_MARKING,\r\n SUM(FABRICATION.CUTTING) JML_CUTTING,\r\n SUM(FABRICATION.ASSEMBLY) JML_ASSEMBLY,\r\n SUM(FABRICATION.WELDING) JML_WELDING,\r\n SUM(FABRICATION.DRILLING) JML_DRILLING,\r\n SUM(FABRICATION.FINISHING) JML_FINISHING, SUM(PAINTING.BLASTING) JML_BLASTING,\r\n SUM(PAINTING.PRIMER) JML_PRIMER, SUM(PAINTING.INTERMEDIATE) JML_INTERMEDIATE, SUM(PAINTING.FINISHING) JML_FINISH\r\n\r\n FROM FABRICATION, MASTER_DRAWING, COMP_TYPE_SUMM, PAINTING\r\n WHERE FABRICATION.HEAD_MARK = MASTER_DRAWING.HEAD_MARK AND\r\n MASTER_DRAWING.PROJECT_NAME = COMP_TYPE_SUMM.PROJECT_NAME AND\r\n MASTER_DRAWING.COMP_TYPE = COMP_TYPE_SUMM.COMP_TYPE AND\r\n PAINTING.HEAD_MARK = MASTER_DRAWING.HEAD_MARK AND MASTER_DRAWING.PROJECT_NAME = :PROJNAME\r\n\r\n GROUP BY MASTER_DRAWING.COMP_TYPE,\r\n MASTER_DRAWING.PROJECT_NAME, COMP_TYPE_SUMM.JUMLAH";
$compProfileParse = oci_parse($conn, $compProfileSql);
oci_bind_by_name($compProfileParse, ":PROJNAME", $projectName);
oci_execute($compProfileParse);
$content = "\r\n <!DOCTYPE html>\r\n <html lang=\"en\">\r\n <head>\r\n <meta charset=\"UTF-8\">\r\n <title>PRODUCTION REPORT Check List</title>\r\n <link rel=\"stylesheet\" href=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css\">\r\n <link rel=\"stylesheet\" href=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css\">\r\n <script src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\r\n <script src=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js\"></script>\r\n <style type=\"text/css\">\r\n .bs-example{\r\n margin: 20px;\r\n }\r\n </style>\r\n </head>\r\n <body>\r\n <div class=\"bs-example\">\r\n <table class=\"table table-bordered\">\r\n <thead>\r\n <tr>\r\n <th>COMPONENT</th>\r\n <th>TOTAL DRAWING</th>\r\n <th>DRAWING ASSIGNED</th>\r\n <th>MARKING SUM</th>\r\n <th>CUTTING SUM</th>\r\n <th>ASSEMBLY SUM</th>\r\n <th>WELDING SUM</th>\r\n <th>DRILLING SUM</th>\r\n <th>FAB FINISHING SUM</th>\r\n <th>BLASTING SUM</th>\r\n <th>PRIMER SUM</th>\r\n <th>INTERMEDIATE SUM</th>\r\n <th>PAINT FINISHING SUM</th> \r\n </tr>\r\n </thead>\r\n <tbody>";
while (($row = oci_fetch_array($compProfileParse, OCI_BOTH)) != false) {
$totalDrawingSql = "SELECT SUM(MASTER_DRAWING.TOTAL_QTY) TOTALQTY FROM MASTER_DRAWING WHERE MASTER_DRAWING.COMP_TYPE = :COMPTYPE AND MASTER_DRAWING.PROJECT_NAME = :PROJNAME";
$totalDrawingParse = oci_parse($conn, $totalDrawingSql);
oci_bind_by_name($totalDrawingParse, ":COMPTYPE", $row['COMP_TYPE']);
oci_bind_by_name($totalDrawingParse, ":PROJNAME", $projectName);
oci_define_by_name($totalDrawingParse, "TOTALQTY", $totalDrawingQty);
oci_execute($totalDrawingParse);
while (oci_fetch($totalDrawingParse)) {
$totalDrawingQty;
}
$content .= "<tr>\r\n <td>{$row['COMP_TYPE']}</td>\r\n <td>{$totalDrawingQty}</td>\r\n <td>{$row['JML_DWG']}</td>\r\n <td>{$row['JML_MARKING']}</td>\r\n <td>{$row['JML_CUTTING']}</td>\r\n <td>{$row['JML_ASSEMBLY']}</td>\r\n <td>{$row['JML_WELDING']}</td>\r\n <td>{$row['JML_DRILLING']}</td>\r\n <td>{$row['JML_FINISHING']}</td>\r\n <td>{$row['JML_BLASTING']}</td>\r\n <td>{$row['JML_PRIMER']}</td>\r\n <td>{$row['JML_INTERMEDIATE']}</td>\r\n <td>{$row['JML_FINISH']}</td>\r\n <tr>";
}
$content .= "</tbody>\r\n </table>\r\n </div>\r\n </body>\r\n </html>";
$list_header = "\r\n <div style=\"display:block; background-color:#f2f2f2; padding:10px; border-bottom:2pt solid #cccccc; color:#6e6e6e; font-size:.85em; font-family:verdana;\">\r\n <div style=\"float:left; width:33%; text-align:left;\">\r\n <img src=\"images/wenlogo.jpg\">\r\n </div>\r\n <div style=\"float:left; width:33%; text-align:center;\">";
$_SESSION[cd - dropdown];
$list_header .= "Production Report by Component List for {$projectName}\r\n </div>\r\n <br style=\"clear:left;\"/>\r\n </div>";
$list_footer = "\r\n <div style=\"display:block;\">\r\n <div style=\"float:left; width:33%; text-align:left;\">\r\n \r\n </div>\r\n <div style=\"float:left; width:33%; text-align:center;\">\r\n Page phptopdf_on_page_number of phptopdf_pages_total\r\n </div>\r\n <div style=\"float:left; width:33%; text-align:right;\">\r\n Generated by {$username}\r\n \r\n </div>\r\n <br style=\"clear:left;\"/>\r\n </div>";
$pdf_options = array("source_type" => 'html', "source" => $content, "action" => 'view', "page_orientation" => 'landscape', "file_name" => 'sample_pdf_report.pdf', "header" => $list_header, "footer" => $list_footer);
// CALL THE phpToPDF FUNCTION WITH THE OPTIONS SET ABOVE
phptopdf($pdf_options);
// OPTIONAL - PUT A LINK TO DOWNLOAD THE PDF YOU JUST CREATED
} elseif (!empty($_GET['sz_id'])) {
//egy kis felhasználói adat
if (isset($_SESSION['user'])) {
$felh_id_sql = "SELECT F_ID FROM FELHASZNALO WHERE FELHASZNALONEV = '{$_SESSION['user']}'";
$felh_id_lekerdez = oci_parse($conn, $felh_id_sql);
oci_execute($felh_id_lekerdez);
while (oci_fetch($felh_id_lekerdez)) {
$fi_id = oci_result($felh_id_lekerdez, 'F_ID');
}
}
$szaki_sql = "SELECT * FROM SZAKI WHERE SZ_ID = '{$_GET['sz_id']}'";
$szaki = oci_parse($conn, $szaki_sql);
oci_execute($szaki);
$ert_atlag_sql = "SELECT AVG(PONT) AS ATLAG FROM ERTEKELES WHERE SZ_ID='{$_GET['sz_id']}'";
$ert_atlag = oci_parse($conn, $ert_atlag_sql);
oci_define_by_name($ert_atlag, 'ATLAG', $atlag);
oci_execute($ert_atlag);
oci_fetch($ert_atlag);
while (oci_fetch($szaki)) {
?>
<div class="col-md-6">
<div id="adatok">
<h2><?php
echo oci_result($szaki, 'NEVE');
?>
</h2>
<h4>Értékelése: <?php
echo round($atlag, 2);
?>
</h4>
<p>
oci_execute($sumParse);
while (oci_fetch($sumParse)) {
$total;
}
$subcontAssignedSql = "SELECT GET_BLDG_ASSGWT(:projName) TOTALASSIGNED FROM DUAL";
$subcontAssignedParse = oci_parse($conn, $subcontAssignedSql);
oci_bind_by_name($subcontAssignedParse, ":projName", $projectName);
oci_define_by_name($subcontAssignedParse, "TOTALASSIGNED", $totalAssignedWeight);
oci_execute($subcontAssignedParse);
while (oci_fetch($subcontAssignedParse)) {
$totalAssignedWeight;
}
$currFabTonnSql = "SELECT GET_BLDG_FAB(:projName) AS CURRENT_SUM FROM DUAL";
$currFabTonnParse = oci_parse($conn, $currFabTonnSql);
oci_bind_by_name($currFabTonnParse, ":projName", $projectName);
oci_define_by_name($currFabTonnParse, "CURRENT_SUM", $currentFabricationSum);
oci_execute($currFabTonnParse);
while (oci_fetch($currFabTonnParse)) {
$currentFabricationSum;
}
$percAssigned = $totalAssignedWeight / $total * 100;
$percFab = $currentFabricationSum / $total * 100;
$barisReportWeight = $baris + 1;
$barisReportAssigned = $baris + 2;
$barisReportNotAssigned = $baris + 3;
$barisFabWeight = $baris + 4;
$barisFabNotWeight = $baris + 5;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("B{$barisReportWeight}", 'TOTAL PROJECT WEIGHT')->setCellValue("F{$barisReportWeight}", number_format($total, 0))->setCellValue("B{$barisReportAssigned}", 'TOTAL PROJECT WEIGHT ASSIGNED')->setCellValue("F{$barisReportAssigned}", number_format($totalAssignedWeight, 0))->setCellValue("G{$barisReportAssigned}", number_format($percAssigned, 2) . '%')->setCellValue("B{$barisReportNotAssigned}", 'TOTAL PROJECT NOT ASSIGNED')->setCellValue("F{$barisReportNotAssigned}", number_format($total - $totalAssignedWeight, 0))->setCellValue("G{$barisReportNotAssigned}", number_format(100 - $percAssigned, 2) . '%')->setCellValue("B{$barisFabWeight}", 'TOTAL FABRICATION WEIGHT')->setCellValue("F{$barisFabWeight}", number_format($currentFabricationSum, 0))->setCellValue("G{$barisFabWeight}", number_format($percFab, 2) . '%')->setCellValue("B{$barisFabNotWeight}", 'NOT FABRICATION WEIGHT')->setCellValue("F{$barisFabNotWeight}", number_format($total - $currentFabricationSum, 0))->setCellValue("G{$barisFabNotWeight}", number_format(100 - $percFab, 2) . '%');
$objPHPExcel->getActiveSheet()->getStyle("F{$barisReportWeight}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle("F{$barisReportAssigned}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle("F{$barisFabWeight}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
public function DefineByName($statement, $column_name, &$variable, $type = SQLT_CHR)
{
return oci_define_by_name($statement, $column_name, $variable, $type);
}
$lengthSql = "SELECT LENGTH AS UNIT_LENGTH FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME AND COMP_TYPE = :COMP AND HEAD_MARK = :HM";
$lengthParse = oci_parse($conn, $lengthSql);
oci_bind_by_name($lengthParse, ":PROJNAME", $projectName);
oci_bind_by_name($lengthParse, ":COMP", $componentType);
oci_bind_by_name($lengthParse, ":HM", $headmarkType);
oci_define_by_name($lengthParse, "UNIT_LENGTH", $unitLength);
oci_execute($lengthParse);
?>
<?php
$qtySql = "SELECT TOTAL_QTY AS UNIT_QTY FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME AND COMP_TYPE = :COMP AND HEAD_MARK = :HM";
$qtyParse = oci_parse($conn, $qtySql);
oci_bind_by_name($qtyParse, ":PROJNAME", $projectName);
oci_bind_by_name($qtyParse, ":COMP", $componentType);
oci_bind_by_name($qtyParse, ":HM", $headmarkType);
oci_define_by_name($qtyParse, "UNIT_QTY", $unitQty);
oci_execute($qtyParse);
?>
<?php
while (oci_fetch($weightParse)) {
$unitWeight;
}
?>
<?php
while (oci_fetch($surfaceParse)) {
$unitSurface;
}
?>
<?php
while (oci_fetch($lengthParse)) {
$searchq = $_POST['search'];
$searchq = preg_replace("#[^0-9a-z]#i", "", $searchq);
//filter
$connect1 = oci_connect($username_connect, $password_connect, $database_connect);
//$sqldd = "SELECT * from product WHERE (Name LIKE '%Music%' OR Type LIKE '%Music%' )and rownum < 20 ";
$query1 = oci_parse($connect1, "SELECT * from product WHERE ( Name LIKE '%{$searchq}%' OR Type LIKE '%{$searchq}%' ) and rownum < 20");
// $query = mysql_query("SELECT * from product WHERE Name LIKE '%$searchq%' OR Type LIKE '%$searchq%'") or die("could not search");
// print( "654654 SELECT * from product WHERE Name LIKE '%$searchq%' OR Type LIKE '%$searchq%'");
// exit;
//$count = mysql_num_rows($query);
oci_define_by_name($query1, "Name", $Name1);
oci_define_by_name($query1, "Type", $Type1);
oci_define_by_name($query1, "IMAGE", $image1);
oci_define_by_name($query1, "Prodid", $Prodid1);
oci_define_by_name($query1, "Quantity", $qty1);
oci_define_by_name($query1, "SALEPRICE", $price1);
oci_execute($query1);
$Count1 = oci_num_rows($query1);
print "SELECT * from product WHERE Name LIKE '%{$searchq}%' OR Type LIKE '%{$searchq}%'";
// print($Count1);
// exit;
// if ($Count1==0)
// {
// $output= 'There was no search results!';
//}else {;
$output = '<table border="0" cellpadding="10"><tr>';
while (oci_fetch($query1)) {
/*
$Name = $row["Name"];
$Type = $row["Type"];
$image=$row["prod_image"];
<?php
$path = join(DIRECTORY_SEPARATOR, array('..', 'conn', 'OracleProske.php'));
include $path;
$sql0 = oci_parse($conn, 'select max(roundid) as round from telebet.match');
oci_define_by_name($sql0, 'ROUND', $round);
oci_execute($sql0);
oci_fetch($sql0);
$sql = oci_parse($conn, 'select cl.id, to_char(CL.CHANGE_DATE, \'dd.mm.yyyy HH24:mi\'), CL.OLD_DATE, to_char(CL.NEW_DATE, \'dd.mm.yyyy HH24:mi\'), concat(concat(CBP.NAME,\' \'),CBP.LASTNAME) NAME, m.matchnumber, l1.string, l2.string, cl.change_date
from TELEBET.MATCH m, TELEBET.BET_MATCH_TELEBET_INFO bmti, TELEBET.BET_MATCH bm, TELEBET.SP_EVENT_CHANGE_DATE_LOG cl,TELEBET.CB_PERSONS cbp, telebet.team t1, telebet.languagestring l1, telebet.team t2, telebet.languagestring l2
where matchnumber in (\'' . $selected_matchnumber . '\')
and roundid=\'' . $selected_round . '\'
and M.IS_GERMANIA_MATCH=\'' . $selected_kladionica . '\'
and BMTI.TELEBET_MATCH_ID=m.id
and BM.ID=BMTI.BET_MATCH_ID
and CL.EVENT_ID=BM.EVENT_ID
and CL.PERSON_ID=CBP.ID
and m.hometeamid = t1.id
and t1.name = l1.stringvaluesid
and l1.languageid=1
and m.visitorteamid = t2.id
and t2.name = l2.stringvaluesid
and l2.languageid=1
order by 9 desc');
oci_execute($sql);
$TimeChanged = array();
while ($row = oci_fetch_array($sql)) {
array_push($TimeChanged, $row);
}
//print_r($TimeChanged);
function getRowNbSel($from, $dbcnx)
{
if (!$dbcnx) {
return null;
}
// $req = pg_query($sql_count) or die('echec sql : ' . pg_last_error());
// $req = pg_query($sql_count);
$sql_count = "select count(*) NUMBER_OF_ROWS FROM {$from}";
$req = ociparse($dbcnx, $sql_count);
// oracle
oci_define_by_name($req, 'NUMBER_OF_ROWS', $number_of_rows);
if (!oci_execute($req, OCI_DEFAULT)) {
oci_rollback($dbcnx);
$e = oci_error($req);
print "<pre><font color='red'>" . $e['sqltext'] . ': ' . $e['message'] . '</font></pre>';
$_url = "../index.php?ong=" . $_POST['ong'];
echo "<br><br><b><a href={$_url}>Retour</a></b>";
die;
}
oci_fetch($req);
return $number_of_rows;
}
$buildingVal = strval($_POST['buildingValue']);
$periode = $_POST['periode'];
$uniqueCodeSql = "SELECT PROJECT_CODE PROJECTCODE FROM SUB_PROJECT WHERE PROJECT_NO = :PROJNO AND PROJECT_NAME = :PROJNAME";
$uniqueCodeParse = oci_parse($conn, $uniqueCodeSql);
oci_bind_by_name($uniqueCodeParse, ":PROJNO", $jobVal);
oci_bind_by_name($uniqueCodeParse, ":PROJNAME", $buildingVal);
oci_define_by_name($uniqueCodeParse, "PROJECTCODE", $uniqueCodeVal);
oci_execute($uniqueCodeParse);
while (oci_fetch($uniqueCodeParse)) {
$uniqueCodeVal;
}
$uniqueProjectNameSql = "SELECT PROJECT_NAME UNPROJECTNAME FROM PROJECT WHERE PROJECT_CODE = :PROJCODE AND PROJECT_NO = :PROJNO";
$uniqueProjectNameParse = oci_parse($conn, $uniqueProjectNameSql);
oci_bind_by_name($uniqueProjectNameParse, ":PROJCODE", $uniqueCodeVal);
oci_bind_by_name($uniqueProjectNameParse, ":PROJNO", $jobVal);
oci_define_by_name($uniqueProjectNameParse, "UNPROJECTNAME", $uniqueProjectNameVal);
oci_execute($uniqueProjectNameParse);
while (oci_fetch($uniqueProjectNameParse)) {
$uniqueProjectNameVal;
}
?>
<?php
if ($buildingVal != "") {
$subcontParse = oci_parse($conn, "SELECT DISTINCT SUBCONT_ID FROM VW_FAB_INFO " . "WHERE PROJECT_NAME = :PROJNAME ORDER BY SUBCONT_ID");
oci_bind_by_name($subcontParse, ":PROJNAME", $uniqueProjectNameVal);
oci_execute($subcontParse);
echo '<SELECT name="subcontname" id="subcontSelectDropdownMonitor" class="selectpicker form-control"
data-style="btn-warning" data-live-search="true">';
echo '<OPTION VALUE="xxx">SELECT SUBCONTRACTOR</OPTION>';
echo '<OPTION VALUE="">ALL</OPTION>';
include "connectcdb.php";
include "connectpdb.php";
include "catalog_cls.php";
if (isset($_POST["phone"])) {
$phone = trim($_POST["phone"]);
if (is_numeric($phone) && strlen($phone) == 10) {
$_SESSION["phone"] = $phone;
echo "Welcome {$phone}<br>";
echo "You searched for " . $_POST['search'] . "<br>";
$search_cd = "%" . strtoupper(htmlspecialchars(trim($_POST['search']), ENT_QUOTES)) . "%";
$sql = "SELECT aname, config, price FROM catalog where UPPER(aname) like :aname and upper(status) = 'AVAILABLE' order by aname, config";
$stid = oci_parse($conn, $sql);
oci_bind_by_name($stid, ':aname', $search_cd);
oci_define_by_name($stid, 'ANAME', $aname);
oci_define_by_name($stid, 'CONFIG', $config);
oci_define_by_name($stid, 'PRICE', $price);
oci_execute($stid);
//$checkboxes = "<input type='checkbox' name='selected[$cakename]' value= '$cakename' />";
// Printing results in HTML
echo "<form action='CustomerDetails.php' method='POST'>";
echo "<br><table border = '1'>\n";
$i = 0;
while (oci_fetch($stid)) {
if ($i == 0) {
echo "<tr>";
echo "<th>Select</th><th>Appliance</th><th>Config</th><th>Price</th>";
echo "</tr>\n";
}
$catalogObject = new catalog_cls();
$catalogObject->setAname($aname);
$catalogObject->setConfig($config);
//$baris=2 artinya kita mulai memasukan data ke baris kedua
while (($row = oci_fetch_array($projectNameParse, OCI_BOTH)) != false) {
$projectNumberSql = "SELECT PROJ.PROJECT_NO PROJECTNUMBER, PROJ.CLIENT_ID CLIENTID " . "FROM PROJECT PROJ WHERE PROJ.PROJECT_NAME = :PROJNAME";
$projectNumberParse = oci_parse($conn, $projectNumberSql);
oci_bind_by_name($projectNumberParse, ":PROJNAME", $row['PROJECT_NAME']);
oci_define_by_name($projectNumberParse, "PROJECTNUMBER", $projectNo);
oci_define_by_name($projectNumberParse, "CLIENTID", $client);
oci_execute($projectNumberParse);
while (oci_fetch($projectNumberParse)) {
$projectNo;
$client;
}
$clientInitialSql = "SELECT CLIENT.CLIENT_INITIAL CLIENTINITIAL FROM CLIENT WHERE CLIENT.CLIENT_ID = :CLID";
$clientInitialParse = oci_parse($conn, $clientInitialSql);
oci_bind_by_name($clientInitialParse, ":CLID", $client);
oci_define_by_name($clientInitialParse, "CLIENTINITIAL", $clientInitial);
oci_execute($clientInitialParse);
while (oci_fetch($clientInitialParse)) {
$clientInitial;
}
$no = $no + 1;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$baris}", $row['SUBCONT_ID'])->setCellValue("B{$baris}", $projectNo)->setCellValue("C{$baris}", $clientInitial)->setCellValue("D{$baris}", $row['PROJECT_NAME'])->setCellValue("E{$baris}", $row['TOTALASSIGNED']);
$baris = $baris + 1;
}
// nama dari sheet yang aktif
$objPHPExcel->getActiveSheet()->setTitle('DRAWING ASSIGNED TO SUBCONT');
$objPHPExcel->setActiveSheetIndex(0);
$formattedFileName = date("m/d/Y_h:i", time());
// simpan file excel dengan nama umr2013.xls
//saat file berhasil di buat, otomatis pop up download akan muncul
header('Content-Type: application/vnd.ms-excel');
$query = "SELECT COUNT(*) AS NUMBER_OF_ROWS FROM FELHASZNALO WHERE FELHASZNALONEV = '" . $user . "'";
$stid = oci_parse($conn, $query);
oci_define_by_name($stid, 'NUMBER_OF_ROWS', $number_of_rows);
oci_execute($stid);
oci_fetch($stid);
if ($number_of_rows == 0) {
$a = 1;
$fejl_id_sql = "SELECT SZ_ID FROM SZAKI WHERE FELHASZNALONEV = '{$_SESSION['user']}'";
$fejl_id_lekerdez = oci_parse($conn, $fejl_id_sql);
oci_execute($fejl_id_lekerdez);
while (oci_fetch($fejl_id_lekerdez)) {
$fejl_id = oci_result($fejl_id_lekerdez, 'SZ_ID');
}
$munka_sql = 'SELECT COUNT(*) AS MUNKASZAM FROM IGENYLES WHERE MUNKAKAT= (SELECT MUNKANEV FROM SZAKI WHERE SZ_ID=' . $fejl_id . ")";
$munka_szam = oci_parse($conn, $munka_sql);
oci_define_by_name($munka_szam, 'MUNKASZAM', $munkaszam);
oci_execute($munka_szam);
oci_fetch($munka_szam);
echo '<li id="munkak" class="last"><a href="munkat.php">Munkák <span class="badge">' . $munkaszam . '</span></a></li>';
echo '<li id="elofizetes" class="last"><a href="elofizetes.php">Előfizetés</a></li>';
echo '<li id="uzenet" class="last"><a href="uzenetek.php">Üzenetek</a></li>';
oci_free_statement($munka_szam);
} else {
$a = 0;
echo '<li id="kedvenceim" class="last"><a href="kedvenceim.php">Kedvenceim</a></li>';
echo '<li id="uzenet" class="last"><a href="uzenetek.php">Üzenetek</a></li>';
echo '<li id="panasz" class="last"><a href="panasz.php">Panasz</a></li>';
echo '<li id="igenyles" class="last"><a href="hirdetesf.php">Igénylés</a></li>';
echo '<li id="igenylesek" class="last"><a href="igenylesek.php">Hirdetéseim</a></li>';
}
} else {
<?php
require_once '../../_config/dbinfo.inc.php';
require_once '../../_config/misc.func.php';
require_once '../../_config/hash.pwd.php';
session_start();
$conn = oci_connect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB) or die;
$pass = $_POST['password'];
$username = $_POST['username'];
oci_set_client_identifier($conn, 'admin');
$sql = oci_parse($conn, "SELECT WMU.MART_PASS HASHPASS,\r\n WMU.MART_FULL_NAME FULLNAME,\r\n WMR.MART_ROLE_DESC COMP_ROLE_COMPLETE\r\n FROM MART_USER WMU\r\n INNER JOIN MART_ROLE WMR\r\n ON WMR.MART_ROLE_ID = WMU.MART_ROLE_ID\r\n WHERE WMU.MART_FULL_NAME = :finemail");
oci_bind_by_name($sql, ":finemail", $username);
oci_define_by_name($sql, "COMP_ROLE_COMPLETE", $role);
oci_define_by_name($sql, "HASHPASS", $hashpass);
oci_execute($sql);
$r = oci_fetch_array($sql, OCI_ASSOC);
$passMatchInt = validate_password($pass, $hashpass);
if ($passMatchInt == 1) {
$_SESSION['userlogin'] = $username;
$_SESSION['rolelogin'] = $role;
echo '<script>location.href="../main.php"</script>';
} else {
echo '<script>alert("LOGIN FAILED !!! \\nPLEASE ENTER APPROPRIATE USER NAME AND PASSWORD")</script>';
echo '<script>location.href="../../index.php"</script>';
}
$globalName = SingleQryFld("SELECT WMS.SETTING_VALUE_STRING FROM MART_SETTINGS WMS WHERE WMS.SETTING_DESC = 'GLOBAL_NAME'", $conn);
$_SESSION['globalname'] = $globalName;
public function zalozUmowaKarta($tabDane, $strProdSymbol)
{
Kis_Logic_Debuger::wyswietlDane($tabDane);
$strModulo = $tabDane['modulo'];
//
$intDlugoscOkresu = 999;
//karta 999 - karta
$intTypOkresu = 2;
//typ okresu 2 - karta
$strDestination = '';
$strDestinationDesc = 'Konsumpcyjny gotówkowy';
$intKwota = $tabDane['kwota'];
$strWaluta = $tabDane['waluta'];
$strData = date("Ymd", $tabDane['data']);
//
$strUlica = $tabDane['ulica'];
//
$strNumerDomu = $tabDane['nr_domu'];
//
$strNumerMieszkania = $tabDane['nr_mieszkania'];
//
$strKodPocztowy = $tabDane['kod_pocztowy'];
//
$strMiasto = $tabDane['miasto'];
//
$strKraj = $tabDane['kraj'];
//
$strNazwaKlient = $tabDane['klient'];
//
$strEmeil = $tabDane['mail'];
//
$strOkres = $tabDane['okres'];
$xmlUmowaKredytowa = "<CONTRACT>\n <PROD_SYMBOL>{$strProdSymbol}</PROD_SYMBOL>\n <ROOT_NO>{$strModulo}</ROOT_NO>\n <CONTRACT_NO></CONTRACT_NO>\n <PERIOD>{$intDlugoscOkresu}</PERIOD>\n <TIMESCALE>{$intTypOkresu}</TIMESCALE>\n <AMOUNT>{$intKwota}</AMOUNT>\n <CURRENCY>{$strWaluta}</CURRENCY>\n <START_DATE></START_DATE>\n <VARIANT_TYPE></VARIANT_TYPE>\n <INT_TYPE>2</INT_TYPE>\n <TRANCHE_AVAILABLE></TRANCHE_AVAILABLE>\n <INT_IN_TRANS_TYPE>1</INT_IN_TRANS_TYPE>\n <SETTLEMENT_CYCLE>{$strOkres}</SETTLEMENT_CYCLE>\n </CONTRACT>\n <CORRESP_ADDRESS_DATA>\n <STREET_PREF>1</STREET_PREF>\n <STREET>{$strUlica}</STREET>\n <HOUSE_NO>{$strNumerDomu}</HOUSE_NO>\n <APARTMENTS_NO>{$strNumerMieszkania}</APARTMENTS_NO>\n <CORRESP_POST_CODE>{$strKodPocztowy}</CORRESP_POST_CODE>\n <CORRESP_TOWN>{$strMiasto}</CORRESP_TOWN>\n <CORRESP_COUNTRY>{$strKraj}</CORRESP_COUNTRY>\n <CUST_CORRESP_NAME>{$strNazwaKlient}</CUST_CORRESP_NAME>\n <EMAIL>{$strEmeil}</EMAIL>\n </CORRESP_ADDRESS_DATA>\n ";
$xmlWyjsciowy = oci_new_descriptor($this->oracle_link, OCI_D_LOB);
$zap = oci_parse($this->oracle_link, "begin :errr := NBL_API.INSUPD_CONTRACT(:head,:xml_wejsciowy,:xml_wyjsciowy); end;");
oci_define_by_name($zap, ':xml_wyjsciowy', $xmlWyjsciowy, SQLT_CLOB);
oci_bind_by_name($zap, ":head", $this->strNaglowekXML);
oci_bind_by_name($zap, ":errr", $error, 2000, SQLT_CHR);
oci_bind_by_name($zap, ":xml_wejsciowy", $xmlUmowaKredytowa);
oci_bind_by_name($zap, ":xml_wyjsciowy", $xmlWyjsciowy, -1, SQLT_CLOB);
$wynik = oci_execute($zap);
if (!$wynik) {
$this->intCzyBledy++;
$this->debuger("Nie udana próba założenie umowy kredytowej");
}
Kis_Logic_Debuger::wyswietlDane($error);
if (!is_object($xmlWyjsciowy)) {
throw new Kis_Logic_DefException("Nie otrzymano xml zwrotnego {$error}");
}
$clobXml = $xmlWyjsciowy->size();
$xmlWynik = $xmlWyjsciowy->read($clobXml);
if ($xmlWynik !== '') {
// $xmlWynik = iconv("ISO-8859-2","UTF-8",$xmlWynik);
$domXml = new DOMDocument();
$domXml->loadXML($xmlWynik);
$docElem = $domXml->documentElement;
$strIdDef = $docElem->getElementsByTagName("ID_CONTRACT")->item(0)->nodeValue;
$strRachunekWplata = $docElem->getElementsByTagName("CONTRACT_NRB")->item(0)->nodeValue;
$RefNo = $docElem->getElementsByTagName("REF_NO")->item(0)->nodeValue;
$tabDaneZwracane = array();
$tabDaneZwracane['id_kontrakt'] = $strIdDef;
$tabDaneZwracane['rachunek_nrb'] = $strRachunekWplata;
$tabDaneZwracane['ref_no'] = addslashes($RefNo);
return $tabDaneZwracane;
} else {
$this->intCzyBledy++;
$this->debuger($error);
return 0;
}
}
