function edit()
{
$db =& JFactory::getDBO();
$user =& JFactory::getUser();
if ($this->_task == 'edit') {
$cid = JRequest::getVar('cid', array(0), 'method', 'array');
$cid = array((int) $cid[0]);
} else {
$cid = array(0);
}
$option = JRequest::getCmd('option');
$lists = array();
$row =& JTable::getInstance('banner', 'Table');
$row->load($cid[0]);
if ($cid[0]) {
$row->checkout($user->get('id'));
} else {
$row->showBanner = 1;
}
// Build Client select list
$sql = 'SELECT cid, name' . ' FROM #__bannerclient';
$db->setQuery($sql);
if (!$db->query()) {
$this->setRedirect('index.php?option=com_banners');
return JError::raiseWarning(500, $db->getErrorMsg());
}
$clientlist[] = JHTML::_('select.option', '0', JText::_('Select Client'), 'cid', 'name');
$clientlist = array_merge($clientlist, $db->loadObjectList());
$lists['cid'] = JHTML::_('select.genericlist', $clientlist, 'cid', 'class="inputbox" size="1"', 'cid', 'name', $row->cid);
// Imagelist
$javascript = 'onchange="changeDisplayImage();"';
$directory = '/images/banners';
$lists['imageurl'] = JHTML::_('list.images', 'imageurl', $row->imageurl, $javascript, $directory);
// build list of categories
$lists['catid'] = JHTML::_('list.category', 'catid', 'com_banner', intval($row->catid));
// sticky
$lists['sticky'] = JHTML::_('select.booleanlist', 'sticky', 'class="inputbox"', $row->sticky);
// published
$lists['showBanner'] = JHTML::_('select.booleanlist', 'showBanner', '', $row->showBanner);
require_once JPATH_COMPONENT . DS . 'views' . DS . 'banner.php';
BannersViewBanner::banner($row, $lists);
}
function banner(&$row, &$lists)
{
BannersViewBanner::setBannerToolbar();
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'custombannercode');
// agregado por G2P
$addTagsUrl = JRoute::_('index.php?option=com_customproperties&controller=hierarchictagging&view=hierarchictagging&ce_name=banner&id=' . $row->bid);
$selectTags = 'select v.name as value from #__custom_properties cp, #__custom_properties_values v, #__banner b where cp.value_id=v.id and cp.ref_table="banner" and cp.content_id=b.bid and b.bid=' . $row->bid;
$db = JFactory::getDBO();
$db->setQuery($selectTags);
$dbTags = $db->loadObjectList();
$aux = array();
foreach ($dbTags as $tag) {
$aux[] = $tag->value;
}
$tags = implode(', ', $aux);
// fin
?>
<script language="javascript" type="text/javascript">
<!--
function changeDisplayImage() {
if (document.adminForm.imageurl.value !='') {
document.adminForm.imagelib.src='../images/banners/' + document.adminForm.imageurl.value;
} else {
document.adminForm.imagelib.src='images/blank.png';
}
}
function submitbutton(pressbutton) {
var form = document.adminForm;
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.name.value == "") {
alert( "<?php
echo JText::_('You must provide a banner name.', true);
?>
" );
} else if (getSelectedValue('adminForm','cid') < 1) {
alert( "<?php
echo JText::_('Please select a client.', true);
?>
" );
/*} else if (!getSelectedValue('adminForm','imageurl')) {
alert( "<?php
echo JText::_('Please select an image.', true);
?>
" );*/
/*} else if (form.clickurl.value == "") {
alert( "<?php
echo JText::_('Please fill in the URL for the banner.', true);
?>
" );*/
} else if ( getSelectedValue('adminForm','catid') == 0 ) {
alert( "<?php
echo JText::_('Please select a category.', true);
?>
" );
} else {
submitform( pressbutton );
}
}
//-->
</script>
<form action="index.php" method="post" name="adminForm">
<div class="col100">
<fieldset class="adminform">
<legend><?php
echo JText::_('Details');
?>
</legend>
<table class="admintable">
<tbody>
<tr>
<td width="20%" class="key">
<label for="name">
<?php
echo JText::_('Name');
?>
:
</label>
</td>
<td width="80%">
<input class="inputbox" type="text" name="name" id="name" size="50" value="<?php
echo $row->name;
?>
" />
</td>
</tr>
<tr>
<td width="20%" class="key">
<label for="alias">
<?php
echo JText::_('Alias');
?>
:
</label>
</td>
<td width="80%">
<input class="inputbox" type="text" name="alias" id="alias" size="50" value="<?php
echo $row->alias;
?>
" />
</td>
</tr>
<tr>
<td class="key">
<?php
echo JText::_('Show Banner');
?>
:
</td>
<td>
<?php
echo $lists['showBanner'];
?>
</td>
</tr>
<tr>
<td class="key">
<?php
echo JText::_('Sticky');
?>
:
</td>
<td>
<?php
echo $lists['sticky'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="ordering">
<?php
echo JText::_('Ordering');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="ordering" id="ordering" size="6" value="<?php
echo $row->ordering;
?>
" />
</td>
</tr>
<tr>
<td valign="top" align="right" class="key">
<label for="catid">
<?php
echo JText::_('Category');
?>
:
</label>
</td>
<td>
<?php
echo $lists['catid'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="cid">
<?php
echo JText::_('Client Name');
?>
:
</label>
</td>
<td >
<?php
echo $lists['cid'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="imptotal">
<?php
echo JText::_('Impressions Purchased');
?>
:
</label>
</td>
<?php
$unlimited = '';
if ($row->imptotal == 0) {
$unlimited = 'checked="checked"';
$row->imptotal = '';
}
?>
<td>
<input class="inputbox" type="text" name="imptotal" id="imptotal" size="12" maxlength="11" value="<?php
echo $row->imptotal;
?>
" />
<label for="unlimited">
<?php
echo JText::_('Unlimited');
?>
</label>
<input type="checkbox" name="unlimited" id="unlimited" <?php
echo $unlimited;
?>
/>
</td>
</tr>
<tr>
<td class="key">
<label for="clickurl">
<?php
echo JText::_('Click URL');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="clickurl" id="clickurl" size="100" maxlength="200" value="<?php
echo $row->clickurl;
?>
" />
</td>
</tr>
<tr >
<td valign="top" align="right" class="key">
<?php
echo JText::_('Clicks');
?>
:
</td>
<td colspan="2">
<?php
echo $row->clicks;
?>
<input name="reset_hits" type="button" class="button" value="<?php
echo JText::_('Reset Clicks');
?>
" onclick="submitbutton('resethits');" />
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="custombannercode">
<?php
echo JText::_('Custom banner code');
?>
:
</label>
</td>
<td>
<textarea class="inputbox" cols="70" rows="8" name="custombannercode" id="custombannercode"><?php
echo $row->custombannercode;
?>
</textarea>
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="description">
<?php
echo JText::_('Description/Notes');
?>
:
</label>
</td>
<td>
<textarea class="inputbox" cols="70" rows="3" name="description" id="description"><?php
echo $row->description;
?>
</textarea>
</td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="imageurl">
<?php
echo JText::_('Banner Image Selector');
?>
:
</label>
</td>
<td >
<?php
echo $lists['imageurl'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="width">
<?php
echo JText::_('Width');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="width" id="width" size="6" value="<?php
echo $lists['width'];
?>
" />
</td>
</tr>
<tr>
<td class="key">
<label for="height">
<?php
echo JText::_('Height');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="height" id="height" size="6" value="<?php
echo $lists['height'];
?>
" />
</td>
</tr>
<tr>
<td valign="top" class="key">
<?php
echo JText::_('Banner Image');
?>
:
</td>
<td valign="top">
<?php
if (preg_match("#swf\$#i", $row->imageurl)) {
?>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" border="0" width="<?php
echo $lists['width'];
?>
" height="<?php
echo $lists['height'];
?>
">
<param name="movie" value="../images/banners/<?php
echo $row->imageurl;
?>
"><embed src="../images/banners/<?php
echo $row->imageurl;
?>
" loop="false" pluginspage="http://www.macromedia.com/go/get/flashplayer" type="application/x-shockwave-flash" width="<?php
echo $lists['width'];
?>
" height="<?php
echo $lists['height'];
?>
"></embed>
</object>
<?php
} elseif (preg_match("#gif|jpg|png#i", $row->imageurl)) {
?>
<img src="../images/banners/<?php
echo $row->imageurl;
?>
" name="imagelib" alt="<?php
echo $row->name;
?>
"/>
<?php
} else {
?>
<img src="images/blank.png" name="imagelib" alt="<?php
echo $row->name;
?>
"/>
<?php
}
?>
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="tags">
<?php
echo JText::_('Tags');
?>
:
</label>
</td>
<td>
<!-- AGREGADO POR G2P -->
<textarea class="inputbox"
cols="70"
rows="3"
name="mytags"
id="mytags"
readonly="yes"
><?php
echo $tags;
?>
</textarea>
<br>
<input type="button"
value="agregar tags"
name="buttontags"
onclick="window.location.href='<?php
echo $addTagsUrl;
?>
'"
/>
<!-- FIN -->
</td>
</tr>
</tbody>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="c" value="banner" />
<input type="hidden" name="option" value="com_banners" />
<input type="hidden" name="bid" value="<?php
echo $row->bid;
?>
" />
<input type="hidden" name="clicks" value="<?php
echo $row->clicks;
?>
" />
<input type="hidden" name="task" value="" />
<input type="hidden" name="impmade" value="<?php
echo $row->impmade;
?>
" />
<?php
echo JHTML::_('form.token');
?>
</form>
<?php
}
function banner(&$row, &$lists)
{
BannersViewBanner::setBannerToolbar();
JRequest::setVar('hidemainmenu', 1);
JFilterOutput::objectHTMLSafe($row, ENT_QUOTES, 'custombannercode');
?>
<script language="javascript" type="text/javascript">
<!--
function changeDisplayImage() {
if (document.adminForm.imageurl.value !='') {
document.adminForm.imagelib.src='../images/banners/' + document.adminForm.imageurl.value;
} else {
document.adminForm.imagelib.src='images/blank.png';
}
}
function submitbutton(pressbutton) {
var form = document.adminForm;
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
// do field validation
if (form.name.value == "") {
alert( "<?php
echo JText::_('You must provide a banner name.', true);
?>
" );
} else if (getSelectedValue('adminForm','cid') < 1) {
alert( "<?php
echo JText::_('Please select a client.', true);
?>
" );
/*} else if (!getSelectedValue('adminForm','imageurl')) {
alert( "<?php
echo JText::_('Please select an image.', true);
?>
" );*/
/*} else if (form.clickurl.value == "") {
alert( "<?php
echo JText::_('Please fill in the URL for the banner.', true);
?>
" );*/
} else if ( getSelectedValue('adminForm','catid') == 0 ) {
alert( "<?php
echo JText::_('Please select a category.', true);
?>
" );
} else {
submitform( pressbutton );
}
}
//-->
</script>
<form action="index.php" method="post" name="adminForm">
<div class="col100">
<fieldset class="adminform">
<legend><?php
echo JText::_('Details');
?>
</legend>
<table class="admintable">
<tbody>
<tr>
<td width="20%" class="key">
<label for="name">
<?php
echo JText::_('Name');
?>
:
</label>
</td>
<td width="80%">
<input class="inputbox" type="text" name="name" id="name" size="50" value="<?php
echo $row->name;
?>
" />
</td>
</tr>
<tr>
<td width="20%" class="key">
<label for="alias">
<?php
echo JText::_('Alias');
?>
:
</label>
</td>
<td width="80%">
<input class="inputbox" type="text" name="alias" id="alias" size="50" value="<?php
echo $row->alias;
?>
" />
</td>
</tr>
<tr>
<td class="key">
<?php
echo JText::_('Show Banner');
?>
:
</td>
<td>
<?php
echo $lists['showBanner'];
?>
</td>
</tr>
<tr>
<td class="key">
<?php
echo JText::_('Sticky');
?>
:
</td>
<td>
<?php
echo $lists['sticky'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="ordering">
<?php
echo JText::_('Ordering');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="ordering" id="ordering" size="6" value="<?php
echo $row->ordering;
?>
" />
</td>
</tr>
<tr>
<td valign="top" align="right" class="key">
<label for="catid">
<?php
echo JText::_('Category');
?>
:
</label>
</td>
<td>
<?php
echo $lists['catid'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="cid">
<?php
echo JText::_('Client Name');
?>
:
</label>
</td>
<td >
<?php
echo $lists['cid'];
?>
</td>
</tr>
<tr>
<td class="key">
<label for="imptotal">
<?php
echo JText::_('Impressions Purchased');
?>
:
</label>
</td>
<?php
$unlimited = '';
if ($row->imptotal == 0) {
$unlimited = 'checked="checked"';
$row->imptotal = '';
}
?>
<td>
<input class="inputbox" type="text" name="imptotal" id="imptotal" size="12" maxlength="11" value="<?php
echo $row->imptotal;
?>
" />
<label for="unlimited">
<?php
echo JText::_('Unlimited');
?>
</label>
<input type="checkbox" name="unlimited" id="unlimited" <?php
echo $unlimited;
?>
/>
</td>
</tr>
<tr>
<td class="key">
<label for="clickurl">
<?php
echo JText::_('Click URL');
?>
:
</label>
</td>
<td>
<input class="inputbox" type="text" name="clickurl" id="clickurl" size="100" maxlength="200" value="<?php
echo $row->clickurl;
?>
" />
</td>
</tr>
<tr >
<td valign="top" align="right" class="key">
<?php
echo JText::_('Clicks');
?>
</td>
<td colspan="2">
<?php
echo $row->clicks;
?>
<input name="reset_hits" type="button" class="button" value="<?php
echo JText::_('Reset Clicks');
?>
" onclick="submitbutton('resethits');" />
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="custombannercode">
<?php
echo JText::_('Custom banner code');
?>
:
</label>
</td>
<td>
<textarea class="inputbox" cols="70" rows="8" name="custombannercode" id="custombannercode"><?php
echo $row->custombannercode;
?>
</textarea>
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="description">
<?php
echo JText::_('Description/Notes');
?>
:
</label>
</td>
<td>
<textarea class="inputbox" cols="70" rows="3" name="description" id="description"><?php
echo $row->description;
?>
</textarea>
</td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="imageurl">
<?php
echo JText::_('Banner Image Selector');
?>
:
</label>
</td>
<td >
<?php
echo $lists['imageurl'];
?>
</td>
</tr>
<tr>
<td valign="top" class="key">
<?php
echo JText::_('Banner Image');
?>
:
</td>
<td valign="top">
<?php
if (eregi("swf", $row->imageurl)) {
?>
<img src="images/blank.png" name="imagelib">
<?php
} elseif (eregi("gif|jpg|png", $row->imageurl)) {
?>
<img src="../images/banners/<?php
echo $row->imageurl;
?>
" name="imagelib" />
<?php
} else {
?>
<img src="images/blank.png" name="imagelib" />
<?php
}
?>
</td>
</tr>
<tr>
<td valign="top" class="key">
<label for="tags">
<?php
echo JText::_('Tags');
?>
:
</label>
</td>
<td>
<textarea class="inputbox" cols="70" rows="3" name="tags" id="tags"><?php
echo $row->tags;
?>
</textarea>
</td>
</tr>
</tbody>
</table>
</fieldset>
</div>
<div class="clr"></div>
<input type="hidden" name="c" value="banner" />
<input type="hidden" name="option" value="com_banners" />
<input type="hidden" name="bid" value="<?php
echo $row->bid;
?>
" />
<input type="hidden" name="clicks" value="<?php
echo $row->clicks;
?>
" />
<input type="hidden" name="task" value="" />
<input type="hidden" name="impmade" value="<?php
echo $row->impmade;
?>
" />
<?php
echo JHTML::_('form.token');
?>
</form>
<?php
}
