예제 #1
0
 function ExportData()
 {
     global $ZipCode;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "v";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     $this->SetUpStartRec();
     // Set up start record position
     // Set the last record to display
     if ($this->lDisplayRecs < 0) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
     }
     if ($ZipCode->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($ZipCode->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $ZipCode->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'ZipCode', $ZipCode->Export);
             ew_ExportAddValue($sExportStr, 'Status', $ZipCode->Export);
             ew_ExportAddValue($sExportStr, 'MonthlyRequest', $ZipCode->Export);
             ew_ExportAddValue($sExportStr, 'MinOrder', $ZipCode->Export);
             ew_ExportAddValue($sExportStr, 'Delivery', $ZipCode->Export);
             ew_ExportAddValue($sExportStr, 'Message', $ZipCode->Export);
             echo ew_ExportLine($sExportStr, $ZipCode->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $ZipCode->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($ZipCode->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('ZipCode', $ZipCode->ZipCode->CurrentValue);
                 $XmlDoc->AddField('Status', $ZipCode->Status->CurrentValue);
                 $XmlDoc->AddField('MonthlyRequest', $ZipCode->MonthlyRequest->CurrentValue);
                 $XmlDoc->AddField('MinOrder', $ZipCode->MinOrder->CurrentValue);
                 $XmlDoc->AddField('Delivery', $ZipCode->Delivery->CurrentValue);
                 $XmlDoc->AddField('Message', $ZipCode->Message->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $ZipCode->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('ZipCode', $ZipCode->ZipCode->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportField('Status', $ZipCode->Status->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportField('MonthlyRequest', $ZipCode->MonthlyRequest->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportField('MinOrder', $ZipCode->MinOrder->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportField('Delivery', $ZipCode->Delivery->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportField('Message', $ZipCode->Message->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $ZipCode->ZipCode->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     ew_ExportAddValue($sExportStr, $ZipCode->Status->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     ew_ExportAddValue($sExportStr, $ZipCode->MonthlyRequest->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     ew_ExportAddValue($sExportStr, $ZipCode->MinOrder->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     ew_ExportAddValue($sExportStr, $ZipCode->Delivery->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     ew_ExportAddValue($sExportStr, $ZipCode->Message->ExportValue($ZipCode->Export, $ZipCode->ExportOriginalValue), $ZipCode->Export);
                     echo ew_ExportLine($sExportStr, $ZipCode->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($ZipCode->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($ZipCode->Export);
     }
 }
예제 #2
0
 function ExportData()
 {
     global $Customers;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "v";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     $this->SetUpStartRec();
     // Set up start record position
     // Set the last record to display
     if ($this->lDisplayRecs < 0) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
     }
     if ($Customers->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($Customers->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $Customers->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'CustomerID', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Email', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Password', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'FirstName', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'LastName', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'ContactPhone', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Allergies', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryAddress1', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryAddress2', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryCity', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryState', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryZip', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryComments', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingFirstName', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingLastName', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingAddress1', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingAddress2', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingCity', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingState', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingZip', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingPhone', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingCardType', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'BillingCardNumber', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'CIMCustID', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'CIMPymtProfID', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Customer_Type', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'First_Order_Date', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Last_Order_Date', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Total_Orders', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Delivery_Window', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'WeeklyMeals', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'WeeklyReg', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'WeeklyVeg', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Want', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'DontWant', $Customers->Export);
             ew_ExportAddValue($sExportStr, 'Comments', $Customers->Export);
             echo ew_ExportLine($sExportStr, $Customers->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $Customers->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($Customers->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('CustomerID', $Customers->CustomerID->CurrentValue);
                 $XmlDoc->AddField('zEmail', $Customers->zEmail->CurrentValue);
                 $XmlDoc->AddField('Password', $Customers->Password->CurrentValue);
                 $XmlDoc->AddField('FirstName', $Customers->FirstName->CurrentValue);
                 $XmlDoc->AddField('LastName', $Customers->LastName->CurrentValue);
                 $XmlDoc->AddField('ContactPhone', $Customers->ContactPhone->CurrentValue);
                 $XmlDoc->AddField('Allergies', $Customers->Allergies->CurrentValue);
                 $XmlDoc->AddField('DeliveryAddress1', $Customers->DeliveryAddress1->CurrentValue);
                 $XmlDoc->AddField('DeliveryAddress2', $Customers->DeliveryAddress2->CurrentValue);
                 $XmlDoc->AddField('DeliveryCity', $Customers->DeliveryCity->CurrentValue);
                 $XmlDoc->AddField('DeliveryState', $Customers->DeliveryState->CurrentValue);
                 $XmlDoc->AddField('DeliveryZip', $Customers->DeliveryZip->CurrentValue);
                 $XmlDoc->AddField('DeliveryComments', $Customers->DeliveryComments->CurrentValue);
                 $XmlDoc->AddField('BillingFirstName', $Customers->BillingFirstName->CurrentValue);
                 $XmlDoc->AddField('BillingLastName', $Customers->BillingLastName->CurrentValue);
                 $XmlDoc->AddField('BillingAddress1', $Customers->BillingAddress1->CurrentValue);
                 $XmlDoc->AddField('BillingAddress2', $Customers->BillingAddress2->CurrentValue);
                 $XmlDoc->AddField('BillingCity', $Customers->BillingCity->CurrentValue);
                 $XmlDoc->AddField('BillingState', $Customers->BillingState->CurrentValue);
                 $XmlDoc->AddField('BillingZip', $Customers->BillingZip->CurrentValue);
                 $XmlDoc->AddField('BillingPhone', $Customers->BillingPhone->CurrentValue);
                 $XmlDoc->AddField('BillingCardType', $Customers->BillingCardType->CurrentValue);
                 $XmlDoc->AddField('BillingCardNumber', $Customers->BillingCardNumber->CurrentValue);
                 $XmlDoc->AddField('CIMCustID', $Customers->CIMCustID->CurrentValue);
                 $XmlDoc->AddField('CIMPymtProfID', $Customers->CIMPymtProfID->CurrentValue);
                 $XmlDoc->AddField('Customer_Type', $Customers->Customer_Type->CurrentValue);
                 $XmlDoc->AddField('First_Order_Date', $Customers->First_Order_Date->CurrentValue);
                 $XmlDoc->AddField('Last_Order_Date', $Customers->Last_Order_Date->CurrentValue);
                 $XmlDoc->AddField('Total_Orders', $Customers->Total_Orders->CurrentValue);
                 $XmlDoc->AddField('Delivery_Window', $Customers->Delivery_Window->CurrentValue);
                 $XmlDoc->AddField('WeeklyMeals', $Customers->WeeklyMeals->CurrentValue);
                 $XmlDoc->AddField('WeeklyReg', $Customers->WeeklyReg->CurrentValue);
                 $XmlDoc->AddField('WeeklyVeg', $Customers->WeeklyVeg->CurrentValue);
                 $XmlDoc->AddField('Want', $Customers->Want->CurrentValue);
                 $XmlDoc->AddField('DontWant', $Customers->DontWant->CurrentValue);
                 $XmlDoc->AddField('Comments', $Customers->Comments->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $Customers->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('CustomerID', $Customers->CustomerID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Email', $Customers->zEmail->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Password', $Customers->Password->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('FirstName', $Customers->FirstName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('LastName', $Customers->LastName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('ContactPhone', $Customers->ContactPhone->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Allergies', $Customers->Allergies->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryAddress1', $Customers->DeliveryAddress1->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryAddress2', $Customers->DeliveryAddress2->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryCity', $Customers->DeliveryCity->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryState', $Customers->DeliveryState->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryZip', $Customers->DeliveryZip->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DeliveryComments', $Customers->DeliveryComments->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingFirstName', $Customers->BillingFirstName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingLastName', $Customers->BillingLastName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingAddress1', $Customers->BillingAddress1->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingAddress2', $Customers->BillingAddress2->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingCity', $Customers->BillingCity->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingState', $Customers->BillingState->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingZip', $Customers->BillingZip->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingPhone', $Customers->BillingPhone->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingCardType', $Customers->BillingCardType->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('BillingCardNumber', $Customers->BillingCardNumber->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('CIMCustID', $Customers->CIMCustID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('CIMPymtProfID', $Customers->CIMPymtProfID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Customer_Type', $Customers->Customer_Type->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('First_Order_Date', $Customers->First_Order_Date->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Last_Order_Date', $Customers->Last_Order_Date->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Total_Orders', $Customers->Total_Orders->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Delivery_Window', $Customers->Delivery_Window->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('WeeklyMeals', $Customers->WeeklyMeals->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('WeeklyReg', $Customers->WeeklyReg->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('WeeklyVeg', $Customers->WeeklyVeg->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Want', $Customers->Want->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('DontWant', $Customers->DontWant->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportField('Comments', $Customers->Comments->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $Customers->CustomerID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->zEmail->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Password->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->FirstName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->LastName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->ContactPhone->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Allergies->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryAddress1->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryAddress2->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryCity->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryState->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryZip->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DeliveryComments->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingFirstName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingLastName->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingAddress1->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingAddress2->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingCity->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingState->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingZip->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingPhone->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingCardType->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->BillingCardNumber->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->CIMCustID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->CIMPymtProfID->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Customer_Type->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->First_Order_Date->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Last_Order_Date->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Total_Orders->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Delivery_Window->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->WeeklyMeals->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->WeeklyReg->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->WeeklyVeg->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Want->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->DontWant->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     ew_ExportAddValue($sExportStr, $Customers->Comments->ExportValue($Customers->Export, $Customers->ExportOriginalValue), $Customers->Export);
                     echo ew_ExportLine($sExportStr, $Customers->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($Customers->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($Customers->Export);
     }
 }
 function ExportData()
 {
     global $ItemIngredients;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "h";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     // Export all
     if ($ItemIngredients->ExportAll) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         // Export 1 page only
         $this->SetUpStartRec();
         // Set up start record position
         // Set the last record to display
         if ($this->lDisplayRecs < 0) {
             $this->lStopRec = $this->lTotalRecs;
         } else {
             $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
         }
     }
     if ($ItemIngredients->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($ItemIngredients->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $ItemIngredients->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'ItemIngredientID', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'ItemID', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'IngredientID', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'Amount', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'Type', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'Letter_Code', $ItemIngredients->Export);
             ew_ExportAddValue($sExportStr, 'Vegetarian', $ItemIngredients->Export);
             echo ew_ExportLine($sExportStr, $ItemIngredients->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $ItemIngredients->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($ItemIngredients->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('ItemIngredientID', $ItemIngredients->ItemIngredientID->CurrentValue);
                 $XmlDoc->AddField('ItemID', $ItemIngredients->ItemID->CurrentValue);
                 $XmlDoc->AddField('IngredientID', $ItemIngredients->IngredientID->CurrentValue);
                 $XmlDoc->AddField('Amount', $ItemIngredients->Amount->CurrentValue);
                 $XmlDoc->AddField('Type', $ItemIngredients->Type->CurrentValue);
                 $XmlDoc->AddField('Letter_Code', $ItemIngredients->Letter_Code->CurrentValue);
                 $XmlDoc->AddField('Vegetarian', $ItemIngredients->Vegetarian->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $ItemIngredients->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('ItemIngredientID', $ItemIngredients->ItemIngredientID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('ItemID', $ItemIngredients->ItemID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('IngredientID', $ItemIngredients->IngredientID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('Amount', $ItemIngredients->Amount->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('Type', $ItemIngredients->Type->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('Letter_Code', $ItemIngredients->Letter_Code->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportField('Vegetarian', $ItemIngredients->Vegetarian->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $ItemIngredients->ItemIngredientID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->ItemID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->IngredientID->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->Amount->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->Type->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->Letter_Code->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     ew_ExportAddValue($sExportStr, $ItemIngredients->Vegetarian->ExportValue($ItemIngredients->Export, $ItemIngredients->ExportOriginalValue), $ItemIngredients->Export);
                     echo ew_ExportLine($sExportStr, $ItemIngredients->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($ItemIngredients->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($ItemIngredients->Export);
     }
 }
예제 #4
0
 function ExportData()
 {
     global $Orders;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "h";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     // Export all
     if ($Orders->ExportAll) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         // Export 1 page only
         $this->SetUpStartRec();
         // Set up start record position
         // Set the last record to display
         if ($this->lDisplayRecs < 0) {
             $this->lStopRec = $this->lTotalRecs;
         } else {
             $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
         }
     }
     if ($Orders->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($Orders->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $Orders->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'OrderID', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'CustomerID', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'TransactionNumber', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'DateOrdered', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'Total', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'DeliveryDate', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'PromoCodeID', $Orders->Export);
             ew_ExportAddValue($sExportStr, 'Sequence', $Orders->Export);
             echo ew_ExportLine($sExportStr, $Orders->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $Orders->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($Orders->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('OrderID', $Orders->OrderID->CurrentValue);
                 $XmlDoc->AddField('CustomerID', $Orders->CustomerID->CurrentValue);
                 $XmlDoc->AddField('TransactionNumber', $Orders->TransactionNumber->CurrentValue);
                 $XmlDoc->AddField('DateOrdered', $Orders->DateOrdered->CurrentValue);
                 $XmlDoc->AddField('Total', $Orders->Total->CurrentValue);
                 $XmlDoc->AddField('DeliveryDate', $Orders->DeliveryDate->CurrentValue);
                 $XmlDoc->AddField('PromoCodeID', $Orders->PromoCodeID->CurrentValue);
                 $XmlDoc->AddField('Sequence', $Orders->Sequence->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $Orders->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('OrderID', $Orders->OrderID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('CustomerID', $Orders->CustomerID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('TransactionNumber', $Orders->TransactionNumber->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('DateOrdered', $Orders->DateOrdered->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('Total', $Orders->Total->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('DeliveryDate', $Orders->DeliveryDate->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('PromoCodeID', $Orders->PromoCodeID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportField('Sequence', $Orders->Sequence->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $Orders->OrderID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->CustomerID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->TransactionNumber->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->DateOrdered->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->Total->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->DeliveryDate->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->PromoCodeID->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     ew_ExportAddValue($sExportStr, $Orders->Sequence->ExportValue($Orders->Export, $Orders->ExportOriginalValue), $Orders->Export);
                     echo ew_ExportLine($sExportStr, $Orders->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($Orders->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($Orders->Export);
     }
 }
예제 #5
0
 function ExportData()
 {
     global $ItemDetails;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "v";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     $this->SetUpStartRec();
     // Set up start record position
     // Set the last record to display
     if ($this->lDisplayRecs < 0) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
     }
     if ($ItemDetails->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($ItemDetails->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $ItemDetails->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'ItemID', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Time_to_Table', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Level_Of_Difficulty', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Beverage_Pairing', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Vegetarian_Subsitution', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Calories', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Other', $ItemDetails->Export);
             ew_ExportAddValue($sExportStr, 'Image', $ItemDetails->Export);
             echo ew_ExportLine($sExportStr, $ItemDetails->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $ItemDetails->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($ItemDetails->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('ItemID', $ItemDetails->ItemID->CurrentValue);
                 $XmlDoc->AddField('Time_to_Table', $ItemDetails->Time_to_Table->CurrentValue);
                 $XmlDoc->AddField('Level_Of_Difficulty', $ItemDetails->Level_Of_Difficulty->CurrentValue);
                 $XmlDoc->AddField('Beverage_Pairing', $ItemDetails->Beverage_Pairing->CurrentValue);
                 $XmlDoc->AddField('Vegetarian_Subsitution', $ItemDetails->Vegetarian_Subsitution->CurrentValue);
                 $XmlDoc->AddField('Calories', $ItemDetails->Calories->CurrentValue);
                 $XmlDoc->AddField('Other', $ItemDetails->Other->CurrentValue);
                 $XmlDoc->AddField('Image', $ItemDetails->Image->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $ItemDetails->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('ItemID', $ItemDetails->ItemID->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Time_to_Table', $ItemDetails->Time_to_Table->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Level_Of_Difficulty', $ItemDetails->Level_Of_Difficulty->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Beverage_Pairing', $ItemDetails->Beverage_Pairing->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Vegetarian_Subsitution', $ItemDetails->Vegetarian_Subsitution->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Calories', $ItemDetails->Calories->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Other', $ItemDetails->Other->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportField('Image', $ItemDetails->Image->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $ItemDetails->ItemID->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Time_to_Table->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Level_Of_Difficulty->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Beverage_Pairing->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Vegetarian_Subsitution->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Calories->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Other->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     ew_ExportAddValue($sExportStr, $ItemDetails->Image->ExportValue($ItemDetails->Export, $ItemDetails->ExportOriginalValue), $ItemDetails->Export);
                     echo ew_ExportLine($sExportStr, $ItemDetails->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($ItemDetails->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($ItemDetails->Export);
     }
 }
 function ExportData()
 {
     global $GiftCertificates;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "h";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     // Export all
     if ($GiftCertificates->ExportAll) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         // Export 1 page only
         $this->SetUpStartRec();
         // Set up start record position
         // Set the last record to display
         if ($this->lDisplayRecs < 0) {
             $this->lStopRec = $this->lTotalRecs;
         } else {
             $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
         }
     }
     if ($GiftCertificates->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($GiftCertificates->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $GiftCertificates->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'GiftCertificateID', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'CustomerID', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftEmail', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftPhone', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftFirstName', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftLastName', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftAmount', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftMessage', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendMethod', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendAddress1', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendAddress2', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendCity', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendState', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendZip', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'GiftSendEmail', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'PromoCodeID', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'DateMailed', $GiftCertificates->Export);
             ew_ExportAddValue($sExportStr, 'Redeemed', $GiftCertificates->Export);
             echo ew_ExportLine($sExportStr, $GiftCertificates->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $GiftCertificates->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($GiftCertificates->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('GiftCertificateID', $GiftCertificates->GiftCertificateID->CurrentValue);
                 $XmlDoc->AddField('CustomerID', $GiftCertificates->CustomerID->CurrentValue);
                 $XmlDoc->AddField('GiftEmail', $GiftCertificates->GiftEmail->CurrentValue);
                 $XmlDoc->AddField('GiftPhone', $GiftCertificates->GiftPhone->CurrentValue);
                 $XmlDoc->AddField('GiftFirstName', $GiftCertificates->GiftFirstName->CurrentValue);
                 $XmlDoc->AddField('GiftLastName', $GiftCertificates->GiftLastName->CurrentValue);
                 $XmlDoc->AddField('GiftAmount', $GiftCertificates->GiftAmount->CurrentValue);
                 $XmlDoc->AddField('GiftMessage', $GiftCertificates->GiftMessage->CurrentValue);
                 $XmlDoc->AddField('GiftSendMethod', $GiftCertificates->GiftSendMethod->CurrentValue);
                 $XmlDoc->AddField('GiftSendAddress1', $GiftCertificates->GiftSendAddress1->CurrentValue);
                 $XmlDoc->AddField('GiftSendAddress2', $GiftCertificates->GiftSendAddress2->CurrentValue);
                 $XmlDoc->AddField('GiftSendCity', $GiftCertificates->GiftSendCity->CurrentValue);
                 $XmlDoc->AddField('GiftSendState', $GiftCertificates->GiftSendState->CurrentValue);
                 $XmlDoc->AddField('GiftSendZip', $GiftCertificates->GiftSendZip->CurrentValue);
                 $XmlDoc->AddField('GiftSendEmail', $GiftCertificates->GiftSendEmail->CurrentValue);
                 $XmlDoc->AddField('PromoCodeID', $GiftCertificates->PromoCodeID->CurrentValue);
                 $XmlDoc->AddField('DateMailed', $GiftCertificates->DateMailed->CurrentValue);
                 $XmlDoc->AddField('Redeemed', $GiftCertificates->Redeemed->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $GiftCertificates->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('GiftCertificateID', $GiftCertificates->GiftCertificateID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('CustomerID', $GiftCertificates->CustomerID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftEmail', $GiftCertificates->GiftEmail->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftPhone', $GiftCertificates->GiftPhone->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftFirstName', $GiftCertificates->GiftFirstName->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftLastName', $GiftCertificates->GiftLastName->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftAmount', $GiftCertificates->GiftAmount->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftMessage', $GiftCertificates->GiftMessage->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendMethod', $GiftCertificates->GiftSendMethod->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendAddress1', $GiftCertificates->GiftSendAddress1->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendAddress2', $GiftCertificates->GiftSendAddress2->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendCity', $GiftCertificates->GiftSendCity->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendState', $GiftCertificates->GiftSendState->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendZip', $GiftCertificates->GiftSendZip->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('GiftSendEmail', $GiftCertificates->GiftSendEmail->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('PromoCodeID', $GiftCertificates->PromoCodeID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('DateMailed', $GiftCertificates->DateMailed->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportField('Redeemed', $GiftCertificates->Redeemed->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftCertificateID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->CustomerID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftEmail->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftPhone->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftFirstName->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftLastName->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftAmount->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftMessage->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendMethod->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendAddress1->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendAddress2->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendCity->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendState->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendZip->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->GiftSendEmail->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->PromoCodeID->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->DateMailed->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     ew_ExportAddValue($sExportStr, $GiftCertificates->Redeemed->ExportValue($GiftCertificates->Export, $GiftCertificates->ExportOriginalValue), $GiftCertificates->Export);
                     echo ew_ExportLine($sExportStr, $GiftCertificates->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($GiftCertificates->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($GiftCertificates->Export);
     }
 }
 function ExportData()
 {
     global $password_reset_requests;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "v";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     $this->SetUpStartRec();
     // Set up start record position
     // Set the last record to display
     if ($this->lDisplayRecs < 0) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
     }
     if ($password_reset_requests->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($password_reset_requests->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $password_reset_requests->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'id', $password_reset_requests->Export);
             ew_ExportAddValue($sExportStr, 'CustomerID', $password_reset_requests->Export);
             ew_ExportAddValue($sExportStr, 'token_id', $password_reset_requests->Export);
             ew_ExportAddValue($sExportStr, 'expires', $password_reset_requests->Export);
             echo ew_ExportLine($sExportStr, $password_reset_requests->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $password_reset_requests->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($password_reset_requests->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('id', $password_reset_requests->id->CurrentValue);
                 $XmlDoc->AddField('CustomerID', $password_reset_requests->CustomerID->CurrentValue);
                 $XmlDoc->AddField('token_id', $password_reset_requests->token_id->CurrentValue);
                 $XmlDoc->AddField('expires', $password_reset_requests->expires->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $password_reset_requests->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('id', $password_reset_requests->id->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     echo ew_ExportField('CustomerID', $password_reset_requests->CustomerID->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     echo ew_ExportField('token_id', $password_reset_requests->token_id->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     echo ew_ExportField('expires', $password_reset_requests->expires->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $password_reset_requests->id->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     ew_ExportAddValue($sExportStr, $password_reset_requests->CustomerID->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     ew_ExportAddValue($sExportStr, $password_reset_requests->token_id->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     ew_ExportAddValue($sExportStr, $password_reset_requests->expires->ExportValue($password_reset_requests->Export, $password_reset_requests->ExportOriginalValue), $password_reset_requests->Export);
                     echo ew_ExportLine($sExportStr, $password_reset_requests->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($password_reset_requests->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($password_reset_requests->Export);
     }
 }
예제 #8
0
 function ExportData()
 {
     global $PromoCodes;
     $sCsvStr = "";
     // Default export style
     $sExportStyle = "h";
     // Load recordset
     $rs = $this->LoadRecordset();
     $this->lTotalRecs = $rs->RecordCount();
     $this->lStartRec = 1;
     // Export all
     if ($PromoCodes->ExportAll) {
         $this->lStopRec = $this->lTotalRecs;
     } else {
         // Export 1 page only
         $this->SetUpStartRec();
         // Set up start record position
         // Set the last record to display
         if ($this->lDisplayRecs < 0) {
             $this->lStopRec = $this->lTotalRecs;
         } else {
             $this->lStopRec = $this->lStartRec + $this->lDisplayRecs - 1;
         }
     }
     if ($PromoCodes->Export == "xml") {
         $XmlDoc = new cXMLDocument();
     } else {
         echo "";
         echo ew_ExportHeader($PromoCodes->Export);
         // Horizontal format, write header
         if ($sExportStyle != "v" || $PromoCodes->Export == "csv") {
             $sExportStr = "";
             ew_ExportAddValue($sExportStr, 'PromoCodeID', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'PromoCodeName', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'PromoCodeType', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'Amount', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'ValidFrom', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'ValidTo', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'Message', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'One_Time_Only', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'New_Customer_Only', $PromoCodes->Export);
             ew_ExportAddValue($sExportStr, 'multiple_use', $PromoCodes->Export);
             echo ew_ExportLine($sExportStr, $PromoCodes->Export);
         }
     }
     // Move to first record
     $this->lRecCnt = $this->lStartRec - 1;
     if (!$rs->EOF) {
         $rs->MoveFirst();
         $rs->Move($this->lStartRec - 1);
     }
     while (!$rs->EOF && $this->lRecCnt < $this->lStopRec) {
         $this->lRecCnt++;
         if (intval($this->lRecCnt) >= intval($this->lStartRec)) {
             $this->LoadRowValues($rs);
             // Render row for display
             $PromoCodes->RowType = EW_ROWTYPE_VIEW;
             // Render view
             $this->RenderRow();
             if ($PromoCodes->Export == "xml") {
                 $XmlDoc->BeginRow();
                 $XmlDoc->AddField('PromoCodeID', $PromoCodes->PromoCodeID->CurrentValue);
                 $XmlDoc->AddField('PromoCodeName', $PromoCodes->PromoCodeName->CurrentValue);
                 $XmlDoc->AddField('PromoCodeType', $PromoCodes->PromoCodeType->CurrentValue);
                 $XmlDoc->AddField('Amount', $PromoCodes->Amount->CurrentValue);
                 $XmlDoc->AddField('ValidFrom', $PromoCodes->ValidFrom->CurrentValue);
                 $XmlDoc->AddField('ValidTo', $PromoCodes->ValidTo->CurrentValue);
                 $XmlDoc->AddField('Message', $PromoCodes->Message->CurrentValue);
                 $XmlDoc->AddField('One_Time_Only', $PromoCodes->One_Time_Only->CurrentValue);
                 $XmlDoc->AddField('New_Customer_Only', $PromoCodes->New_Customer_Only->CurrentValue);
                 $XmlDoc->AddField('multiple_use', $PromoCodes->multiple_use->CurrentValue);
                 $XmlDoc->EndRow();
             } else {
                 if ($sExportStyle == "v" && $PromoCodes->Export != "csv") {
                     // Vertical format
                     echo ew_ExportField('PromoCodeID', $PromoCodes->PromoCodeID->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('PromoCodeName', $PromoCodes->PromoCodeName->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('PromoCodeType', $PromoCodes->PromoCodeType->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('Amount', $PromoCodes->Amount->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('ValidFrom', $PromoCodes->ValidFrom->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('ValidTo', $PromoCodes->ValidTo->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('Message', $PromoCodes->Message->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('One_Time_Only', $PromoCodes->One_Time_Only->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('New_Customer_Only', $PromoCodes->New_Customer_Only->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportField('multiple_use', $PromoCodes->multiple_use->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                 } else {
                     // Horizontal format
                     $sExportStr = "";
                     ew_ExportAddValue($sExportStr, $PromoCodes->PromoCodeID->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->PromoCodeName->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->PromoCodeType->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->Amount->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->ValidFrom->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->ValidTo->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->Message->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->One_Time_Only->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->New_Customer_Only->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     ew_ExportAddValue($sExportStr, $PromoCodes->multiple_use->ExportValue($PromoCodes->Export, $PromoCodes->ExportOriginalValue), $PromoCodes->Export);
                     echo ew_ExportLine($sExportStr, $PromoCodes->Export);
                 }
             }
         }
         $rs->MoveNext();
     }
     // Close recordset
     $rs->Close();
     if ($PromoCodes->Export == "xml") {
         header("Content-Type: text/xml");
         echo $XmlDoc->XML();
     } else {
         echo ew_ExportFooter($PromoCodes->Export);
     }
 }