/**
* PointChannels::Load()
*
* @param mixed $userId
* @param mixed $domainId
* @return
*/
function Load($userId, $domainId, $pointType = '', $participationType = '', $siftByResource = false, $rapMonth = false, $rapYear = false)
{
//echo "In PointChannels->Load(...)...<br>\n";
$participationTypeClause = $participationType != '' ? " and pat.ParticipationTypeID = {$participationType} " : '';
$pointTypeClause = $pointType != '' ? " and ptypes.PointTypeName = '{$pointType}' " : " and not ptypes.PointTypeName = 'Resource' ";
$resourceSort = $siftByResource ? " rappc.ChannelDescription, " : '';
$resourceClause = $siftByResource ? " and rap.AssetObjectID = pc.ObjectID\n and rap.AssetChannelID = pc.ChannelID\n and rap.ResourceObjectID = rappc.ObjectID \n " : '';
$resourceTable = $siftByResource ? ", mdr.t_resourceassetprofiles rap, mdr.t_pointchannels rappc " : '';
$resourceFields = $siftByResource ? ", rappc.ChannelDescription ResourceDescription, rap.AssetObjectID, rap.AssetChannelID, rap.ResourceObjectID " : '';
$rapDateClause = $rapMonth ? " and rap.EffectiveMonth = '{$rapMonth}' and rap.EffectiveYear = '{$rapYear}'" : '';
//print $rapDateClause;
$this->p_userId = $userId;
$this->p_domainId = $domainId;
$sql = "\n SELECT DISTINCT\n pc.*,\n pn.ReadTimeOffset,\n pn.ReadInterval,\n t.TimeZoneID,\n t.TimeZoneName,\n t.TimeZoneDescription,\n t.IsDstActive,\n t.StdAbbreviation,\n t.StdDescription,\n t.StdOffset,\n t.StdMonth,\n t.StdWeek,\n t.StdDay,\n t.StdHour,\n t.DstAbbreviation,\n t.DstDescription,\n t.DstOffset,\n t.DstMonth,\n t.DstWeek,\n t.DstDay,\n t.DstHour,\n zo.ObjectDescription Zone,\n pat.ParticipationTypeID,\n pat.ParticipationTypeDescription,\n pcppp.CommittedReduction,\n rp.PriceID RealTimePriceID,\n rp.PriceDescription RealTimePriceDescription,\n hp.PriceID HourlyPriceID,\n hp.PriceDescription HourlyPriceDescription {$resourceFields}\n FROM\n mdr.t_objectxrefs dgox,\n mdr.t_objecttypes got,\n mdr.t_objects go,\n mdr.t_objectxrefs ugox,\n mdr.t_actorprivilegexrefs gpx,\n mdr.t_actorprivilegexrefs dpx,\n mdr.t_privileges p,\n mdr.t_privilegetypes pt,\n mdr.t_points pn,\n mdr.t_timezones t,\n mdr.t_objects po,\n mdr.t_pointchannels pc,\n mdr.t_objectxrefs pzox,\n mdr.t_objects zo,\n mdr.t_zones z,\n mdr.t_pointchannelprogramparticipationprofiles pcppp,\n mdr.t_participationtypes pat,\n mdr.t_pricelocations pl,\n mdr.t_pricecomponents pco,\n mdr.t_pricetypes rpt,\n mdr.t_pricetypes hpt,\n mdr.t_prices rp,\n mdr.t_prices hp,\n mdr.t_pointtypes ptypes {$resourceTable}\n WHERE\n got.ObjectTypeName = 'Group' and\n go.ObjectTypeID = got.ObjectTypeID and\n dgox.ChildObjectID = go.ObjectID and\n dgox.ParentObjectID = {$this->p_domainId} and\n ugox.ParentObjectID = dgox.ChildObjectID and\n ugox.ChildObjectID = {$this->p_userId} and\n gpx.ObjectID = ugox.ParentObjectID and\n dpx.ObjectID = dgox.ParentObjectID and\n gpx.PrivilegeID = dpx.PrivilegeID and\n p.PrivilegeID = gpx.PrivilegeID and\n pt.PrivilegeTypeID = p.PrivilegeTypeID and\n pt.PrivilegeTypeName = 'Read' and\n po.ObjectID = p.ObjectID and\n pn.ObjectID = po.ObjectID and\n t.TimeZoneID = pn.TimeZoneID and\n po.IsInactive = 0 and\n pn.IsEnabled = 1 and\n pc.ObjectID = pn.ObjectID and\n pc.IsEnabled = 1 and\n pc.IsPlotable = 1 and\n pzox.ChildObjectID = pn.ObjectID and\n zo.ObjectID = pzox.ParentObjectID and\n z.ObjectID = zo.ObjectID and\n pcppp.PointObjectID = p.ObjectID and\n pat.ParticipationTypeID = pcppp.ParticipationTypeID and\n pco.PriceComponentName = 'LBMP' and\n pl.ZoneObjectID = z.ObjectID and\n rpt.PriceTypeName = 'RealTimePrice' and\n rp.PriceTypeID = rpt.PriceTypeID and\n rp.PriceLocationID = pl.PriceLocationID and\n rp.PriceComponentID = pco.PriceComponentID and\n hpt.PriceTypeName = 'HourlyPrice' and\n hp.PriceTypeID = hpt.PriceTypeID and\n hp.PriceLocationID = pl.PriceLocationID and\n hp.PriceComponentID = pco.PriceComponentID and\n ptypes.PointTypeID = pn.PointTypeID {$participationTypeClause} {$resourceClause} {$pointTypeClause} {$rapDateClause} \n ORDER BY\n {$resourceSort}\n pc.ChannelDescription\n ";
//$this->preDebugger($sql);
$result = mysql_query($sql, $this->sqlConnection());
//echo mysql_num_rows($result);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
//$this->preDebugger($row);
if ($siftByResource) {
$this->p_resources[$row['ResourceObjectID']]['description'] = $row['ResourceDescription'];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['id'] = $row["ObjectID"];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['channelId'] = $row["ChannelID"];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['description'] = $row["ChannelDescription"];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['programId'] = $row["ParticipationTypeID"];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['programDescription'] = $row["ParticipationTypeDescription"];
$this->p_resources[$row['ResourceObjectID']]['assets'][$row["AssetObjectID"] . ':' . $row["AssetChannelID"]]['assetIdentifier'] = $row["AssetIdentifier"];
} else {
$inx = $this->p_length++;
//inx has no meaning in the new context -- just using it to hold things together right now.
$uom = new UnitOfMeasure();
$uom->Load($row["UnitOfMeasureID"]);
$dluom = new UnitOfMeasure();
$dluom->Load($row["DrawLimitUnitOfMeasureID"]);
$pointChannel = new PointChannel($row["ObjectID"], $row["ChannelID"], $row["ChannelName"], $row["ChannelDescription"], $uom, $row["PulseConversionFactor"], $row["DrawLimit"], $dluom, $row["IsGenerator"], $row["AssetIdentifier"]);
$this->p_pointChannel[$inx] = clone $pointChannel;
$this->p_pcMap[$pointChannel->objectId()][$pointChannel->channelId()] = $inx;
//$this->preDebugger($pointChannel);
/*
print '<pre style="color: red;">';
echo "pointChannel='" . $this->p_pointChannel[$inx]->objectId() . "', '" . $this->p_pointChannel[$inx]->channelId() . "'<br>\n";
echo "index='" . $this->p_pcMap[$pointChannel->objectId()][$pointChannel->channelId()] . "'<br>\n";
print '</pre>';
*/
if (!isset($this->p_meterPoint[$pointChannel->objectId()])) {
$this->p_meterPoint[$pointChannel->objectId()] = new MeterPoint();
$this->p_meterPoint[$pointChannel->objectId()]->id($pointChannel->objectId());
$this->p_meterPoint[$pointChannel->objectId()]->readTimeOffset($row["ReadTimeOffset"]);
$this->p_meterPoint[$pointChannel->objectId()]->readInterval($row["ReadInterval"]);
$this->p_meterPoint[$pointChannel->objectId()]->zone($row["Zone"]);
$this->p_meterPoint[$pointChannel->objectId()]->committedReduction($row["CommittedReduction"]);
$this->p_meterPoint[$pointChannel->objectId()]->participationTypeID($row["ParticipationTypeID"]);
$this->p_meterPoint[$pointChannel->objectId()]->participationTypeDescription($row["ParticipationTypeDescription"]);
$this->p_meterPoint[$pointChannel->objectId()]->displayPriceId($row["RealTimePriceID"]);
$this->p_meterPoint[$pointChannel->objectId()]->displayPriceDescription($row["RealTimePriceDescription"]);
$this->p_meterPoint[$pointChannel->objectId()]->settlementPriceId($row["HourlyPriceID"]);
$this->p_meterPoint[$pointChannel->objectId()]->settlementPriceDescription($row["HourlyPriceDescription"]);
$this->p_participationTypeList[$row["ParticipationTypeID"]] = $row["ParticipationTypeDescription"];
$timeZone = new TimeZone();
$timeZone->id($row["TimeZoneID"]);
$timeZone->name($row["TimeZoneName"]);
$timeZone->description($row["TimeZoneDescription"]);
$timeZone->isDstActive($row["IsDstActive"]);
$timeZone->stdAbbreviation($row["StdAbbreviation"]);
$timeZone->stdDescription($row["StdDescription"]);
$timeZone->stdOffset($row["StdOffset"]);
$timeZone->stdMonth($row["StdMonth"]);
$timeZone->stdWeek($row["StdWeek"]);
$timeZone->stdDay($row["StdDay"]);
$timeZone->stdHour($row["StdHour"]);
$timeZone->dstAbbreviation($row["DstAbbreviation"]);
$timeZone->dstDescription($row["DstDescription"]);
$timeZone->dstOffset($row["DstOffset"]);
$timeZone->dstMonth($row["DstMonth"]);
$timeZone->dstWeek($row["DstWeek"]);
$timeZone->dstDay($row["DstDay"]);
$timeZone->dstHour($row["DstHour"]);
$this->p_meterPoint[$pointChannel->objectId()]->timeZone($timeZone);
}
$this->p_pointChannel[$inx]->meterPoint($this->p_meterPoint[$pointChannel->objectId()]);
}
//print_r($this->p_resource);
}
// end while
} else {
$this->p_resources = false;
}
//end if
}