function refresh()
{
$p_maximumValue = 0;
$sql = '
SELECT
IsoneDayAheadBidID,
i.AssetIdentifier,
ObjectName,
StartDay,
StopDay,
MW,
OfferPrice,
CurtailmentInitiationPrice,
MinimumInterruptionDuration,
IsSent,
i.CreatedBy,
i.CreatedDate,
i.UpdatedBy,
i.UpdatedDate
FROM
t_isonedayaheadbids i,
t_pointchannels pc,
t_objects o
WHERE
pc.AssetIdentifier = i.AssetIdentifier and
o.ObjectID = pc.ObjectID
order by
StartDay,
StopDay
';
$result = $this->processQuery($sql, $this->sqlConnection(), 'select');
//$this->preDebugger($result);
if ($result['error'] != null) {
$this->p_bidList['error'] = true;
} else {
if ($result['records'] > 0) {
$this->p_size = 0;
foreach ($result['items'] as $inx => $bidItem) {
if ($this->p_oUser->HasPrivilege("Read." . $bidItem->ObjectName)) {
$updatedBy = $bidItem->UpdatedBy == null ? 0 : $bidItem->UpdatedBy;
$updateDate = $bidItem->UpdatedDate == null ? 0 : $bidItem->UpdatedDate;
$oBid = new IsoneDayAheadBid();
$oBid->load($bidItem->IsoneDayAheadBidID, $bidItem->AssetIdentifier, $bidItem->StartDay, $bidItem->StopDay, $bidItem->MW, $bidItem->OfferPrice, $bidItem->CurtailmentInitiationPrice, $bidItem->MinimumInterruptionDuration, $bidItem->IsSent, $bidItem->CreatedBy, $bidItem->CreatedDate, $updatedBy, $updatedDate);
$this->p_bidList[$this->p_size] = $oBid;
$this->p_size++;
}
}
}
}
}
function dayAheadBidsAccept($Loader, $User, $post)
{
$Loader->includeIsoneDayAheadBids();
$Bid = new IsoneDayAheadBid();
$startDayParts = explode('-', $post['dayAheadStart']);
$stopDayParts = explode('-', $post['dayAheadStop']);
$Bid->load(0, $post['assetIdentifier'], $startDayParts[2] . '-' . $startDayParts[0] . '-' . $startDayParts[1], $stopDayParts[2] . '-' . $stopDayParts[0] . '-' . $stopDayParts[1], $post['dayAheadMW'], $post['dayAheadOfferPrice'], $post['dayAheadCurtailmentPrice'], $post['dayAheadInterruptionDuration'], 0, $User->id(), 0, 0, 0);
if ($Bid->save()) {
$pcIdentifier = explode(':', $post['dayAheadPoint']);
$result = '<div class="error" style="width: 700px;">The bid was successfully submitted.</div>';
if (!($bidList = initBidList($Loader, $User, $pcIdentifier[0], $pcIdentifier[1]))) {
return '<div class="error" style="width: 700px;">We were unable to process your request. Please try again. If the problem persists, please contact the <a href="http://help.crsolutions.us/">Help Desk</a>.</div>';
}
if (strlen($bidList) > 1) {
$result .= $bidList;
}
$result .= '</form>
</table>
</div>';
return $result;
} else {
return '<div class="error" style="width: 700px;">We were unable to process your request. Please try again. If the problem persists, please contact the <a href="http://help.crsolutions.us/">Help Desk</a>.</div>';
}
}
