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