public static function markTagAsSold($tag)
{
$db =& JFactory::getDBO();
$query = "UPDATE #__cbodb_items SET isSold = TRUE WHERE tag = '" . $tag . "'";
$db->setQuery($query);
$result = $db->loadResult();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
} else {
return true;
}
}
}
/* END class CbodbItem */
CbodbItem::$commissionMechanics = CbodbItem::getCommissionedMechanics();
class CbodbTask
{
private $id;
public $data;
public function __construct($id = null)
{
$row =& JTable::getInstance('task', 'Table');
if ($id) {
$row->id = $id;
$row->load($this->id);
}
$this->data = $row;
}
public function __get($member)
{
function addBicycle($option, $memberID)
{
//$commissionMechanics = CbodbMember::getGroupMemberList($option, "Commission mechanic");
$commissionMechanics = CbodbItem::getCommissionedMechanics();
$commissionMechanics[0] = "No one";
ksort($commissionMechanics);
?>
<h2>Enter a Bicycle</h2>
<p>Use this form to enter the bicycle you've been working on into our database system. When you're done, press "Save and Finish", and the system will give a tag number to write on the bicycle's paper tag.</p>
<?php
JHTML::_('behavior.formvalidation');
?>
<script language="javascript">
function myValidate(f) {
if (document.formvalidator.isValid(f)) {
f.check.value='<?php
echo JUtility::getToken();
?>
'; //send token
return true;
}
else {
var msg = 'You have not entered all necessary values for this bicycle:';
//Example on how to test specific fields
if($('bikeBrand').hasClass('invalid')){msg += '\n\n\tMissing Brand';}
if($('bikeModel').hasClass('invalid')){msg += '\n\tMissing Model';}
if($('bikeColor').hasClass('invalid')){msg += '\n\tMissing Color';}
if($('bikeSerial').hasClass('invalid')){msg += '\n\tMissing Serial';}
if($('priceSale').hasClass('invalid')){msg += '\n\tMissing Price';}
if($('bikeSize1').hasClass('invalid')){msg += '\n\tMissing Height';}
if($('bikeSize2').hasClass('invalid')){msg += '\n\tMissing Length';}
if($('bikeSize3').hasClass('invalid')){msg += '\n\tMissing Tire Size';}
alert(msg);
}
return false;
}
</script>
<form id="test-form" method="post" class="form-validate" onSubmit="return myValidate(this);">
<input type="hidden" name="check" value="post"/>
<table>
<tr>
<td width="200" align="right" class="key">Bike Brand:</td>
<td><input type="text" class="required" name="bikeBrand" id="bikeBrand" size="20" maxlength="50" value="" /></td>
</tr>
<tr>
<td width="200" align="right" class="key">Bike Model:</td>
<td><input type="text" class="required" name="bikeModel" id="bikeModel" size="20" maxlength="50" /></td>
</tr>
<tr>
<td width="200" align="right" class="key">Color:</td>
<td><input class="required" type="text" name="bikeColor" id="bikeColor" size="20" maxlength="50" /></td>
</tr>
<tr>
<td width="200" align="right" class="key">Bike Serial Number:</td>
<td><input class="required" type="text" name="bikeSerial" id="bikeSerial" size="20" maxlength="50" /></td>
</tr>
<tr>
<td width="100" align="right" class="key">Sale Price:</td>
<td><input class="required" type="text" name="priceSale" id="priceSale" size="50" maxlength="250" /></td>
</tr>
<tr>
<td width="100" align="right" class="key">Is it for sale?</td>
<td><input type="checkbox" name="isForSale" id="isForSale" /></td>
</tr>
<tr>
<td width="100" align="right" class="key">Is it ready?</td>
<td><input type="checkbox" name="isReady" id="isReady" /></td>
</tr>
<tr>
<td width="100" align="right" class="key">Size:</td>
<td>
<input class="required" type="text" name="bikeSize1" id="bikeSize1" size="5" maxlength="250" /> x
<input class="required" type="text" name="bikeSize2" id="bikeSize2" size="5" maxlength="250" /> x
<input class="required" type="text" name="bikeSize3" id="bikeSize3" size="5" maxlength="250" />
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Location:</td>
<td><?php
HTML_cbodb::dropdownFromArray("location", CbodbItem::$itemLocationArray, 0);
?>
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Style:</td>
<td><?php
HTML_cbodb::dropdownFromArray("bikeStyle", CbodbItem::$itemBikeStyleArray, 0);
?>
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Drivetrain:</td>
<td><?php
HTML_cbodb::dropdownFromArray("bikeDrivetrain", CbodbItem::$itemBikeDrivetrainArray, 0);
?>
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Frame style:</td>
<td><?php
HTML_cbodb::dropdownFromArray("bikeFrameStyle", CbodbItem::$itemBikeFrameStyleArray, 0);
?>
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Tire Style:</td>
<td><?php
HTML_cbodb::dropdownFromArray("bikeTireStyle", CbodbItem::$itemBikeTireStyleArray, 0);
?>
</td>
</tr>
<tr>
<td width="100" align="right" class="key">Commission:</td>
<td><?php
HTML_cbodb::dropdownFromArray("commissionUserID", $commissionMechanics, 0);
?>
</td>
</tr>
</table>
<br />
<input type="submit" name="membersubmit" value="Save and Finish">
<input type="hidden" name="memberID" value="<?php
echo $memberID;
?>
">
<input type="hidden" name="option" value="<?php
echo $option;
?>
" />
<input type="hidden" name="task" value="savenewbicycle" />
<input type="hidden" name="isBike" value="on" />
</form>
<?php
}
