<?php
$SQLFilter = '';
if ($isLogged && $pageName == 'myoffers')
$SQLFilter .= ' AND o.userOwnerId = '.$_SESSION['user']['id'];
else
if ($idCat > 0)
$SQLFilter .= ' AND o.categoryId = '.$idCat;
// Handle apply for a offer
$oid = (int)getParamPost('oid', -1);
if ($oid > 0 && (int)getParamPost('apply') == 1)
{
if ($isLogged)
{
$rs = $db->query('SELECT id FROM offers WHERE id = '.$oid);
if (count($rs))
$db->execute('INSERT INTO userAppplies (offerId, userEmployeeId) VALUES ('.$rs[0]['id'].', '.$_SESSION['user']['id'].')');
}
header('Location: ?page='.$pageName.'&id='.$oid);
exit();
}
// Handle favourites
$fav = (int)getParam('fav');
if ($fav > 0)
{
if ($isLogged)
{
$rs = $db->query('SELECT id FROM userFavourites WHERE userId = '.$_SESSION['user']['id'].' AND favouriteUserId = '.$fav);
if (count($rs) > 0)
$db->execute('DELETE FROM userFavourites WHERE id = '.$rs[0]['id']);
else
$db->execute('INSERT INTO userFavourites (userId, favouriteUserId) VALUES ('.$_SESSION['user']['id'].', '.$fav.')');
}
header('Location: '.removeFromURI($_SERVER['REQUEST_URI'],'fav'));
exit();
}
// Initialize
$id = (int)getParam('id', -1);
$action = getParam('action');
// Users` offer menu
$htmlUserOfferMenu = '';
if ($isLogged && $pageName == 'myoffers')
{
$chosen = 1;
if ($action == 'edit' || $id == 0)
$chosen = 2;
if ($action == 'users')
$chosen = 3;
$htmlUserOfferMenu =
'<div class="users-offer">'.
redButton(' Кандидати по обявата ', ($chosen!=3?"goToPage('".$pageName."&id=".$id."&action=users')":''), '', 'btn'.($chosen==3?'Red':'Blank')).
redButton(' Редактирай ', ($chosen!=2?"goToPage('".$pageName."&id=".$id."&action=edit')":''), '', 'btn'.($chosen==2?'Red':'Blank')).
redButton(' Преглед ', ($chosen!=1?"goToPage('".$pageName."&id=".$id."')":''), '', 'btn'.($chosen==1?'Red':'Blank')).'
</div>';
}
// Post / Edit offer
if ($action == 'edit' || $id == 0)
{
if (!$isLogged)
{
header('Location: ?page=offers');
exit();
}
if ($id > 0)
{
$rs = $db->query('SELECT * FROM offers WHERE userOwnerId = '.$_SESSION['user']['id'].' AND id = '.$id);
if (count($rs) < 1)
print 'Не съществува такава обява.';
else
$rs = $rs[0];
}
else
$rs = array(
'id' => 0,
'isPromoted' => 0,
'userOwnerId' => $_SESSION['user']['id'],
'categoryId' => 0,
'title' => '',
'shortDescription' => '',
'description' => '',
'keywords' => '',
'cityId' => $_SESSION['user']['cityId'],
'dateStart' => '0000-00-00',
'dateEnd' => '0000-00-00',
'dateDeadlineOffers' => '0000-00-00',
);
// Print users` offer menu
if ($id > 0 && $isLogged && $rs['userOwnerId'] == $_SESSION['user']['id'])
print str_replace('', 'Статус: '.txtStatus((int)$rs['status']), $htmlUserOfferMenu);
?>
<title><?=$rs['title']?></title>
<div class="pageframe pageframe-offers offers-edit">
<div class="top"></div>
<div class="cont">
<div id="idMsgDiv"></div>
<iframe id="regformframe" name="regformframe" src=""></iframe>
<form method="post" action="ajax.php?t=o" id="idForm" target="regformframe">
<input type="hidden" name="oid" value="<?=$rs['id']?>"/>
<div class="fld-name">Заглавие на обявата:</div>
<div class="fld"><input class="skinEdit skinFld685" name="offerTitle" maxlength="255" value="<?=$rs['title']?>"/></div>
<div class="fld-name fld-340">Категория:</div>
<div class="fld-name fld-340" style="padding-left:10px">Тип заетост:</div><br style="clear:both"/>
<div class="fld fld-340" style="position:relative"><?
$cbo = new AdvancedSelectCombo('categoryId', (int)$rs['categoryId'], getCategories(), 'skinCbo skinCbo335', 'idCategoryIdCbo');
print $cbo->display();
?>
</div>
<div class="fld fld-340" style="padding-left:10px"><?
$cbo = new AdvancedSelectCombo('jobType', 0, $jobType, 'skinCbo skinCbo335', 'idJobTypeCbo');
print $cbo->display();
?>
</div>
<br style="clear:both"/>
<div class="fld-name">
Ключови думи:
<div class="hint">(раздeлени със запетайка - ",")</div>
</div>
<div class="fld"><input class="skinEdit skinFld685" name="keywords" maxlength="255" value="<?=$rs['keywords']?>"/></div>
<div class="fld-name">Кратко описание:</div>
<div class="fld">
<textarea class="skinMemo skinFld685" name="shortDescription" onkeypress="return textareaMaxLength(this,255)" onchange="textareaMaxLengthChange(this,255)"><?=$rs['shortDescription']?></textarea>
</div>
<div class="fld-name">Описание:</div>
<div class="fld">
<textarea class="skinMemoBig skinFld685" name="description"><?=$rs['description']?></textarea>
</div>
<div class="fld-name fld-340">Град:</div>
<div class="fld-name fld-340" style="padding-left:10px">Крайна дата за кандидатстване:</div><br style="clear:both"/>
<div class="fld fld-340"><?
$cbo = new AdvancedSelectCombo('cityId', (int)$rs['cityId'], getCities(), 'skinCbo skinCbo335', 'idCityIdCbo');
print $cbo->display();
?>
</div>
<div class="fld fld-340" style="padding-left:10px">
<?=dateFields('dateDeadlineOffers', $rs['dateDeadlineOffers'], 'idDateDeadline')?>
</div>
<br style="clear:both"/>
<div class="fld-name fld-340">Начало на работа:</div>
<div class="fld-name fld-340" style="padding-left:10px">Край на работа:</div>
<br style="clear:both"/>
<div class="fld fld-340">
<?=dateFields('dateStart', $rs['dateStart'], 'idDateStart')?>
</div>
<div class="fld fld-340" style="padding-left:10px">
<?=dateFields('dateEnd', $rs['dateEnd'], 'idDateEnd')?>
</div>
<br style="clear:both"/>
<?
if ($id > 0)
{
?><div class="fld-name">
<?
$chk = new Checkbox('status', ($rs['status'] == 1), 'skinCheck', '', 'Активна');
print $chk->display();
?>
</div>
<div class="vip-div">
<?
if ($rs['isPromoted'] == 1)
print 'Вашата обява е VIP.';
else
{
?>
<input type="hidden" id="idCheck" value="<?=$id?>"/>
<div id="idVipDivResult"></div>
<img src="img/s.png" class="bullet-star" alt=""/> Вашата обява ще е VIP за 7 дни като изпратите SMS с текст <span>BGTIME</span> на кратък номер <span>1978</span> на цена 4,00 лв. без ДДС.<br/>
В отговор ще получите специален код, който трябва да въведете тук:
<?=redButton('Активирай', '', '', 'btnRed')?>
<input class="skinEdit skinFld100" style="margin-right:10px" id="idCode" maxlength="10" value=""/>
<?
}
?>
</div>
<?
}
?>
<div style="padding-top:10px;">
Ако искате вашата обява да е видима в секцията "Специални предложения", моля <a href="?page=about" style="font-size: 1em;" target="_blank">свържете се с нас</a>.
</div>
<div class="buttons">
<?
if ($id > 0)
print redButton('Откажи', "goToPage('".$pageName."&id=".$id."')", '', 'btnRed');
print redButton('Запази', 'formSubmit()', '', 'btnRed');
if ($id > 0)
print redButton('Галерия', "goToPage('gallery&oid=".$id."')", '', 'btnRed', ' style="float:left;margin-left:0"');
?>
</div>
<script type="text/javascript" language="JavaScript">
if (clientIE6) document.write('<br style="clear:both"/>');
</script>
</form>
</div>
<div class="foot"></div>
</div>
<?
}
else
// List applied users
if ($id > 0 && $action == 'users')
{
if (!$isLogged)
{
header('Location: ?page=offers&id='.$id);
exit();
}
$rs = $db->query(
'SELECT u.id, u.names, u.image, u.address, u.email, u.phone, u.homepage, u.shortInfo, u.userType, u.isExtenedProfile, u.keywords, '.
' cat.title AS categoryName, c.name AS cityName, f.id AS favouriteId '.
'FROM users u '.
'LEFT JOIN categories cat ON u.categoryId = cat.id '.
'LEFT JOIN cities c ON u.cityId = c.id '.
'LEFT JOIN userFavourites f ON (f.favouriteUserId = u.id AND f.userId = '.$_SESSION['user']['id'].') '.
'WHERE u.id IN (SELECT userEmployeeId FROM userAppplies WHERE offerId = '.$id.') '.
'ORDER BY favouriteId DESC, u.names'
);
if (!$isLogged)
printBanner('728x90', 'style="margin-top:0"');
$rsOffer = $db->query('SELECT status, userOwnerId FROM offers WHERE id = '.$id);
$offerStatus = '';
$offerOwnerId = 0;
if (count($rsOffer) > 0)
{
$offerStatus = 'Статус: '.txtStatus((int)$rsOffer[0]['status']);
$offerOwnerId = (int)$rsOffer[0]['userOwnerId'];
}
// Print users` offer menu
if ($isLogged && $offerOwnerId == $_SESSION['user']['id'])
print str_replace('', $offerStatus, $htmlUserOfferMenu);
?>
<div class="listing">
<h3>Кандидати</h3>
<?
foreach($rs as $i=>$row)
{
?><div class="item<?=($i%2==0?'-alt':'').((int)$row['favouriteId'] > 0 ? ' item-fav' : '')?>">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><?
if ($row['image'] != '')
print '<img class="logo" src="'.SYS_UPLOAD_PATH.$row['image'].'" alt=""/></td><td>';
?>
<a href="?page=users&id=<?=$row['id']?>" class="title"><?=$row['names']?></a><br/><?=$row['shortInfo']?><br/>
<b>Категория:</b> <?=$row['categoryName']?><br/>
<b>Местонахождение: </b><?=$row['cityName']?>
</td>
</tr>
</table>
<?
print redButton('Профил', "goToPage('users&id=".$row['id']."')");
$chk = new Checkbox('chkFav'.$row['id'], ((int)$row['favouriteId'] > 0), 'skinCheck', '', 'Favourite');
print '<div class="fav-div">'.$chk->display().'</div>';
?>
</div>
<?
}
?>
</div>
<?
}
else
// View offer
if ($id > 0)
{
$rs = $db->query(
'SELECT o.*, u.names, u.address, u.homepage, u.shortInfo, u.image AS logo, cat.title AS categoryName, c.name AS cityName, uc.name AS userCityName '.
'FROM offers o, categories cat, cities c, users u '.
'LEFT JOIN cities uc ON uc.id = u.cityId '.
'WHERE o.categoryId = cat.id AND o.cityId = c.id AND o.userOwnerId = u.id AND o.id = '.$id
);
if (count($rs) < 1)
print 'Не съществува такава обява.';
else
{
$rs = $rs[0];
if (!$isLogged || $pageName != 'myoffers')
printBanner('728x90', 'style="margin-top:0"');
$subQuery = '0';
if ($isLogged)
$subQuery = 'SELECT COUNT(id) FROM userAppplies WHERE offerId = '.$rs['id'].' AND userEmployeeId = '.$_SESSION['user']['id'];
$rsApplies = $db->query(
'SELECT COUNT(id) AS cnt, ('.$subQuery.') AS isApplied FROM userAppplies WHERE offerId = '.$rs['id']
);
$rsApplies = $rsApplies[0];
// Print users` offer menu
if ($isLogged && $rs['userOwnerId'] == $_SESSION['user']['id'])
print str_replace('', 'Статус: '.txtStatus((int)$rs['status']), $htmlUserOfferMenu);
$strApplied = '';
if ($rsApplies['isApplied'] > 0)
$strApplied = ' <i>(Вие сте кандидаствали за тази обява)</i>';
if (!$isLogged || $pageName != 'myoffers') {
?>
<div class="section section-big section-big-offerInfo">
<div class="title"></div>
<div class="cont">
<?
} else {
?>
<div class="pageframe pageframe-offers">
<div class="top"></div>
<div class="cont">
<?
}
if ($isLogged && $pageName == 'myoffers' && $rs['userOwnerId'] == $_SESSION['user']['id'])
print redButton('Редактирай', "goToPage('".$pageName."&id=".$id."&action=edit')", '', 'btnRed', ' style="float:right"');
?>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><?
if ($rs['logo'] != '')
print '<img src="storage/'.$rs['logo'].'" class="logo" alt=""/></td><td>';
?>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="fld-name">Работодател:</td>
<td><?=$rs['names']?></td>
</tr>
<tr>
<td class="fld-name">Град:</td>
<td><?=$rs['userCityName']?></td>
</tr>
<tr>
<td class="fld-name">Адрес:</td>
<td><?=$rs['address']?></td>
</tr>
<?
if ($rs['homepage'] != '')
{
?>
<tr>
<td class="fld-name">Web сайт:</td>
<td><a href="<?=$rs['homepage']?>" target="_blank"><?=$rs['homepage']?></a></td>
</tr>
<?
}
?>
</table>
<?
if ($rs['shortInfo'] != '')
{
?><div style="padding-top:4px"><?=str_replace("\n", '<br/>', $rs['shortInfo'])?></div><?
}
?>
</td>
</tr>
</table>
<br style="clear: both"/>
<h3><span>Добавена на: <?=formTimeStamp($rs['datePosted'], '%d.%m.%y')?></span><?=$rs['title']?></h3>
<div style="padding-bottom:15px;"><?=str_replace("\n", '<br/>', $rs['description'])?></div>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="fld-name">Категория:</td>
<td><?=$rs['categoryName']?></td>
</tr>
<?
if ($rs['keywords'] != '')
{
?>
<tr>
<td class="fld-name">Ключови думи:</td>
<td><?=$rs['keywords']?></td>
</tr>
<?
}
?>
<tr>
<td class="fld-name">Тип заетост:</td>
<td><?=$jobType[(int)$rs['jobType']]?></td>
</tr>
<tr>
<td class="fld-name">Град:</td>
<td><?=$rs['cityName']?></td>
</tr>
<tr>
<td class="fld-name">Крайна дата за<br/>кандидатстване:</td>
<td><?=formTimeStamp($rs['dateDeadlineOffers'], '%d.%m.%y')?></td>
</tr>
<?
if ($rs['dateStart'] != '')
{
$txt = formTimeStamp($rs['dateStart'], '%d.%m.%y');
if ($rs['dateEnd'] != '')
$txt .= ' - '.formTimeStamp($rs['dateEnd'], '%d.%m.%y');
?>
<tr>
<td class="fld-name">Период на работа:</td>
<td><?=$txt?></td>
</tr>
<?
}
?>
<tr>
<td class="fld-name">Кандидати:</td>
<td><?=($rsApplies['cnt'].$strApplied)?></td>
</tr>
<?
if ($isLogged && $rs['userOwnerId'] != $_SESSION['user']['id'] && $rsApplies['isApplied'] < 1
&& ($_SESSION['user']['userType'] == USER_EMPLOYEE || $_SESSION['user']['isExtenedProfile'] == 1))
{
?>
<form method="post" action="" id="idApplyForm">
<input type="hidden" name="oid" value="<?=$id?>"/>
<input type="hidden" name="apply" value="1"/>
<input class="skinBtn btn-apply" type="button" value=""/>
</form>
<?
}
$rs = $db->query('SELECT * FROM gallery WHERE offerId = '.$id.' ORDER BY id');
if (count($rs) > 0)
{
?>
<tr>
<td class="fld-name" style="vertical-align:top;padding-top:20px">Галерия:</td>
<td><?
printGallery($rs, FALSE, 3);
?>
</td>
</tr>
<?
}
?>
</table>
</div>
<div class="foot"></div>
</div>
<?
}
}
else
// Listing
{
header('Location: ?page=home');
exit();
/*
$rs = $db->query(
'SELECT o.*, u.names, u.image, cat.title AS categoryName, c.name AS cityName '.
'FROM offers o, categories cat, cities c, users u '.
'WHERE o.categoryId = cat.id AND o.cityId = c.id AND o.userOwnerId = u.id'.$SQLFilter
);
$arrData = array();
foreach($rs as $row)
{
$arrData[] = array(
'image' => $row['image'],
'title' => $row['title'],
'desc' => $row['shortDescription'],
'spec' => $row['categoryName'],
'city' => $row['cityName'],
'link' => $pageName.'&id='.$row['id'],
'linkTxt' => 'Подробно',
);
}
printListing('Обяви', $arrData);
*/
}