include $relative."php_library/config.inc.php";
$conn = OCILogon($defaultUser, $defaultPassword, $defaultTNS) or die('Veritabanı bağlantısı kurulamadı!!!');
$strSQL="
select
case
when
belge_bas_tar<=sysdate and belge_bit_tar>=sysdate
then '2'
when
bas_tar<=sysdate and bit_tar>=sysdate
then '1'
when
bit_tar<=sysdate and belge_bas_tar>=sysdate
then '3'
else' 0'
end as degeri,
to_char(bas_tar,'dd.mm.yyyy HH24:mi:ss') as bas_tar ,
to_char(bit_tar,'dd.mm.yyyy HH24:mi:ss') as bit_tar,
to_char(belge_bas_tar,'dd.mm.yyyy HH24:mi:ss') as belge_bas_tar,
to_char(belge_bit_tar,'dd.mm.yyyy HH24:mi:ss') as belge_bit_tar
from (SELECT to_date((substr(degeri,2,2)||'-'||substr(degeri,4,2)||'-'||substr(degeri,6,4)||' '||substr(degeri,10,2)||':'||substr(degeri,12,2)||':'||'00'),'dd-mm-YYYY HH24:MI:SS') as bas_tar FROM parametre where adi='ozel_yetenek_basvuru_baslama') bas , (SELECT to_date((substr(degeri,2,2)||'-'||substr(degeri,4,2)||'-'||substr(degeri,6,4)||' '||substr(degeri,10,2)||':'||substr(degeri,12,2)||':'||'00'),'dd-mm-YYYY HH24:MI:SS') as bit_tar FROM parametre where adi='ozel_yetenek_basvuru_bitis') bit ,
(SELECT to_date((substr(degeri,2,2)||'-'||substr(degeri,4,2)||'-'||substr(degeri,6,4)||' '||substr(degeri,10,2)||':'||substr(degeri,12,2)||':'||'00'),'dd-mm-YYYY HH24:MI:SS') as belge_bas_tar FROM parametre where adi='ozel_yetenek_basvuru_belge_bas') belge_bas , (SELECT to_date((substr(degeri,2,2)||'-'||substr(degeri,4,2)||'-'||substr(degeri,6,4)||' '||substr(degeri,10,2)||':'||substr(degeri,12,2)||':'||'00'),'dd-mm-YYYY HH24:MI:SS') as belge_bit_tar FROM parametre where adi='ozel_yetenek_basvuru_belge_bit') belge_bit
";
/*"select
case
when
to_date(belge_bas_tar)<=to_date(sysdate,'dd.mm.yyyy') and to_date(belge_bit_tar)>=to_date(sysdate,'dd.mm.yyyy')
then '2'
when
to_date(bas_tar)<=to_date(sysdate,'dd.mm.yyyy') and to_date(bit_tar)>=to_date(sysdate,'dd.mm.yyyy')
then '1'
when
to_date(bit_tar)<=to_date(sysdate,'dd.mm.yyyy') and to_date(belge_bas_tar)>=to_date(sysdate,'dd.mm.yyyy')
then '3'
else' 0'
end as degeri,
to_date(bas_tar)as bas_tar,
to_date(bit_tar) as bit_tar,
to_date(belge_bas_tar)as belge_bas_tar,
to_date(belge_bit_tar) as belge_bit_tar
from (SELECT to_date( substr(degeri,2,2)||substr(degeri,4,2)||substr(degeri,6,4)) as bas_tar FROM parametre where adi='ozel_yetenek_basvuru_baslama') bas , (SELECT to_date( substr(degeri,2,2)||substr(degeri,4,2)||substr(degeri,6,4)) as bit_tar FROM parametre where adi='ozel_yetenek_basvuru_bitis') bit ,
(SELECT to_date( substr(degeri,2,2)||substr(degeri,4,2)||substr(degeri,6,4)) as belge_bas_tar FROM parametre where adi='ozel_yetenek_basvuru_belge_bas') belge_bas , (SELECT to_date( substr(degeri,2,2)||substr(degeri,4,2)||substr(degeri,6,4)) as belge_bit_tar FROM parametre where adi='ozel_yetenek_basvuru_belge_bit') belge_bit
";*/
//$strSQL="SELECT degeri FROM parametre where adi='yos_bas_tar'";
$stmt = ociparse($conn,$strSQL);
ociexecute($stmt,OCI_DEFAULT);
OCIFetchInto($stmt,$row,OCI_ASSOC);
//$gun=substr($row[DEGERI],1,2);
//$ay=substr($row[DEGERI],3,2);
$basla_tar =$row[BAS_TAR];//.' 09:00';
$bitis_tar = $row[BIT_TAR];//.' 17:00';
$belge_basla_tar = $row[BELGE_BAS_TAR];
$belge_bitis_tar = $row[BELGE_BIT_TAR];
$baslama =$row[DEGERI];
// e�er $baslama = 1 ise ba�vuru yapar
// e�er $baslama =3 ise ara d�nem i�lem yapamaz uyar� al�r
// e�er $baslama =2 ise ba�vuru belgesi al�r
// e�er $baslama =0 tarih d��� oldu�undan i�lem yapamaz.
OCIFreeStatement($stmt);
if ($_SERVER['REMOTE_ADDR'] == '161.9.130.12'|| $_SERVER['REMOTE_ADDR'] == '193.140.151.55'|| $_SERVER['REMOTE_ADDR'] == '194.27.57.95'|| $_SERVER['REMOTE_ADDR'] == '194.27.174.175')
{
//echo "$baslama
";
//echo "$tercih_zaman
";
//echo "$strSQL";
$baslama=1;
// echo "DEGERI: $row[DEGERI]
";
// echo "TERCIH_ZAMAN $row[TERCIH_ZAMAN]";
}
/*
if ($_SERVER['REMOTE_ADDR'] == '161.9.133.181' || $_SERVER['REMOTE_ADDR'] == '194.27.172.50' || $_SERVER['REMOTE_ADDR'] == '161.9.131.173')
{
$baslama=2;
}
*/
// if ( $baslama==1 || $tercih_zaman==1)
// {
$strSQL="select ogretim_donemi_id as degeri ,adi from ogretim_donemi where trim(substr(adi,1,4))=trim(to_char(sysdate,'yyyy')) and mevsimi='G'order by adi desc";
$stmt = ociparse($conn,$strSQL);
ociexecute($stmt,OCI_DEFAULT);
OCIFetchInto($stmt,$row,OCI_ASSOC);
$ogretim_donemi_id = $row[DEGERI];
$ogretim_donemi_adi = $row[ADI];
OCIFreeStatement($stmt);
?>
function ust_menu ($relative)
{
global $relative;// ../../images/debis/debis.css
$text= "
|
|