function select_data($req)
{
$stmt = oci_parse($this->connection, $req);
oci_execute($stmt, OCI_DEFAULT);
while (oci_fetch($stmt)) {
echo oci_result($stmt, "TEST") . "<br>\n";
}
}
function register($login, $password, $name, $surname)
{
$conn = connect();
$stid = oci_parse($conn, 'SELECT ID FROM USERS WHERE ID = :0');
oci_bind_by_name($stid, ':0', $login);
oci_execute($stid);
oci_fetch($stid);
if (oci_result($stid, 'ID') > 0) {
notify('Пользователь с таким номером уже существует!');
oci_close($conn);
} else {
$salt = rand(1, 1000000);
$hash = md5($password . $salt);
$stid = oci_parse($conn, "INSERT INTO USERS (ID, HASH, SALT, NAME, SURNAME) VALUES (:0, :1, :2, :3, :4)");
oci_bind_by_name($stid, ':0', $login);
oci_bind_by_name($stid, ':1', $hash);
oci_bind_by_name($stid, ':2', $salt);
oci_bind_by_name($stid, ':3', $name);
oci_bind_by_name($stid, ':4', $surname);
if (oci_execute($stid)) {
oci_close($conn);
session_start();
$_SESSION['ID'] = $login;
header('Location: ./profile.php');
}
}
}
public function consultar()
{
//$prub = Conexion::getInstancia("system", "admin");
//$p=new Persona();
$persina = new PersonaDAO();
$aa = new ConexionDB("apoyo_alimentario", "apoyo_alimentario");
if ($aa->conectarDB()) {
$sesion = $aa->getConn();
$facultades = array();
$i = 0;
$sqltxt = "select * from facultad";
$stid = oci_parse($sesion, $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
$facultad = new Facultad();
$facultad->setIdfacultad(oci_result($stid, 'ID_FACULTAD'));
$facultad->setNombre_facultad(oci_result($stid, 'NOMBRE_FACULTAD'));
$facultades[$i] = $facultad;
$i += 1;
}
return $facultades;
//oci_parse($a, $sql_text);
//echo $a;
}
}
/** Helper function for printing out core fulfillment options */
function printCoreSet($num)
{
global $conn;
$query = "SELECT core_code, description FROM vw_core_requirement WHERE core_set_id=" . $num . " ORDER BY report_order";
$data = oci_parse($conn, $query);
oci_execute($data);
while (oci_fetch($data)) {
echo "<option value='" . oci_result($data, 'CORE_CODE') . "'>" . oci_result($data, 'CORE_CODE') . "-" . oci_result($data, 'DESCRIPTION') . "</option>\n";
}
oci_free_statement($data);
}
public function buscarIdSolicitud($idestu, $idconvoc)
{
$idsol;
$sqltxt = "select k_idsolicitud from s_solicitud where k_estudiante = '" . $idestu . "' and k_convocatoria =" . $idconvoc;
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
$idsol = oci_result($stid, 'K_IDSOLICITUD');
}
return $idsol;
}
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;
}
public function verTipoCondicionxSolicitud($idcond)
{
//echo $idcond.">-----------id";
$sqltxt = "select t_condicion from s_condicion_se where k_idcondicion = " . $idcond;
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
// echo "---------->".oci_result($stid, 'T_CONDICION')."<----ENTRO WHILE";
$idtipo = oci_result($stid, 'T_CONDICION');
}
//echo "(".$idtipo.")";
return $idtipo;
}
public function buscarFacultad($id_facultad)
{
$facultad = new Facultad();
$sqltxt = "select * from s_facultad where k_idfacultad = " . $id_facultad . "";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
$facultad->setIdfacultad(oci_result($stid, 'K_IDFACULTAD'));
$facultad->setNombre_facultad(oci_result($stid, 'N_NOMFACULTAD'));
}
//echo $persona->getApellido_persona();
return $facultad;
}
function getId($db, $sql, $idName)
{
echo "{$this->log} - {$sql} <br />";
$idName = strtoupper($idName);
$stid = oci_parse($db, $sql);
oci_execute($stid);
$id = NULL;
while (oci_fetch($stid)) {
//echo "dbfunctions.php - oci_result for $idName: " . oci_result($stid, $idName) . '<br />';
$id = oci_result($stid, $idName);
}
oci_free_statement($stid);
return $id;
}
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;
}
}
public function verDias()
{
$dias = array();
$i = 0;
$sqltxt = "select * from s_dia";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
//echo $sqltxt;
oci_execute($stid);
while (oci_fetch($stid)) {
$dia = new DiaSolicitud();
$dia->setId_dia(oci_result($stid, 'K_IDDIA'));
$dia->setNombre_dia(oci_result($stid, 'N_NOMDIA'));
$dias[$i] = $dia;
$i += 1;
}
return $dias;
}
public function buscarPersonaxUsuario($usuario)
{
$persona = new Persona();
$sqltxt = "select * from s_persona where usuario = '" . $usuario . "'";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
//$persona->setCodigo_persona(oci_result($stid, 'CODIGO'));
$persona->setNombre_persona(oci_result($stid, 'NOMBRE_PER'));
$persona->setApellido_persona(oci_result($stid, 'APELLIDO_PER'));
$persona->setTipo_persona(oci_result($stid, 'TIPO'));
$persona->setUsuario_persona(oci_result($stid, 'USUARIO'));
$persona->setGenero_persona(oci_result($stid, 'GENERO'));
$persona->setDocumento_persona(oci_result($stid, 'DOCUMENTO'));
}
//echo $persona->getApellido_persona();
return $persona;
}
public function verBeneficiadoValidado()
{
//$condicionxsolicitud=new CondicionxSolicitud();
$beneficiados = array();
$i = 0;
$sqltxt = "SELECT n_nomper, n_apeper, n_correo FROM s_BeneficiarioValidado B, s_Solicitud S, s_Estudiante E, s_Persona P WHERE B.k_idsolicitud = S.k_idsolicitud AND S.k_estudiante = E.k_codigo_est AND E.k_documento = P.k_documento";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
$persona = new Persona();
$persona->setNombre_persona(oci_result($stid, 'N_NOMPER'));
$persona->setApellido_persona(oci_result($stid, 'N_APEPER'));
$persona->setCorreo_persona(oci_result($stid, 'N_CORREO'));
$beneficiados[$i] = $persona;
$i += 1;
}
return $beneficiados;
}
public function buscarPersonaxDocumento($documento)
{
$persona = new Persona();
echo $documento;
$sqltxt = "select * from s_persona where k_documento = '" . $documento . "'";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
$persona->setDocumento_persona(oci_result($stid, 'K_DOCUMENTO'));
$persona->setNombre_persona(oci_result($stid, 'N_NOMPER'));
$persona->setApellido_persona(oci_result($stid, 'N_APEPER'));
$persona->setUsuario_persona(oci_result($stid, 'N_USUARIO'));
$persona->setTipo_persona(oci_result($stid, 'T_TIPO'));
$persona->setGenero_persona(oci_result($stid, 'N_GENERO'));
$persona->setCorreo_persona(oci_result($stid, 'N_CORREO'));
}
//echo $persona->getApellido_persona();
return $persona;
}
public function buscarFuncionarioxDocumento($documento)
{
$funcionario = new Funcionario();
$sqltxt = "select * from s_funcionario where k_documento = " . $documento . "";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
//echo $sqltxt;
oci_execute($stid);
while (oci_fetch($stid)) {
//$persona->setCodigo_persona(oci_result($stid, 'CODIGO'));
$funcionario->setId_funcionario(oci_result($stid, 'K_IDFUNCIONARIO'));
$funcionario->setDocumento_funcionario(oci_result($stid, 'K_DOCUMENTO'));
$funcionario->setCargo_funcionario(oci_result($stid, 'N_CARGO'));
}
//echo (string)$estudiante->getCodigo_estudiante();
//echo $estudiante->getCarrera_estudiante();
//echo $estudiante->getMatriculas_estudiante();
//echo $estudiante->getCodigo_estudiante();
//echo $persona->getApellido_persona();
return $funcionario;
}
/**
* 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;
}
function displaySchedule()
{
$dao = new DAO();
$stmt = oci_parse($dao->con, "SELECT TO_CHAR(TIMESTART, 'MM-DD-YYYY HH24:MI') AS TS ,TO_CHAR(TIMEEND, 'MM-DD-YYYY HH24:MI') AS TE, ID, THEATREID, MOVIEID FROM SCREENROOM");
OCIDefineByName($stmt, "TS", $timeS);
OCIDefineByName($stmt, "TE", $timeE);
OCIDefineByName($stmt, "ID", $scroomID);
OCIDefineByName($stmt, "THEATREID", $tID);
OCIDefineByName($stmt, "MOVIEID", $mID);
oci_execute($stmt, OCI_DEFAULT);
echo '<table border=1>';
while (oci_fetch($stmt)) {
echo '<tr>';
// Use the uppercase column names for the associative array indices
$bookLink = '<a href=order.php?sID=' . $scroomID . '>  book</a>';
$detailLink = '<a href=movieDetail.php?mID=' . $mID . '>  detaile</a>';
echo '<td> MOVIE: ' . $dao->fetchMovieName($mID) . '</td>' . ' <td>Start: ' . $timeS . ' </td><td>End: ' . $timeE . ' </td><td> theatre: ' . $dao->fetchTheatreName($tID) . '</td><td>' . $bookLink . ' </td><td>' . $detailLink . '</td>';
echo '</tr>';
}
echo '</table>';
}
public function verConvocatoriasActivas()
{
$convocatorias = array();
$i = 0;
$sqltxt = "select * from s_convocatoria where fecha_inicio< sysdate AND fecha_fin > sysdate";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
oci_execute($stid);
while (oci_fetch($stid)) {
//$persona->setCodigo_persona(oci_result($stid, 'CODIGO'));
$convocatoria = new Convocatoria();
$convocatoria->setId_convocatoria(oci_result($stid, 'ID_CONVOCATORIA'));
$convocatoria->setId_facultad(oci_result($stid, 'ID_FACULTAD'));
$convocatoria->setFecha_inicio(oci_result($stid, 'FECHA_INICIO'));
$convocatoria->setFecha_fin(oci_result($stid, 'FECHA_FIN'));
$convocatoria->setCupos(oci_result($stid, 'CUPOS'));
$convocatoria->setPeriodo(oci_result($stid, 'PERIODO'));
$convocatorias[$i] = $convocatoria;
$i += 1;
}
//echo $convocatoria->getId_convocatoria()."aaaaaaaaaaaaaaaaadwwqqwd";
return $convocatorias;
}
public function buscarEstudiantexDocumento($documento)
{
$estudiante = new Estudiante();
$sqltxt = "select * from s_estudiante where documento = " . $documento . "";
$stid = oci_parse($_SESSION['sesion_logueado'], $sqltxt);
//echo $sqltxt;
oci_execute($stid);
while (oci_fetch($stid)) {
//$persona->setCodigo_persona(oci_result($stid, 'CODIGO'));
$estudiante->setCodigo_estudiante(oci_result($stid, 'CODIGO_EST'));
$estudiante->setDocumento_estudiante(oci_result($stid, 'DOCUMENTO'));
$estudiante->setMatriculas_estudiante(oci_result($stid, 'MATRICULAS_EST'));
$estudiante->setActivo_estudiante(oci_result($stid, 'ACTIVO'));
$estudiante->setCarrera_estudiante(oci_result($stid, 'CARRERA'));
$estudiante->setPromedio_estudiante(oci_result($stid, 'PROMEDIO'));
}
//echo (string)$estudiante->getCodigo_estudiante();
//echo $estudiante->getCarrera_estudiante();
//echo $estudiante->getMatriculas_estudiante();
//echo $estudiante->getCodigo_estudiante();
//echo $persona->getApellido_persona();
return $estudiante;
}
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;
}
$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');
header('Content-Disposition: attachment;filename="DrawingAssignedToSubcont_on_' . $date1 . '_' . $formattedFileName . '.xls"');
header('Cache-Control: max-age=0');
<!--Currently logged in-->
<?php
} else {
include "./PHPconnectionDB.php";
$conn = connect();
$pid = $_SESSION['pid'];
$sql = "SELECT * FROM persons P WHERE P.person_id='{$pid}'";
$stid = oci_parse($conn, $sql);
$res = oci_execute($stid);
if (!$res) {
oci_free_statement($stid);
oci_close($conn);
header("Location: login.php");
exit;
}
$row = oci_fetch($stid);
$firstname = oci_result($stid, 'FIRST_NAME');
$lastname = oci_result($stid, 'LAST_NAME');
$address = oci_result($stid, 'ADDRESS');
$email = oci_result($stid, 'EMAIL');
$phone = oci_result($stid, 'PHONE');
oci_free_statement($stid);
oci_close($conn);
?>
<form action="user-settings.php" method="post">
<input type="text" name="firstname" value="<?php
echo $firstname;
?>
"/><label>First Name</label></br>
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"];
$Prodid = $row["Prodid"];
$qty = $row["Quantity"];
$price = $row["Price"];
*/
if ($i % 3 == 0) {
$output .= '</tr><tr>';
/*$dyn_table .='<td>'.$Name;
$dyn_table .='<br>'.$Type.'<br>';
$dyn_table .='<img src="'.$image.'" width = 200, height = 200/></td>';
*/
}
<div class="container">
<div class="row">
<?php
$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)) {
$f_id = oci_result($felh_id_lekerdez, 'F_ID');
}
$sql = 'SELECT * FROM IGENYLES WHERE F_ID= ' . $f_id;
$igenylesek = oci_parse($conn, $sql);
oci_execute($igenylesek);
?>
<?php
while (oci_fetch($igenylesek)) {
?>
<div class="col-md-4 col-xs-4">
<div class="panel panel-default">
<ul>
<h3><li><?php
echo oci_result($igenylesek, 'MUNKAKAT');
?>
</li></h3>
<i><li><?php
echo oci_result($igenylesek, 'SZOVEG');
?>
</li></i>
<li><?php
echo oci_result($igenylesek, 'DATUM');
?>
/**
* Returns a single column from the next row of a result set.
*
* @param int $col OPTIONAL Position of the column to fetch.
* @return string
* @throws \Zend\Db\Statement\Exception
*/
public function fetchColumn($col = 0)
{
if (!$this->_stmt) {
return false;
}
if (!oci_fetch($this->_stmt)) {
// if no error, there is simply no record
if (!($error = oci_error($this->_stmt))) {
return false;
}
throw new OracleException($error);
}
$data = oci_result($this->_stmt, $col + 1);
//1-based
if ($data === false) {
throw new OracleException(oci_error($this->_stmt));
}
if ($this->getLobAsString()) {
// instanceof doesn't allow '-', we must use a temporary string
$type = 'Oci-Lob';
if ($data instanceof $type) {
$data = $data->read($data->size());
}
}
return $data;
}
<?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);
/**
* Returns a single column from the next row of a result set.
*
* @param int $col OPTIONAL Position of the column to fetch.
* @return string
* @throws Zend_Db_Statement_Exception
*/
public function fetchColumn($col = 0)
{
if (!$this->_stmt) {
return false;
}
if (!oci_fetch($this->_stmt)) {
// if no error, there is simply no record
if (!($error = oci_error($this->_stmt))) {
return false;
}
/**
* @see Zend_Db_Adapter_Oracle_Exception
*/
require_once 'Zend/Db/Statement/Oracle/Exception.php';
throw new Zend_Db_Statement_Oracle_Exception($error);
}
$data = oci_result($this->_stmt, $col + 1);
//1-based
if ($data === false) {
/**
* @see Zend_Db_Adapter_Oracle_Exception
*/
require_once 'Zend/Db/Statement/Oracle/Exception.php';
throw new Zend_Db_Statement_Oracle_Exception(oci_error($this->_stmt));
}
if ($this->getLobAsString()) {
// instanceof doesn't allow '-', we must use a temporary string
$type = 'OCI-Lob';
if ($data instanceof $type) {
$data = $data->read($data->size());
}
}
return $data;
}
$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
$availQty = $unitQty - $assignmentQty;
?>
<label for="name" class="col-sm-2 control-label">SUBCONTRACTOR</label>
<div class="col-sm-10">
<?php
$subcontSql = "SELECT SUBCONT_ID FROM SUBCONTRACTOR";
$subcontParse = oci_parse($conn, $subcontSql);
oci_execute($subcontParse);
echo '<select class="form-control" name="subcontAssign" id="subcontAssign" onchange="bootstrapValidatorOpen();" data-bv-notempty="true" data-bv-notempty-message="SUBCONTRACTOR is required and cannot be empty">' . '<br>';
<?php
include "../../config.php";
include "../../function.php";
include "../../ibs_connector.php";
connect_to_base();
$query = mysql_query("SELECT * FROM `user` WHERE `id_in_ibs` = '0'");
if (mysql_num_rows($query) == 0) {
echo 'Не обнаруженно в базе данных агентов с пустым полем id_in_ibs';
exit;
}
while ($row = mysql_fetch_assoc($query)) {
$oracle_sql = oci_parse($conn, "\n select distinct c.contact_id, c.obj_name_orig\n \tfrom contact c\n\twhere c.contact_id in (select h.agent_id from ag_contract_header h)\n \tand c.contact_type_id = 3\n and c.obj_name_orig = '" . iconv('utf-8', 'windows-1251', trim($row['second_name']) . ' ' . trim($row['first_name']) . ' ' . trim($row['third_name'])) . "' \n ");
oci_execute($oracle_sql);
while (oci_fetch($oracle_sql)) {
mysql_query("UPDATE `user` SET `id_in_ibs` = '" . oci_result($oracle_sql, "CONTACT_ID") . "' WHERE `user_id` = '" . $row['user_id'] . "'");
}
}
}
if (!empty($_GET['munkanev'])) {
$kereses_lekerdez .= "MUNKANEV = '{$_GET['munkanev']}'";
}
if (!empty($_GET['rend'])) {
if ($_GET['rend'] == 2) {
$kereses_lekerdez .= " ORDER BY MUNKANEV";
} elseif ($_GET['rend'] == 1) {
$kereses_lekerdez .= " ORDER BY NEVE";
} elseif ($_GET['rend'] == 3) {
$kereses_lekerdez .= " ORDER BY (SELECT AVG(PONT) FROM ERTEKELES WHERE SZAKI.SZ_ID = ERTEKELES.SZ_ID) DESC";
}
}
$kereses = oci_parse($conn, $kereses_lekerdez);
oci_execute($kereses);
while (oci_fetch($kereses)) {
?>
<div class="col-md-3 col-xs-3">
<div class="panel panel-default">
<ul>
<img src="assets/img/szakik.png" style="width: 150px; height: 150px;">
<b><li><?php
echo oci_result($kereses, 'NEVE');
?>
</li></b>
<i><li><?php
echo oci_result($kereses, 'MUNKANEV');
?>
</li></i>
<li><?php
echo oci_result($kereses, 'MUNKATERULET');
