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; }