function RenderRow()
{
global $conn, $Security, $Items;
// Call Row_Rendering event
$Items->Row_Rendering();
// Common render codes for all row types
// ItemID
$Items->ItemID->CellCssStyle = "";
$Items->ItemID->CellCssClass = "";
// MenuID
$Items->MenuID->CellCssStyle = "";
$Items->MenuID->CellCssClass = "";
// ItemName
$Items->ItemName->CellCssStyle = "";
$Items->ItemName->CellCssClass = "";
// Description
$Items->Description->CellCssStyle = "";
$Items->Description->CellCssClass = "";
// Price
$Items->Price->CellCssStyle = "";
$Items->Price->CellCssClass = "";
// Image
$Items->Image->CellCssStyle = "";
$Items->Image->CellCssClass = "";
// Vegetarian
$Items->Vegetarian->CellCssStyle = "";
$Items->Vegetarian->CellCssClass = "";
// Vegetarian_Price
$Items->Vegetarian_Price->CellCssStyle = "";
$Items->Vegetarian_Price->CellCssClass = "";
// Color
$Items->Color->CellCssStyle = "";
$Items->Color->CellCssClass = "";
// Sequence
$Items->Sequence->CellCssStyle = "";
$Items->Sequence->CellCssClass = "";
// PDF
$Items->PDF->CellCssStyle = "";
$Items->PDF->CellCssClass = "";
// Active
$Items->Active->CellCssStyle = "";
$Items->Active->CellCssClass = "";
if ($Items->RowType == EW_ROWTYPE_VIEW) {
// View row
// ItemID
$Items->ItemID->ViewValue = $Items->ItemID->CurrentValue;
$Items->ItemID->CssStyle = "";
$Items->ItemID->CssClass = "";
$Items->ItemID->ViewCustomAttributes = "";
// MenuID
if (strval($Items->MenuID->CurrentValue) != "") {
$sSqlWrk = "SELECT `MenuName` FROM `Menus` WHERE `MenuID` = " . ew_AdjustSql($Items->MenuID->CurrentValue) . "";
$sSqlWrk .= " ORDER BY `MenuName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Items->MenuID->ViewValue = $rswrk->fields('MenuName');
$rswrk->Close();
} else {
$Items->MenuID->ViewValue = $Items->MenuID->CurrentValue;
}
} else {
$Items->MenuID->ViewValue = NULL;
}
$Items->MenuID->CssStyle = "";
$Items->MenuID->CssClass = "";
$Items->MenuID->ViewCustomAttributes = "";
// ItemName
$Items->ItemName->ViewValue = $Items->ItemName->CurrentValue;
$Items->ItemName->CssStyle = "";
$Items->ItemName->CssClass = "";
$Items->ItemName->ViewCustomAttributes = "";
// Description
$Items->Description->ViewValue = ew_TruncateMemo($Items->Description->CurrentValue, 5);
if (!is_null($Items->Description->ViewValue)) {
$Items->Description->ViewValue = str_replace("\n", "<br>", $Items->Description->ViewValue);
}
$Items->Description->CssStyle = "";
$Items->Description->CssClass = "";
$Items->Description->ViewCustomAttributes = "";
// Price
$Items->Price->ViewValue = $Items->Price->CurrentValue;
$Items->Price->ViewValue = ew_FormatCurrency($Items->Price->ViewValue, 2, -2, 0, -2);
$Items->Price->CssStyle = "";
$Items->Price->CssClass = "";
$Items->Price->ViewCustomAttributes = "";
// Image
if (!is_null($Items->Image->Upload->DbValue)) {
$Items->Image->ViewValue = $Items->Image->Upload->DbValue;
$Items->Image->ImageAlt = "";
} else {
$Items->Image->ViewValue = "";
}
$Items->Image->CssStyle = "";
$Items->Image->CssClass = "";
$Items->Image->ViewCustomAttributes = "";
// Vegetarian
if (strval($Items->Vegetarian->CurrentValue) != "") {
switch ($Items->Vegetarian->CurrentValue) {
case "0":
$Items->Vegetarian->ViewValue = "No";
break;
case "1":
$Items->Vegetarian->ViewValue = "Yes";
break;
default:
$Items->Vegetarian->ViewValue = $Items->Vegetarian->CurrentValue;
}
} else {
$Items->Vegetarian->ViewValue = NULL;
}
$Items->Vegetarian->CssStyle = "";
$Items->Vegetarian->CssClass = "";
$Items->Vegetarian->ViewCustomAttributes = "";
// Vegetarian_Price
$Items->Vegetarian_Price->ViewValue = $Items->Vegetarian_Price->CurrentValue;
$Items->Vegetarian_Price->ViewValue = ew_FormatCurrency($Items->Vegetarian_Price->ViewValue, 2, -2, 0, -2);
$Items->Vegetarian_Price->CssStyle = "";
$Items->Vegetarian_Price->CssClass = "";
$Items->Vegetarian_Price->ViewCustomAttributes = "";
// Color
$Items->Color->ViewValue = $Items->Color->CurrentValue;
$Items->Color->CssStyle = "";
$Items->Color->CssClass = "";
$Items->Color->ViewCustomAttributes = "";
// Sequence
$Items->Sequence->ViewValue = $Items->Sequence->CurrentValue;
$Items->Sequence->CssStyle = "";
$Items->Sequence->CssClass = "";
$Items->Sequence->ViewCustomAttributes = "";
// PDF
if (!is_null($Items->PDF->Upload->DbValue)) {
$Items->PDF->ViewValue = $Items->PDF->Upload->DbValue;
} else {
$Items->PDF->ViewValue = "";
}
$Items->PDF->CssStyle = "";
$Items->PDF->CssClass = "";
$Items->PDF->ViewCustomAttributes = "";
// Active
if (strval($Items->Active->CurrentValue) != "") {
switch ($Items->Active->CurrentValue) {
case "0":
$Items->Active->ViewValue = "No";
break;
case "1":
$Items->Active->ViewValue = "Yes";
break;
default:
$Items->Active->ViewValue = $Items->Active->CurrentValue;
}
} else {
$Items->Active->ViewValue = NULL;
}
$Items->Active->CssStyle = "";
$Items->Active->CssClass = "";
$Items->Active->ViewCustomAttributes = "";
// ItemID
$Items->ItemID->HrefValue = "";
// MenuID
$Items->MenuID->HrefValue = "";
// ItemName
$Items->ItemName->HrefValue = "";
// Description
$Items->Description->HrefValue = "";
// Price
$Items->Price->HrefValue = "";
// Image
$Items->Image->HrefValue = "";
// Vegetarian
$Items->Vegetarian->HrefValue = "";
// Vegetarian_Price
$Items->Vegetarian_Price->HrefValue = "";
// Color
$Items->Color->HrefValue = "";
// Sequence
$Items->Sequence->HrefValue = "";
// PDF
if (!is_null($Items->PDF->Upload->DbValue)) {
$Items->PDF->HrefValue = ew_UploadPathEx(FALSE, "../recipes/") . (!empty($Items->PDF->ViewValue) ? $Items->PDF->ViewValue : $Items->PDF->CurrentValue);
if ($Items->Export != "") {
$Items->PDF->HrefValue = ew_ConvertFullUrl($Items->PDF->HrefValue);
}
} else {
$Items->PDF->HrefValue = "";
}
// Active
$Items->Active->HrefValue = "";
}
// Call Row Rendered event
$Items->Row_Rendered();
}
function RenderRow()
{
global $conn, $Security, $Subscriptions2;
// Call Row_Rendering event
$Subscriptions2->Row_Rendering();
// Common render codes for all row types
// DeliveryDate
$Subscriptions2->DeliveryDate->CellCssStyle = "";
$Subscriptions2->DeliveryDate->CellCssClass = "";
// CustomerID
$Subscriptions2->CustomerID->CellCssStyle = "";
$Subscriptions2->CustomerID->CellCssClass = "";
// WeeklyMeals
$Subscriptions2->WeeklyMeals->CellCssStyle = "";
$Subscriptions2->WeeklyMeals->CellCssClass = "";
// WeeklyReg
$Subscriptions2->WeeklyReg->CellCssStyle = "";
$Subscriptions2->WeeklyReg->CellCssClass = "";
// WeeklyVeg
$Subscriptions2->WeeklyVeg->CellCssStyle = "";
$Subscriptions2->WeeklyVeg->CellCssClass = "";
// TransactionNumber
$Subscriptions2->TransactionNumber->CellCssStyle = "";
$Subscriptions2->TransactionNumber->CellCssClass = "";
// Want
$Subscriptions2->Want->CellCssStyle = "";
$Subscriptions2->Want->CellCssClass = "";
// DontWant
$Subscriptions2->DontWant->CellCssStyle = "";
$Subscriptions2->DontWant->CellCssClass = "";
// Comments
$Subscriptions2->Comments->CellCssStyle = "";
$Subscriptions2->Comments->CellCssClass = "";
if ($Subscriptions2->RowType == EW_ROWTYPE_VIEW) {
// View row
// OrderID
$Subscriptions2->OrderID->ViewValue = $Subscriptions2->OrderID->CurrentValue;
$Subscriptions2->OrderID->CssStyle = "";
$Subscriptions2->OrderID->CssClass = "";
$Subscriptions2->OrderID->ViewCustomAttributes = "";
// DeliveryDate
$Subscriptions2->DeliveryDate->ViewValue = $Subscriptions2->DeliveryDate->CurrentValue;
$Subscriptions2->DeliveryDate->ViewValue = ew_FormatDateTime($Subscriptions2->DeliveryDate->ViewValue, 6);
$Subscriptions2->DeliveryDate->CssStyle = "";
$Subscriptions2->DeliveryDate->CssClass = "";
$Subscriptions2->DeliveryDate->ViewCustomAttributes = "";
// CustomerID
if (strval($Subscriptions2->CustomerID->CurrentValue) != "") {
$sSqlWrk = "SELECT `LastName`, `FirstName` FROM `Customers` WHERE `CustomerID` = " . ew_AdjustSql($Subscriptions2->CustomerID->CurrentValue) . "";
$sSqlWrk .= " ORDER BY `LastName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Subscriptions2->CustomerID->ViewValue = $rswrk->fields('LastName');
$Subscriptions2->CustomerID->ViewValue .= ew_ValueSeparator(0) . $rswrk->fields('FirstName');
$rswrk->Close();
} else {
$Subscriptions2->CustomerID->ViewValue = $Subscriptions2->CustomerID->CurrentValue;
}
} else {
$Subscriptions2->CustomerID->ViewValue = NULL;
}
$Subscriptions2->CustomerID->CssStyle = "";
$Subscriptions2->CustomerID->CssClass = "";
$Subscriptions2->CustomerID->ViewCustomAttributes = "";
// WeeklyMeals
$Subscriptions2->WeeklyMeals->ViewValue = $Subscriptions2->WeeklyMeals->CurrentValue;
$Subscriptions2->WeeklyMeals->CssStyle = "";
$Subscriptions2->WeeklyMeals->CssClass = "";
$Subscriptions2->WeeklyMeals->ViewCustomAttributes = "";
// WeeklyReg
$Subscriptions2->WeeklyReg->ViewValue = $Subscriptions2->WeeklyReg->CurrentValue;
$Subscriptions2->WeeklyReg->CssStyle = "";
$Subscriptions2->WeeklyReg->CssClass = "";
$Subscriptions2->WeeklyReg->ViewCustomAttributes = "";
// WeeklyVeg
$Subscriptions2->WeeklyVeg->ViewValue = $Subscriptions2->WeeklyVeg->CurrentValue;
$Subscriptions2->WeeklyVeg->CssStyle = "";
$Subscriptions2->WeeklyVeg->CssClass = "";
$Subscriptions2->WeeklyVeg->ViewCustomAttributes = "";
// PromoCodeID
if (strval($Subscriptions2->PromoCodeID->CurrentValue) != "") {
$sSqlWrk = "SELECT `PromoCodeName` FROM `PromoCodes` WHERE `PromoCodeID` = " . ew_AdjustSql($Subscriptions2->PromoCodeID->CurrentValue) . "";
$sSqlWrk .= " ORDER BY `PromoCodeName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Subscriptions2->PromoCodeID->ViewValue = $rswrk->fields('PromoCodeName');
$rswrk->Close();
} else {
$Subscriptions2->PromoCodeID->ViewValue = $Subscriptions2->PromoCodeID->CurrentValue;
}
} else {
$Subscriptions2->PromoCodeID->ViewValue = NULL;
}
$Subscriptions2->PromoCodeID->CssStyle = "";
$Subscriptions2->PromoCodeID->CssClass = "";
$Subscriptions2->PromoCodeID->ViewCustomAttributes = "";
// TransactionNumber
$Subscriptions2->TransactionNumber->ViewValue = $Subscriptions2->TransactionNumber->CurrentValue;
$Subscriptions2->TransactionNumber->CssStyle = "";
$Subscriptions2->TransactionNumber->CssClass = "";
$Subscriptions2->TransactionNumber->ViewCustomAttributes = "";
// Want
if (strval($Subscriptions2->Want->CurrentValue) != "") {
$arwrk = explode(",", $Subscriptions2->Want->CurrentValue);
$sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE ";
$sWhereWrk = "";
foreach ($arwrk as $wrk) {
if ($sWhereWrk != "") {
$sWhereWrk .= " OR ";
}
$sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . "";
}
if ($sWhereWrk != "") {
$sSqlWrk .= "(" . $sWhereWrk . ")";
}
$sSqlWrk .= " ORDER BY `ItemName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Subscriptions2->Want->ViewValue = "";
$ari = 0;
while (!$rswrk->EOF) {
$Subscriptions2->Want->ViewValue .= $rswrk->fields('ItemName');
$rswrk->MoveNext();
if (!$rswrk->EOF) {
$Subscriptions2->Want->ViewValue .= ew_ViewOptionSeparator($ari);
}
// Separate Options
$ari++;
}
$rswrk->Close();
} else {
$Subscriptions2->Want->ViewValue = $Subscriptions2->Want->CurrentValue;
}
} else {
$Subscriptions2->Want->ViewValue = NULL;
}
$Subscriptions2->Want->CssStyle = "";
$Subscriptions2->Want->CssClass = "";
$Subscriptions2->Want->ViewCustomAttributes = "";
// DontWant
if (strval($Subscriptions2->DontWant->CurrentValue) != "") {
$arwrk = explode(",", $Subscriptions2->DontWant->CurrentValue);
$sSqlWrk = "SELECT `ItemName` FROM `Items` WHERE ";
$sWhereWrk = "";
foreach ($arwrk as $wrk) {
if ($sWhereWrk != "") {
$sWhereWrk .= " OR ";
}
$sWhereWrk .= "`ItemID` = " . ew_AdjustSql(trim($wrk)) . "";
}
if ($sWhereWrk != "") {
$sSqlWrk .= "(" . $sWhereWrk . ")";
}
$sSqlWrk .= " ORDER BY `ItemName` Asc";
$rswrk = $conn->Execute($sSqlWrk);
if ($rswrk && !$rswrk->EOF) {
// Lookup value(s) found
$Subscriptions2->DontWant->ViewValue = "";
$ari = 0;
while (!$rswrk->EOF) {
$Subscriptions2->DontWant->ViewValue .= $rswrk->fields('ItemName');
$rswrk->MoveNext();
if (!$rswrk->EOF) {
$Subscriptions2->DontWant->ViewValue .= ew_ViewOptionSeparator($ari);
}
// Separate Options
$ari++;
}
$rswrk->Close();
} else {
$Subscriptions2->DontWant->ViewValue = $Subscriptions2->DontWant->CurrentValue;
}
} else {
$Subscriptions2->DontWant->ViewValue = NULL;
}
$Subscriptions2->DontWant->CssStyle = "";
$Subscriptions2->DontWant->CssClass = "";
$Subscriptions2->DontWant->ViewCustomAttributes = "";
// Comments
$Subscriptions2->Comments->ViewValue = ew_TruncateMemo($Subscriptions2->Comments->CurrentValue, 500);
$Subscriptions2->Comments->CssStyle = "";
$Subscriptions2->Comments->CssClass = "";
$Subscriptions2->Comments->ViewCustomAttributes = "";
// SubscriptionID
$Subscriptions2->SubscriptionID->ViewValue = $Subscriptions2->SubscriptionID->CurrentValue;
$Subscriptions2->SubscriptionID->CssStyle = "";
$Subscriptions2->SubscriptionID->CssClass = "";
$Subscriptions2->SubscriptionID->ViewCustomAttributes = "";
// DeliveryDate
$Subscriptions2->DeliveryDate->HrefValue = "";
// CustomerID
$Subscriptions2->CustomerID->HrefValue = "";
// WeeklyMeals
$Subscriptions2->WeeklyMeals->HrefValue = "";
// WeeklyReg
$Subscriptions2->WeeklyReg->HrefValue = "";
// WeeklyVeg
$Subscriptions2->WeeklyVeg->HrefValue = "";
// TransactionNumber
$Subscriptions2->TransactionNumber->HrefValue = "";
// Want
$Subscriptions2->Want->HrefValue = "";
// DontWant
$Subscriptions2->DontWant->HrefValue = "";
// Comments
$Subscriptions2->Comments->HrefValue = "";
} elseif ($Subscriptions2->RowType == EW_ROWTYPE_SEARCH) {
// Search row
// DeliveryDate
$Subscriptions2->DeliveryDate->EditCustomAttributes = "";
$Subscriptions2->DeliveryDate->EditValue = ew_HtmlEncode(ew_FormatDateTime(ew_UnFormatDateTime($Subscriptions2->DeliveryDate->AdvancedSearch->SearchValue, 6), 6));
// CustomerID
$Subscriptions2->CustomerID->EditCustomAttributes = "";
// WeeklyMeals
$Subscriptions2->WeeklyMeals->EditCustomAttributes = "";
$Subscriptions2->WeeklyMeals->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyMeals->AdvancedSearch->SearchValue);
// WeeklyReg
$Subscriptions2->WeeklyReg->EditCustomAttributes = "";
$Subscriptions2->WeeklyReg->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyReg->AdvancedSearch->SearchValue);
// WeeklyVeg
$Subscriptions2->WeeklyVeg->EditCustomAttributes = "";
$Subscriptions2->WeeklyVeg->EditValue = ew_HtmlEncode($Subscriptions2->WeeklyVeg->AdvancedSearch->SearchValue);
// TransactionNumber
$Subscriptions2->TransactionNumber->EditCustomAttributes = "";
$Subscriptions2->TransactionNumber->EditValue = ew_HtmlEncode($Subscriptions2->TransactionNumber->AdvancedSearch->SearchValue);
// Want
$Subscriptions2->Want->EditCustomAttributes = "";
// DontWant
$Subscriptions2->DontWant->EditCustomAttributes = "";
// Comments
$Subscriptions2->Comments->EditCustomAttributes = "";
$Subscriptions2->Comments->EditValue = ew_HtmlEncode($Subscriptions2->Comments->AdvancedSearch->SearchValue);
}
// Call Row Rendered event
$Subscriptions2->Row_Rendered();
}
