function loadAuctions()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$this->auctions = array();
$sqlStr = "SELECT\n auc_lKeyID, auc_strAuctionName, auc_strDescription,\n auc_dteAuctionDate,\n\n auc_strLocation, auc_strContact, auc_strPhone, auc_strEmail,\n auc_lDefaultBidSheet, abs_lKeyID, abs_lTemplateID, abs_strSheetName,\n auc_lCampaignID, gc_strCampaign,\n ga_lKeyID, ga_strAccount,\n\n auc_lACOID,\n aco_strFlag, aco_strCurrencySymbol, aco_strName,\n\n auc_lOriginID, auc_lLastUpdateID,\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n UNIX_TIMESTAMP(auc_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(auc_dteLastUpdate) AS dteLastUpdate\n\n FROM gifts_auctions\n INNER JOIN admin_users AS usersC ON auc_lOriginID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON auc_lLastUpdateID = usersL.us_lKeyID\n INNER JOIN admin_aco ON auc_lACOID = aco_lKeyID\n INNER JOIN gifts_campaigns ON auc_lCampaignID = gc_lKeyID\n INNER JOIN gifts_accounts ON gc_lAcctID = ga_lKeyID\n LEFT JOIN gifts_auctions_bidsheets ON abs_lKeyID = auc_lDefaultBidSheet\n\n WHERE NOT auc_bRetired\n {$this->strWhereExtra}\n ORDER BY auc_dteAuctionDate DESC, auc_strAuctionName, auc_lKeyID;";
$query = $this->db->query($sqlStr);
$this->lNumAuctions = $lNumAuctions = $query->num_rows();
if ($lNumAuctions == 0) {
$this->auctions[0] = new stdClass();
$auction =& $this->auctions[0];
$auction->lKeyID = $auction->strAuctionName = $auction->strSafeName = $auction->strDescription = $auction->dteAuction = $auction->mdteAuction = $auction->lDefaultBidSheet = $auction->lBidsheetID = $auction->lTemplateID = $auction->tInfo = $auction->strLocation = $auction->strContact = $auction->strPhone = $auction->strEmail = $auction->lCampaignID = $auction->strCampaign = $auction->lAccountID = $auction->strAccount = $auction->lACOID = $auction->strFlag = $auction->strCurrencySymbol = $auction->strACOName = $auction->auc_lOriginID = $auction->auc_lLastUpdateID = $auction->strCFName = $auction->strCLName = $auction->strLFName = $auction->strLLName = $auction->dteOrigin = $auction->dteLastUpdate = null;
} else {
$idx = 0;
$cACO = new madmin_aco();
foreach ($query->result() as $row) {
$this->auctions[$idx] = new stdClass();
$auction =& $this->auctions[$idx];
$auction->lKeyID = $row->auc_lKeyID;
$auction->strAuctionName = $row->auc_strAuctionName;
$auction->strSafeName = htmlspecialchars($row->auc_strAuctionName);
$auction->strDescription = $row->auc_strDescription;
$auction->dteAuction = dteMySQLDate2Unix($row->auc_dteAuctionDate);
$auction->mdteAuction = $row->auc_dteAuctionDate;
$auction->lDefaultBidSheet = $row->auc_lDefaultBidSheet;
$auction->lBidsheetID = $row->abs_lKeyID;
$auction->lTemplateID = $lTemplateID = $row->abs_lTemplateID;
if (is_null($lTemplateID)) {
$auction->tInfo = null;
} else {
strXlateTemplate($lTemplateID, $auction->tInfo);
}
$auction->strSheetName = $row->abs_strSheetName;
$auction->lCampaignID = $row->auc_lCampaignID;
$auction->strCampaign = $row->gc_strCampaign;
$auction->lAccountID = $row->ga_lKeyID;
$auction->strAccount = $row->ga_strAccount;
$auction->strLocation = $row->auc_strLocation;
$auction->strContact = $row->auc_strContact;
$auction->strPhone = $row->auc_strPhone;
$auction->strEmail = $row->auc_strEmail;
$auction->lACOID = $row->auc_lACOID;
$auction->strCurrencySymbol = $row->aco_strCurrencySymbol;
$auction->strACOName = $row->aco_strName;
$auction->strFlag = $row->aco_strFlag;
$auction->strFlagImg = $cACO->strFlagImage($auction->strFlag, $auction->strACOName);
$auction->auc_lOriginID = $row->auc_lOriginID;
$auction->auc_lLastUpdateID = $row->auc_lLastUpdateID;
$auction->strCFName = $row->strCFName;
$auction->strCLName = $row->strCLName;
$auction->strLFName = $row->strLFName;
$auction->strLLName = $row->strLLName;
$auction->dteOrigin = $row->dteOrigin;
$auction->dteLastUpdate = $row->dteLastUpdate;
++$idx;
}
}
}
function loadPackages()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$packages = array();
$sqlStr = "SELECT\n ap_lKeyID, ap_lAuctionID, ap_strPackageName,\n ap_curMinBidAmnt, ap_curReserveAmnt, ap_curMinBidInc,\n ap_curBuyItNowAmnt, ap_curWinBidAmnt,\n ap_strDescription, ap_strInternalNotes, ap_lBidWinnerID, ap_dteWinnerContact,\n ap_lBidSheetID, abs_lKeyID, abs_lTemplateID, abs_strSheetName,\n ap_lGiftID, gi_curAmnt,\n\n bwPeople.pe_bBiz AS bw_bBiz, bwPeople.pe_strFName AS bw_strFName, bwPeople.pe_strLName AS bw_strLName,\n\n auc_strAuctionName, auc_lDefaultBidSheet, auc_dteAuctionDate,\n auc_lACOID, aco_strFlag, aco_strCurrencySymbol,\n\n ap_lOriginID, ap_lLastUpdateID,\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n UNIX_TIMESTAMP(ap_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(ap_dteLastUpdate) AS dteLastUpdate\n\n FROM gifts_auctions_packages\n INNER JOIN gifts_auctions ON ap_lAuctionID = auc_lKeyID\n INNER JOIN admin_aco ON auc_lACOID = aco_lKeyID\n INNER JOIN admin_users AS usersC ON ap_lOriginID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON ap_lLastUpdateID = usersL.us_lKeyID\n LEFT JOIN gifts ON ap_lGiftID = gi_lKeyID\n LEFT JOIN gifts_auctions_bidsheets ON abs_lKeyID = ap_lBidSheetID\n LEFT JOIN people_names AS bwPeople ON pe_lKeyID = ap_lBidWinnerID\n\n WHERE NOT auc_bRetired AND NOT ap_bRetired\n {$this->strWhereExtra}\n ORDER BY ap_strPackageName, ap_lKeyID;";
$query = $this->db->query($sqlStr);
$this->lNumPackages = $query->num_rows();
if ($this->lNumPackages == 0) {
$this->packages[0] = new stdClass();
$package =& $this->packages[0];
$package->lKeyID = $package->lAuctionID = $package->lACOID = $package->strFlag = $package->strCurrencySymbol = $package->strAuctionName = $package->dteAuction = $package->strPackageName = $package->strPackageSafeName = $package->curMinBidAmnt = $package->curReserveAmnt = $package->curMinBidInc = $package->curBuyItNowAmnt = $package->curWinBidAmnt = $package->curActualGiftAmnt = $package->strDescription = $package->strInternalNotes = $package->lBidWinnerID = $package->dteContacted = $package->mdteContacted = $package->lGiftID = $package->lOriginID = $package->lLastUpdateID = $package->strCFName = $package->strCLName = $package->strLFName = $package->strLLName = $package->dteOrigin = $package->dteLastUpdate = null;
} else {
$idx = 0;
foreach ($query->result() as $row) {
$this->packages[$idx] = new stdClass();
$package =& $this->packages[$idx];
$package->lKeyID = $row->ap_lKeyID;
$package->lAuctionID = $row->ap_lAuctionID;
$package->strAuctionName = $row->auc_strAuctionName;
$package->dteAuction = dteMySQLDate2Unix($row->auc_dteAuctionDate);
$package->lACOID = $row->auc_lACOID;
$package->strFlag = $row->aco_strFlag;
$package->strCurrencySymbol = $row->aco_strCurrencySymbol;
$package->strPackageName = $row->ap_strPackageName;
$package->strPackageSafeName = htmlspecialchars($row->ap_strPackageName);
$package->curMinBidAmnt = $row->ap_curMinBidAmnt;
$package->curBuyItNowAmnt = $row->ap_curBuyItNowAmnt;
$package->curReserveAmnt = $row->ap_curReserveAmnt;
$package->curMinBidInc = $row->ap_curMinBidInc;
$package->curWinBidAmnt = $row->ap_curWinBidAmnt;
$package->curActualGiftAmnt = $row->gi_curAmnt;
$package->strDescription = $row->ap_strDescription;
$package->strInternalNotes = $row->ap_strInternalNotes;
$package->lBidSheetID = $row->ap_lBidSheetID;
if (is_null($package->lBidSheetID)) {
$package->lBidSheetID = $row->auc_lDefaultBidSheet;
}
$package->lTemplateID = $lTemplateID = $row->abs_lTemplateID;
if (is_null($lTemplateID)) {
$package->tInfo = null;
} else {
strXlateTemplate($lTemplateID, $package->tInfo);
}
$package->strSheetName = $row->abs_strSheetName;
$package->lBidWinnerID = $row->ap_lBidWinnerID;
$package->bw_bBiz = $row->bw_bBiz;
$package->bw_strFName = $row->bw_strFName;
$package->bw_strLName = $row->bw_strLName;
if (is_null($package->lBidWinnerID)) {
$package->bw_strSafeName = 'not set';
} else {
if ($package->bw_bBiz) {
$package->bw_strSafeName = htmlspecialchars($package->bw_strLName) . ' (business)';
} else {
$package->bw_strSafeName = htmlspecialchars($package->bw_strFName . ' ' . $package->bw_strLName);
}
}
$package->dteContacted = dteMySQLDate2Unix($row->ap_dteWinnerContact);
$package->mdteContacted = $row->ap_dteWinnerContact;
$package->lGiftID = $row->ap_lGiftID;
$package->lOriginID = $row->ap_lOriginID;
$package->lLastUpdateID = $row->ap_lLastUpdateID;
$package->strCFName = $row->strCFName;
$package->strCLName = $row->strCLName;
$package->strLFName = $row->strLFName;
$package->strLLName = $row->strLLName;
$package->dteOrigin = $row->dteOrigin;
$package->dteLastUpdate = $row->dteLastUpdate;
++$idx;
}
}
}
function viewBidSheet($lBSID)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
if (!bTestForURLHack('showAuctions')) {
return;
}
$this->load->helper('dl_util/verify_id');
verifyID($this, $lBSID, 'bidsheet ID');
$displayData = array();
$displayData['js'] = '';
$displayData['lBSID'] = $lBSID = (int) $lBSID;
//-------------------------
// models & helpers
//-------------------------
$params = array('enumStyle' => 'terse', 'clsRpt');
$this->load->library('generic_rpt', $params);
$this->load->model('auctions/mbid_sheets', 'cBidSheets');
$this->load->helper('auctions/auction');
$this->load->helper('dl_util/pdf');
$this->load->helper('dl_util/link_auction');
$this->load->helper('img_docs/image_doc');
$this->load->helper('img_docs/link_img_docs');
$this->load->helper('dl_util/web_layout');
$this->cBidSheets->loadSheetByBSID($lBSID);
$displayData['bs'] = $bs =& $this->cBidSheets->bidSheets[0];
strXlateTemplate($bs->lTemplateID, $bs->tInfo);
$lTemplateID = $bs->lTemplateID;
$displayData['template'] = new stdClass();
loadDefaultTemplateVals($lTemplateID, false, $displayData['template'], $bs);
// hide/show
$this->load->helper('js/div_hide_show');
$displayData['js'] .= showHideDiv();
//--------------------------
// breadcrumbs
//--------------------------
$displayData['pageTitle'] = GSTR_AUCTIONTOPLEVEL . ' | ' . anchor('auctions/auctions/auctionEvents', 'Silent Auctions', 'class="breadcrumb"') . ' | ' . anchor('auctions/bid_templates/main', 'Auction Bid Templates', 'class="breadcrumb"') . ' | View Bid Sheet';
$displayData['title'] = CS_PROGNAME . ' | Bid Sheets';
$displayData['nav'] = $this->mnav_brain_jar->navData();
$displayData['mainTemplate'] = 'auctions/bidsheet_record_view';
$this->load->vars($displayData);
$this->load->view('template');
}
function strBidSheetListDDL($lAuctionID, $lMatchID, $strDDLName, $bAddBlank, &$lNumBidSheets)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$strOut = '<select name="' . $strDDLName . '">' . "\n";
if ($bAddBlank) {
$strOut .= '<option value="-1"> </option>' . "\n";
}
$sqlStr = "SELECT\n abs_lKeyID, abs_lTemplateID, abs_strSheetName\n FROM gifts_auctions_bidsheets\n WHERE NOT abs_bRetired AND abs_lAuctionID={$lAuctionID}\n ORDER BY abs_strSheetName, abs_lKeyID;";
$query = $this->db->query($sqlStr);
$lNumBidSheets = $query->num_rows();
if ($lNumBidSheets > 0) {
foreach ($query->result() as $row) {
$lKeyID = $row->abs_lKeyID;
$lTemplateID = $row->abs_lTemplateID;
strXlateTemplate($lTemplateID, $tInfo);
$strOut .= '<option value="' . $lKeyID . '" ' . ($lMatchID == $lKeyID ? 'selected' : '') . '>' . htmlspecialchars($row->abs_strSheetName . ' (template "' . $tInfo->title . '")') . '</option>' . "\n";
}
}
$strOut .= '</select>' . "\n";
return $strOut;
}
