/// <summary> /// Formato para el reporte Guest Manifest Range de Host y Processor General /// </summary> /// <history> /// [edgrodriguez] 13/Jun/2016 Created /// </history> public static ColumnFormatList RptManifestRangeByLs_Bookings() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("guloInvit", "guloInvit", isVisible: false); lst.Add("LocationN", "LocationN", axis: ePivotFieldAxis.Row); lst.Add("guBookT", "guBookT", axis: ePivotFieldAxis.Column, sort: eSortType.Ascending); lst.Add("guBookTime", "guBookTime", axis: ePivotFieldAxis.Values); lst.Add("Bookings", "Bookings", EnumFormatTypeExcel.Number, axis: ePivotFieldAxis.Values); return(lst); }
/// <summary> /// Formato para el reporte Exchange Rates Log /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 08/Jul/2016 Created /// </history> public static ColumnFormatList RptExchangeRatesLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("By", "elChangedBy"); lst.Add("Name", "ChangedByN"); lst.Add("Update Date/Time", "elID", format: EnumFormatTypeExcel.DateTime); lst.Add("Currency", "elcu"); lst.Add("Exch. Rate", "elExchangeRate", format: EnumFormatTypeExcel.DecimalNumber); return(lst); }
/// <summary> /// Formato para el reporte Gifts Receipts Log /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 08/Jun/2016 Created /// </history> public static ColumnFormatList RptCloseSalesRoomLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("By", "sqChangedBy"); lst.Add("Name", "ChangedByN"); lst.Add("Update Date/Time", "sqID", format: EnumFormatTypeExcel.DateTime); lst.Add("Shows Close D", "sqShowsCloseD", format: EnumFormatTypeExcel.Date); lst.Add("Meal T Close D", "sqMealTicketsCloseD", format: EnumFormatTypeExcel.Date); lst.Add("Sales Close D", "sqSalesCloseD", format: EnumFormatTypeExcel.Date); lst.Add("Gifts Rcpt Close D", "sqGiftsRcptCloseD", format: EnumFormatTypeExcel.Date); lst.Add("CxC Close D", "sqCxCCloseD", format: EnumFormatTypeExcel.Date); return(lst); }
/// <summary> /// Formato para el reporte de Guest Movements /// </summary> /// <history> /// [jorcanche] created 07072016 /// </history> public static ColumnFormatList RptGuestMovements() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("By", "gmpe"); lst.Add("Name", "peN"); lst.Add("Date/Time", "gmDT"); lst.Add("Movement", "gnN"); lst.Add("Computer", "gmcp"); lst.Add("Computer name", "cpN"); lst.Add("IP Address", "gmIpAddress"); return(lst); }
/// <summary> /// Formato para el reporte Up List Start o Up List End /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 21/Jun/2016 Created /// [edgrodriguez] 05/09/2016 Modified. Se cambio el formato. /// </history> public static ColumnFormatList RptUpList() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Post Name", "SalesmanPostN", isGroup: true, isVisible: false); lst.Add("ID", "Salesman", axis: ePivotFieldAxis.Row); lst.Add("Salesman Name", "SalesmanN", axis: ePivotFieldAxis.Row); lst.Add("Off", "DayOffList", axis: ePivotFieldAxis.Row); lst.Add("Lang", "Language", axis: ePivotFieldAxis.Values); lst.Add("Location", "Location", axis: ePivotFieldAxis.Values); lst.Add("Time", "Time", format: EnumFormatTypeExcel.Time, axis: ePivotFieldAxis.Values); lst.Add("TimeN", "TimeN", format: EnumFormatTypeExcel.General, axis: ePivotFieldAxis.Column, sort: eSortType.Ascending); lst.Add("Vol Ytd", "AmountYtd", format: EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Row); lst.Add("Vol Month", "AmountM", format: EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Row); lst.Add("Post", "SalesmanPost", isVisible: false); return(lst); }
/// <summary> /// Formato para el reporte Guest Manifest Range de Host y Processor General /// </summary> /// <param name="module">Modulo desde donde se genera el reporte</param> /// <history> /// [edgrodriguez] 13/Jun/2016 Created /// [wtorres] 30/Sep/2016 Modified. Agregue el parametro module /// </history> public static ColumnFormatList RptManifestRangeByLs(EnumModule module) { //Hay columnas que no se deben desplegar en el manifiesto del modulo Host para ahorrar espacio bool isVisible = (module == EnumModule.ProcessorGeneral); ColumnFormatList lst = new ColumnFormatList(); lst.Add("Date", "DateManifest", EnumFormatTypeExcel.Date, isVisible: isVisible); lst.Add("Group", "SaleTypeN", isGroup: true, isVisible: isVisible); lst.Add("LocationN", "LocationN", isGroup: true, isVisible: false); lst.Add("ShowProgram", "ShowProgramN", isGroup: true, isVisible: false); lst.Add("SR", "SalesRoom", isVisible: isVisible); lst.Add("LS", "LeadSource", isVisible: isVisible); lst.Add("GUID", "guID", width: 7); lst.Add("Last Name", "LastName", width: 12, wordWrap: true); lst.Add("First Name", "FirstName", width: 12, wordWrap: true); lst.Add("Country", "CountryD", width: 18, fontSize: 6, wordWrap: true); lst.Add("Show D", "ShowD", EnumFormatTypeExcel.Date, isVisible: isVisible); lst.Add("Hotel", "Hotel", width: 11, fontSize: 6, wordWrap: true); lst.Add("Room", "Room", width: 8); lst.Add("Agency", "AgencyN", fontSize: 6, wordWrap: true); lst.Add("Pax", "Pax", EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum, width: 7); lst.Add("In", "TimeInT", EnumFormatTypeExcel.Time, width: 8); lst.Add("Out", "TimeOutT", EnumFormatTypeExcel.Time, width: 8); lst.Add("Host", "Hostess", width: 6); lst.Add("Sh", "Show", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("Tour", "Tour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 6); lst.Add("IO", "IO", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("WO", "WO", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("CT", "CTour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("Sv", "STour", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("D", "Direct", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("R", "Resch", EnumFormatTypeExcel.Boolean, function: DataFieldFunctions.Count, width: 4); lst.Add("N°", "PR1", width: 8); lst.Add("PR/SG", "PR1N", fontSize: 6, wordWrap: true); lst.Add("N°", "Liner1", width: 8); lst.Add("Sales R.", "Liner1N", fontSize: 6, wordWrap: true); lst.Add("N°", "Closer1", width: 8); lst.Add("FM1", "Closer1N", fontSize: 6, wordWrap: true); lst.Add("N°", "Closer2", width: 8); lst.Add("FM2", "Closer2N", fontSize: 6, wordWrap: true); lst.Add("N°", "Exit1", width: 8); lst.Add("JRFM", "Exit1N", fontSize: 6, wordWrap: true); lst.Add("Aff", "saMembershipNum", width: 7); lst.Add("Sale", "ProcSales", EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum, width: 6); lst.Add("Proc Orig", "ProcOriginal", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("Proc New", "ProcNew", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("Proc Gross", "ProcGross", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("Sale", "PendSales", EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum, width: 6); lst.Add("Pend Original", "PendOriginal", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("Pend New", "PendNew", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("Pend Gross", "PendGross", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("$ DP", "saDownPayment", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("% DP", "saDownPaymentPercentage", EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([ProcGross]=0,IF([PendGross]=0,0,[saDownPayment]/[PendGross]),[saDownPayment]/[ProcGross])", width: 6); lst.Add("$ EDP", "saDownPaymentPaid", EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum, width: 13); lst.Add("% EDP", "saDownPaymentPaidPercentage", EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([ProcGross]=0,IF([PendGross]=0,0,[saDownPaymentPaid]/[PendGross]),[saDownPaymentPaid]/[ProcGross])", width: 7); lst.Add("Deposit Sale", "DepositSale", EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum, width: 13); lst.Add("Deposit #", "DepositSaleNum", width: 10); lst.Add("CC", "CC", width: 5, fontSize: 6, wordWrap: true); lst.Add("Comments", "Comments", width: 15, fontSize: 6, wordWrap: true); lst.Add("SaleType", "SaleType", isVisible: false); lst.Add("Location", "Location", isVisible: false); lst.Add("Sequency", "Sequency", isVisible: false); lst.Add("Agency ID", "Agency", isVisible: false); lst.Add("Country ID", "Country", isVisible: false); lst.Add("PR 2", "PR2", isVisible: false); lst.Add("PR 2 Name", "PR2N", isVisible: false); lst.Add("PR 3", "PR3", isVisible: false); lst.Add("PR 3 Name", "PR3N", isVisible: false); lst.Add("Liner 2", "Liner2", isVisible: false); lst.Add("Liner 2 Name", "Liner2N", isVisible: false); lst.Add("Closer 3", "Closer3", isVisible: false); lst.Add("Closer 3 Name", "Closer3N", isVisible: false); lst.Add("Exit 2", "Exit2", isVisible: false); lst.Add("Exit 2 Name", "Exit2N", isVisible: false); return(lst); }
/// <summary> /// Genera las columnas que necesito en el reporte RPTStatistics /// </summary> /// <returns>List<ColumnFormat></returns> /// <history> /// [erosado] 14/Mar/2016 Created /// </history> public static ColumnFormatList getExcelFormatTable() { ColumnFormatList formatColumns = new ColumnFormatList(); formatColumns.Add("GUID", "guID"); formatColumns.Add("Last Name", "guLastName1"); formatColumns.Add("First Name", "guFirstName1"); formatColumns.Add("LS", "guls"); formatColumns.Add("SR", "gusr"); formatColumns.Add("Agency ID", "guag"); formatColumns.Add("Agency", "agN"); formatColumns.Add("Market ID", "gumk"); formatColumns.Add("Market", "mkN"); formatColumns.Add("Ext", "External", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Rbk", "Rebook", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Check-In D", "guCheckInD", format: EnumFormatTypeExcel.Date);// date formatColumns.Add("PR A", "guPRAssign"); formatColumns.Add("Avl", "guAvail", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("O.Avl", "guOriginAvail", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Info D", "guInfo", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("guInfoD", "guInfoD", format: EnumFormatTypeExcel.Date);//date formatColumns.Add("PR Info", "guPRInfo"); formatColumns.Add("PR Info Name", "PRInfoN"); formatColumns.Add("FU", "guFollow", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Follow D", "guFollowD", format: EnumFormatTypeExcel.Date);//date formatColumns.Add("PR Follow", "guPRFollow"); formatColumns.Add("PR Follow Name", "PRFollowN"); formatColumns.Add("Invit", "guInvit", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Book D", "guBookD", format: EnumFormatTypeExcel.Date);//date formatColumns.Add("PR", "guPRInvit1"); formatColumns.Add("PR Name", "PR1N"); formatColumns.Add("PR 2", "guPRInvit2"); formatColumns.Add("PR 2 Name", "PR2N"); formatColumns.Add("PR 3", "guPRInvit3"); formatColumns.Add("PR 3 Name", "PR3N"); formatColumns.Add("Qui", "guQuinella", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Books", "guRoomsQty", format: EnumFormatTypeExcel.Number); formatColumns.Add("SH", "guShow", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Show D", "guShowD", format: EnumFormatTypeExcel.Date);//date formatColumns.Add("Tour", "guTour", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("IO", "guInOut", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("WO", "guWalkOut", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("QS", "guQuinellaSplit", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Shows", "guShowsQty", format: EnumFormatTypeExcel.Number); formatColumns.Add("Sale", "guSale", format: EnumFormatTypeExcel.Boolean); formatColumns.Add("Sales", "Sales", format: EnumFormatTypeExcel.Number); formatColumns.Add("Amount", "SalesAmount", format: EnumFormatTypeExcel.Currency); return(formatColumns); }
/// <summary> /// Formato para el reporte de Sales Log /// </summary> /// <history> /// [jorcanche] created 07072016 /// </history> public static ColumnFormatList RptSaleLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("By", "slChangedBy"); lst.Add("Name", "ChangedByN"); lst.Add("Update Date/Time", "slID", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DateTime); lst.Add("GUID", "slgu"); lst.Add("Guest Name", "GuestName"); lst.Add("Sale D", "slD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date); lst.Add("Proc D", "slProcD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date); lst.Add("Cancel D", "slCancelD", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Date); lst.Add("Member #", "slMembershipNum"); lst.Add("Sale Type", "stN"); lst.Add("Reference", "slReference"); lst.Add("M Type', 'Membership Type", "mtN"); lst.Add("O Amount", "slOriginalAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency); lst.Add("N Amount", "slNewAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency); lst.Add("G Amount", "slGrossAmount", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.Currency); lst.Add("Loc", "sllo"); lst.Add("LS", "slls"); lst.Add("SR", "slsr"); lst.Add("SG", "slSelfGen"); lst.Add("PR 1", "slPR1"); lst.Add("PR Name", "PR1N"); lst.Add("PR 2", "slPR2"); lst.Add("PR 2 Name", "PR2N"); lst.Add("PR 3", "slPR3"); lst.Add("PR 3 Name", "PR3N"); lst.Add("Liner1 T", "slLiner1Type"); lst.Add("Liner 1", "slLiner1"); lst.Add("Liner 1 Name", "Liner1N"); lst.Add("Liner 2", "slLiner2"); lst.Add("Liner 2 Name", "Liner2N"); lst.Add("Liner 3", "slLiner3"); lst.Add("Liner 3 Name", "Liner3N"); lst.Add("FTM1", "slFTM1"); lst.Add("FTM1 Name", "FTM1N"); lst.Add("FTM2", "slFTM2"); lst.Add("FTM2 Name", "FTM2N"); lst.Add("FTB1", "slFTB1"); lst.Add("FTB1 Name", "FTB1N"); lst.Add("FTB2", "slFTB2"); lst.Add("FTB2 Name", "FTB2N"); lst.Add("Closer 1", "slCloser1"); lst.Add("Closer 1 Name", "Closer1N"); lst.Add("Closer 2", "slCloser2"); lst.Add("Closer 2 Name", "Closer2N"); lst.Add("Closer 3", "slCloser3"); lst.Add("Closer 3 Name", "Closer3N"); lst.Add("Closer 4", "slCloser4"); lst.Add("Closer 4 Name", "Closer4N"); lst.Add("Exit 1", "slExit1"); lst.Add("Exit 1 Name", "Exit1N"); lst.Add("Exit 2", "slExit2"); lst.Add("Exit 2 Name", "Exit2N"); lst.Add("Exit 3", "slExit3"); lst.Add("Exit 3 Name", "Exit3N"); lst.Add("Podium", "slPodium"); lst.Add("Podium Name", "PodiumN"); lst.Add("VLO", "slVLO"); lst.Add("VLO Name", "VLON"); lst.Add("PR Cptn", "slPRCaptain1"); lst.Add("PR Captain Name", "PR1CaptainN"); lst.Add("PR Cptn 2", "slPRCaptain2"); lst.Add("PR Captain 2 Name", "PR2CaptainN"); lst.Add("Liner Cptn", "slLinerCaptain1"); lst.Add("Liner Captain Name", "LinerCaptainN"); lst.Add("Closer Cptn", "slCloserCaptain1"); lst.Add("Closer Captain Name", "CloserCaptainN"); lst.Add("CL1 %", "slCloser1P"); lst.Add("CL2 %", "slCloser2P"); lst.Add("CL3 %", "slCloser3P"); lst.Add("Exit1 %", "slExit1P"); lst.Add("Exit2 %", "slExit2P"); lst.Add("C. Cost", "slClosingCost"); lst.Add("O. Pack", "slOverPack"); return(lst); }
/// <summary> /// Obtiene Un reporte de Arrivals en formato de Excel /// </summary> /// <param name="arrivlas">Lista de Arrivals para hacer el excel</param>} /// <history> /// [ecanul] 19/04/2016 Created /// [jorcanche] se agrego para abrir el archivo despues de guardar /// </history> public async static void ArrivalsToExcel(List <RptArrivals> arrivlas, DateTime date, Window window) { filters = new List <Tuple <string, string> >(); dt = new DataTable(); filters.Add(Tuple.Create("Lead Source", Context.User.LeadSource.lsID)); if (arrivlas.Count > 0) { dt = TableHelper.GetDataTableFromList(arrivlas, true); rptName = "Arrivals "; string dateRange = DateHelper.DateRangeFileName(date, date); ColumnFormatList format = new ColumnFormatList(); format.Add("GUID", "guID", width: 7); format.Add("Reserv.#", "guHReservID", width: 8); format.Add("Room", "guRoomNum", width: 7); format.Add("LastName", "guLastName1", width: 20); format.Add("In", "guCheckIn", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center); format.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumber, width: 6, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center); format.Add("Check-Out", "guCheckOutD", format: EnumFormatTypeExcel.Date, width: 10); format.Add("Country", "coN", width: 13); format.Add("Agency", "agN", width: 15, wordWrap: true); format.Add("Av", "guAvail", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center); format.Add("Info", "guInfo", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center); format.Add("Inv", "guInvit", format: EnumFormatTypeExcel.Boolean, width: 4, aligment: OfficeOpenXml.Style.ExcelHorizontalAlignment.Center); format.Add("PR B", "guPRInvit1", width: 15); format.Add("Comments", "guComments", width: 40, wordWrap: true); format.Add("County ID", "guco", isVisible: false); format.Add("Agency ID", "guag", isVisible: false); OpenFile(await ReportBuilder.CreateCustomExcelAsync(dt, filters, rptName, dateRange, format, addEnumeration: true, autoFit: false, numColumnsForApplicationName: 4), window); } }
/// <summary> /// Obtiene un reporte de Aviables en formato Excel /// </summary> /// <param name="aviables">Lista de Aviables</param> /// <history> /// [ecanul] 19/04/2016 Created /// [jorcanche] se agrego para abrir el archivo despues de guardar /// </history> public async static void AvailablesToExcel(List <RptAvailables> aviables, Window window) { filters = new List <Tuple <string, string> >(); dt = new DataTable(); filters.Add(Tuple.Create("Lead Source", Context.User.LeadSource.lsID)); DateTime date = BRHelpers.GetServerDate(); if (aviables.Count > 0) { dt = TableHelper.GetDataTableFromList(aviables, true); rptName = "Availables"; string dateRange = DateHelper.DateRangeFileName(date, date); ColumnFormatList format = new ColumnFormatList(); format.Add("GUID", "guID"); format.Add("Reserv.#", "guHReservID"); format.Add("Room", "guRoomNum"); format.Add("LastName", "guLastName1"); format.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumber); format.Add("Check-In", "guCheckInD", format: EnumFormatTypeExcel.Date); format.Add("Check-Out", "guCheckOutD", format: EnumFormatTypeExcel.Date); format.Add("Country ID", "guco"); format.Add("Country", "coN"); format.Add("Agency ID", "guag"); format.Add("Agency", "agN"); format.Add("Av", "guAvail", format: EnumFormatTypeExcel.Boolean); format.Add("Info", "guInfo", format: EnumFormatTypeExcel.Boolean); format.Add("Inv", "guInvit", format: EnumFormatTypeExcel.Boolean); format.Add("PR B", "guPRInvit1"); format.Add("Comments", "guComments"); OpenFile(await ReportBuilder.CreateCustomExcelAsync(dt, filters, rptName, dateRange, format, addEnumeration: true), window); } }
/// <summary> /// Formato para el excel de GiftLog /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [emoguel] modified 06/07/2016 /// </history> public static ColumnFormatList RptGiftLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Name", "ChangedByN", aligment: ExcelHorizontalAlignment.Left); lst.Add("By", "ggChangedBy", aligment: ExcelHorizontalAlignment.Left); lst.Add("Update Date/Time", "ggID", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DateTime); lst.Add("Cost Adults", "ggPrice1", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Cost Minors", "ggPrice2", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("CxC Adults", "ggPrice3", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("CxC Minors", "ggPrice4", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Price Adults", "ggPriceAdults", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Price Minors", "ggPriceMinors", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("P.E. Adults", "ggPriceExtraAdults", aligment: ExcelHorizontalAlignment.Left, format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Category", "gcN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Package", "ggPack", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean); lst.Add("Inventory", "ggInven", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean); lst.Add("Active", "ggA", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean); lst.Add("With Folio", "ggWFolio", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean); lst.Add("With Pax", "ggWPax", aligment: ExcelHorizontalAlignment.Center, format: EnumFormatTypeExcel.Boolean); lst.Add("Order", "ggO", aligment: ExcelHorizontalAlignment.Left); return(lst); }
/// <summary> /// Formato para el reporte de llegadas y asignacion /// </summary> /// <history> /// [vku] 31/Mar/2016 Created /// </history> public static ColumnFormatList getExcelFormatTableGenAsignyArvls() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("ID", "guID", format: EnumFormatTypeExcel.Id); lst.Add("Check In D", "guCheckInD", format: EnumFormatTypeExcel.Date); lst.Add("In", "guCheckIn", format: EnumFormatTypeExcel.Boolean); lst.Add("Room", "guRoomNum", format: EnumFormatTypeExcel.Id); lst.Add("Last Name", "guLastName1"); lst.Add("First Name", "guFirstName1"); lst.Add("PR ID", "guPRAssign"); lst.Add("PR N Assigned", "peN"); lst.Add("Agency ID", "guag", format: EnumFormatTypeExcel.Id); lst.Add("Agency", "agN"); lst.Add("Member #", "guMemberShipNum"); lst.Add("Amount", "Gross"); lst.Add("PR", "PR"); lst.Add("Liner", "Liner"); lst.Add("Closer", "Closer"); return(lst); }
/// <summary> /// Formato para el reporte Gifts Receipts Log /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 08/Jun/2016 Created /// </history> public static ColumnFormatList RptGiftReceiptsLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Sales man", "goChangedBy"); lst.Add("Name", "ChangedByN"); lst.Add("Update Date/Time", "goID", format: EnumFormatTypeExcel.DateTime); lst.Add("Receipt D", "goD", format: EnumFormatTypeExcel.Date); lst.Add("Offered By", "gope"); lst.Add("Offered By Name", "OfferedByN"); lst.Add("Host", "goHost"); lst.Add("Host Name", "HostN"); lst.Add("Deposit", "goDeposit", format: EnumFormatTypeExcel.Currency); lst.Add("Burned", "goBurned", format: EnumFormatTypeExcel.Currency); lst.Add("Currency", "gocu"); lst.Add("Payment Type", "ptN"); lst.Add("CxC PR Dep", "goCXCPRDeposit", format: EnumFormatTypeExcel.Currency); lst.Add("Taxit Out", "goTaxiOut", format: EnumFormatTypeExcel.Currency); lst.Add("Total Gifts", "goTotalGifts", format: EnumFormatTypeExcel.DecimalNumber); lst.Add("Charge To", "goct"); lst.Add("CxC Gifts", "goCXCGifts", format: EnumFormatTypeExcel.Currency); lst.Add("CxC Adj.", "goCXCAdj", format: EnumFormatTypeExcel.Currency); lst.Add("Re-Printed", "goReimpresion"); lst.Add("Re-Printed Motive", "rmN"); lst.Add("Authorized By", "goAuthorizedBy"); lst.Add("Authorized By Name", "AuthorizedByN"); lst.Add("Paid", "goAmountPaid", format: EnumFormatTypeExcel.Currency); lst.Add("Under Pay Motive", "upN"); lst.Add("Cancelled Date", "goCancelD", format: EnumFormatTypeExcel.Date); return(lst); }
public async static void PremanifestToExcel(List <RptPremanifestOuthouse> lstpremanifest, Window window) { _filters = new List <Tuple <string, string> > { Tuple.Create("Lead Source", Context.User.LeadSource.lsID) }; var date = BRHelpers.GetServerDate(); if (lstpremanifest.Count > 0) { var premanifestAux = lstpremanifest.Select(c => new { c.srN, c.guID, c.guOutInvitNum, c.Deposit, c.guHotel, c.guRoomNum, c.guLastName1, c.guFirstName1, c.guco, c.coN, c.guBookD, c.guBookT, c.guPRInvit1, guShow = c.guShow ? "✓" : "", guSale = c.guSale ? "✓" : "", c.guComments, }).ToList(); var dt = TableHelper.GetDataTableFromList(premanifestAux, true); _rptName = "Premanifest Outhouse " + Context.User.LeadSource.lsN; var dateRange = DateHelper.DateRangeFileName(date, date); var format = new ColumnFormatList(); format.Add("SR", "srN", isGroup: true, isVisible: false); format.Add("Deposit", "Deposit", isGroup: true, isVisible: false); format.Add("GUID", "guID"); format.Add("Out Invit", "guOutInvitNum"); format.Add("Hotel", "guHotel"); format.Add("Room", "guRoomNum"); format.Add("Last Name", "guLastName1"); format.Add("Firs tName", "guFirstName1"); format.Add("Country ID", "guco"); format.Add("Country", "coN"); format.Add("Book D", "guBookD", format: EnumFormatTypeExcel.Date); format.Add("Book T", "guBookT", format: EnumFormatTypeExcel.Time); format.Add("PR B", "guPRInvit1"); format.Add("Sh", "guShow", axis: ePivotFieldAxis.Values, aligment: ExcelHorizontalAlignment.Center, function: DataFieldFunctions.Count); format.Add("Sale", "guSale", axis: ePivotFieldAxis.Values, aligment: ExcelHorizontalAlignment.Center, function: DataFieldFunctions.Count); format.Add("Deposits / Comments", "guComments"); var info = await ReportBuilder.CreateCustomExcelAsync(dt, _filters, _rptName, dateRange, format, blnShowSubtotal : true, blnRowGrandTotal : true, addEnumeration : true); if (info != null) { frmDocumentViewer documentViewer = new frmDocumentViewer(info, Context.User.HasPermission(EnumPermission.RptExcel, EnumPermisionLevel.ReadOnly), false); documentViewer.Owner = window; documentViewer.ShowDialog(); } } }
/// <summary> /// Formato para el reporte Premanifest With Gifts de Host e Inhouse /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 21/Jun/2016 Created /// </history> public static ColumnFormatList RptPremanifestWithGifts() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Sales Room", "srN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false); lst.Add("Location", "loN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false); lst.Add("GUID", "guID", EnumFormatTypeExcel.Id); lst.Add("LS", "guls", EnumFormatTypeExcel.General); lst.Add("Room", "guRoomNum", EnumFormatTypeExcel.General); lst.Add("Last Name", "guLastName1", EnumFormatTypeExcel.General); lst.Add("County ID", "guco", EnumFormatTypeExcel.General); lst.Add("County", "coN", EnumFormatTypeExcel.General); lst.Add("Hotel", "guHotel", EnumFormatTypeExcel.General); lst.Add("Pax", "guPax", EnumFormatTypeExcel.DecimalNumber); lst.Add("Invit D", "guInvitD", EnumFormatTypeExcel.Date); lst.Add("Invit T", "guInvitT", EnumFormatTypeExcel.Time); lst.Add("Resch", "guReschDT", EnumFormatTypeExcel.Date); lst.Add("CheckIn", "guCheckInD", EnumFormatTypeExcel.Date); lst.Add("CheckOut", "guCheckOutD", EnumFormatTypeExcel.Date); lst.Add("Agency ID", "guag", EnumFormatTypeExcel.General); lst.Add("Agency", "agN", EnumFormatTypeExcel.General); lst.Add("Comments", "guComments", EnumFormatTypeExcel.General); lst.Add("Book T", "guBookT", EnumFormatTypeExcel.Time); lst.Add("PR", "guPRInvit1", EnumFormatTypeExcel.General); lst.Add("G.T./CC", "guO2", EnumFormatTypeExcel.General); lst.Add("CCType", "guCCType", EnumFormatTypeExcel.General); lst.Add("Sh", "guShow", EnumFormatTypeExcel.General); lst.Add("Sa", "guSale", EnumFormatTypeExcel.General); lst.Add("Canc Book", "guBookCanc", EnumFormatTypeExcel.General); lst.Add("Gifts", "Gifts", EnumFormatTypeExcel.General); return(lst); }
/// <summary> /// Formato para el reporte Premanifest de Hosts e Inhouse /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [edgrodriguez] 21/Jun/2016 Created /// </history> public static ColumnFormatList RptPremanifest() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("SR", "srN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false); lst.Add("LS", "loN", EnumFormatTypeExcel.General, isGroup: true, isVisible: false); lst.Add("GUID", "guID", EnumFormatTypeExcel.Id); lst.Add("Hotel", "guHotel", EnumFormatTypeExcel.General); lst.Add("Room", "guRoomNum", EnumFormatTypeExcel.General); lst.Add("LastName", "guLastName1", EnumFormatTypeExcel.General); lst.Add("Pax", "guPax", EnumFormatTypeExcel.DecimalNumber); lst.Add("Check-In", "guCheckInD", EnumFormatTypeExcel.Date); lst.Add("Check-Out", "guCheckOutD", EnumFormatTypeExcel.Date); lst.Add("Country ID", "guco", EnumFormatTypeExcel.General); lst.Add("Country", "coN", EnumFormatTypeExcel.General); lst.Add("Agency ID", "guag", EnumFormatTypeExcel.General); lst.Add("Agency", "agN", EnumFormatTypeExcel.General); lst.Add("Invit D", "guInvitD", EnumFormatTypeExcel.Date); lst.Add("Invit T", "guInvitT", EnumFormatTypeExcel.Time); lst.Add("Book T", "guBookT", EnumFormatTypeExcel.Time); lst.Add("PR B", "guPRInvit1", EnumFormatTypeExcel.General); lst.Add("Clxd", "guBookCanc", EnumFormatTypeExcel.Boolean); lst.Add("Rsc", "guResch", EnumFormatTypeExcel.Boolean); lst.Add("Sh", "guShow", EnumFormatTypeExcel.Boolean); lst.Add("Sale", "guSale", EnumFormatTypeExcel.General); lst.Add("InvitType", "InvitType", EnumFormatTypeExcel.General); lst.Add("Deposits_Comments", "guComments", EnumFormatTypeExcel.General); return(lst); }
/// <summary> /// Genera las columnas que necesito en el reporte RPTStatistics /// </summary> /// <returns>List<ColumnFormat></returns> /// <history> /// [erosado] 14/Mar/2016 Created /// </history> public static ColumnFormatList getExcelFormatTable() { ColumnFormatList formatColumns = new ColumnFormatList(); formatColumns.Add("PR Id", "PR_ID"); formatColumns.Add("PR Name", "PR_NAME"); formatColumns.Add("PR Status", "P_Status", isGroup: true, isVisible: false); formatColumns.Add("Assign", "Assign", format: EnumFormatTypeExcel.Number, function: DataFieldFunctions.Sum); formatColumns.Add("Conts", "Conts", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("C%", "C_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Assign]=0,0,[Conts]/[Assign])"); formatColumns.Add("Avails", "Avails", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("A%", "A_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Conts]=0,0,[Avails]/[Conts])"); formatColumns.Add("Bk", "Bk", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Bk%", "Bk_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Avails]=0,0,[T_Books]/[Avails])"); formatColumns.Add("TBooks", "T_Books", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Dep", "Dep", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Dir", "Dir", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Sh", "Sh", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("IO", "IO", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Sh%", "Sh_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Bk]=0,0,[TSh]/[Bk])"); formatColumns.Add("T Sh", "TSh", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("SG", "SG", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Proc #", "Proc_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Processable", "Processable", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "[Total] - [Out_Pending]"); formatColumns.Add("Out Pending #", "OutP_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Out Pending", "Out_Pending", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); formatColumns.Add("C #", "C_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Cancelled", "Cancelled", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); formatColumns.Add("Total #", "Total_Number", format: EnumFormatTypeExcel.DecimalNumber, function: DataFieldFunctions.Sum); formatColumns.Add("Total", "Total", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); formatColumns.Add("Proc PR #", "Proc_PR_Number", isCalculated: true, formula: "[Proc_Number]-[Proc_SG_Number]"); formatColumns.Add("Proc PR", "Proc_PR", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "[Total]-[Proc_SG]"); formatColumns.Add("Proc SG #", "Proc_SG_Number", function: DataFieldFunctions.Sum); formatColumns.Add("Proc SG", "Proc_SG", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); formatColumns.Add("Eff", "Eff", format: EnumFormatTypeExcel.DecimalNumber, isCalculated: true, formula: "IF([TSh]=0,0,[Total]/[TSh])"); formatColumns.Add("Cl %", "Cl_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([TSh]=0,0,[Proc_Number]/[TSh])"); formatColumns.Add("Ca %", "Ca_Factor", format: EnumFormatTypeExcel.Percent, isCalculated: true, formula: "IF([Total]=0,0,[Cancelled]/[Total])"); formatColumns.Add("Avg Sale", "Avg_Sale", format: EnumFormatTypeExcel.Currency, isCalculated: true, formula: "IF([Proc_Number]=0,0,[Total]/[Proc_Number])"); return(formatColumns); }
/// <summary> /// Formato para el reporte de Sales Log /// </summary> /// <history> /// [jorcanche] created 03102016 /// </history> public static ColumnFormatList RptSalesmenChanges() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Date / Time", "schDT", aligment: ExcelHorizontalAlignment.Left); lst.Add("Authorized By", "schAuthorizedBy", aligment: ExcelHorizontalAlignment.Left); lst.Add("Authorized By Name", "AuthorizedByN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Made By", "schMadeBy", aligment: ExcelHorizontalAlignment.Left); lst.Add("Made By Name", "MadeByN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Role", "roN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Position", "schPosition", aligment: ExcelHorizontalAlignment.Left); lst.Add("Old Salesman", "schOldSalesman", aligment: ExcelHorizontalAlignment.Left); lst.Add("Old Salesman Name", "OldSalesmanN", aligment: ExcelHorizontalAlignment.Left); lst.Add("New Salesman", "schNewSalesman", aligment: ExcelHorizontalAlignment.Left); lst.Add("New Salesman Name", "NewSalesmanN", aligment: ExcelHorizontalAlignment.Left); return(lst); }
/// <summary> /// Crea el formato para crear el reporte de Assistencias /// </summary> /// <history> /// [ecanul] 13/09/2016 Created /// </history> private static ColumnFormatList RptAssistanceFormat() { ColumnFormatList format = new ColumnFormatList(); format.Add("Place Type", "asPlaceType"); format.Add("Place ID", "asPlaceID"); format.Add("Date Start", "asStartD", format: EnumFormatTypeExcel.Date); format.Add("Date End", "asEndD", format: EnumFormatTypeExcel.Date); format.Add("ID", "aspe"); format.Add("Name", "peN"); format.Add("Monday", "asMonday"); format.Add("Tuesday", "asTuesday"); format.Add("Wednesday", "asWednesday"); format.Add("Thursday", "asThursday"); format.Add("Friday", "asFriday"); format.Add("Saturday", "asSaturday"); format.Add("Sunday", "asSunday"); format.Add("#Assistence", "asNum"); return(format); }
/// <summary> /// Genera las columnas que necesito en el reporte Sales by PR /// </summary> /// <returns>List<ColumnFormatList></returns> /// <history> /// [erosado] 23/Mar/2016 Created /// </history> public static ColumnFormatList getExcelFormatTable() { ColumnFormatList formatColumns = new ColumnFormatList(); formatColumns.Add("Sale ID", "saID"); formatColumns.Add("LS", "sals"); formatColumns.Add("SR", "sasr"); formatColumns.Add("Member. #", "saMembershipNum"); formatColumns.Add("Sale Type", "stN"); formatColumns.Add("Date", "saD", format: EnumFormatTypeExcel.Date); //Date formatColumns.Add("Proc Date", "saProcD", format: EnumFormatTypeExcel.Date); //Date formatColumns.Add("Last Name", "saLastName1"); formatColumns.Add("Chk-Out D", "guCheckOutD", format: EnumFormatTypeExcel.Date); //Date formatColumns.Add("Agency ID", "guag"); formatColumns.Add("Agency", "agN"); formatColumns.Add("PR", "saPR1"); formatColumns.Add("PR Name", "PR1N"); formatColumns.Add("PR2", "saPR2"); formatColumns.Add("PR2 Name", "PR2N"); formatColumns.Add("PR3", "saPR3"); formatColumns.Add("PR3 Name", "PR3N"); formatColumns.Add("Q", "guQ", format: EnumFormatTypeExcel.Boolean); //Boolean formatColumns.Add("Amount", "saGrossAmount", format: EnumFormatTypeExcel.Currency, function: DataFieldFunctions.Sum); //Currency formatColumns.Add("Cxld", "saCancel", format: EnumFormatTypeExcel.Boolean); //Boolean formatColumns.Add("Cancel D", "saCancelD", format: EnumFormatTypeExcel.Date); //Date return(formatColumns); }
/// <summary> /// Formato para el reporte de Guest Log /// </summary> /// <history> /// [jorcanche] created 07072016 /// [emoguel] 08/10/2016 Modified--->Se agregaron las columnas para Liner3,Closer4, Exit 3, Front To back 1 y 2, Front To Middle 1 y 2 /// </history> public static ColumnFormatList RptGuestLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("By", "glChangedBy"); lst.Add("Name", "ChangedByN"); lst.Add("Update Date/Time", "glID", EnumFormatTypeExcel.DateTime); lst.Add("SR", "glsr"); lst.Add("Last Name", "glLastName1"); lst.Add("First Name", "glFirstName1"); lst.Add("Last Name 2", "glLastName2"); lst.Add("First Name 2", "glFirstName2"); lst.Add("Reserv. #", "glHReservID"); lst.Add("Avl Sys", "glAvailBySystem"); lst.Add("Orig Avl", "glOriginAvail"); lst.Add("Avl", "glAvail"); lst.Add("Unavailable Motive", "umN"); lst.Add("PR Avail", "glPRAvail"); lst.Add("PR Avail Name", "PRAvailN"); lst.Add("Info D", "glInfoD", EnumFormatTypeExcel.Date); lst.Add("PR Info", "glPRInfo"); lst.Add("PR Info Name", "PRInfoN"); lst.Add("Follow D", "glFollowD", EnumFormatTypeExcel.Date); lst.Add("PR Follow", "glPRFollow"); lst.Add("PR Follow Name", "PRFollowN"); lst.Add("Book D", "glBookD", EnumFormatTypeExcel.Date); lst.Add("Book T", "glBookT", EnumFormatTypeExcel.Time); lst.Add("Resch D", "glReschD", EnumFormatTypeExcel.Date); lst.Add("Resch T", "glReschT", EnumFormatTypeExcel.Time); lst.Add("PR B", "glPRInvit1"); lst.Add("PR Booking Name", "PRInvit1N"); lst.Add("PR B 2", "glPRInvit2"); lst.Add("PR Booking 2 Name", "PRInvit2N"); lst.Add("C.Bk", "glBookCanc"); lst.Add("Liner 1", "glLiner1"); lst.Add("Liner 1 Name", "Liner1N"); lst.Add("Liner 2", "glLiner2"); lst.Add("Liner 2 Name", "Liner2N"); lst.Add("Liner 3", "glLiner3"); lst.Add("Liner 3 Name", "Liner3N"); lst.Add("Front To Middle 1", "glFTM1"); lst.Add("Frint To Middle 1 Name", "FTM1N"); lst.Add("Front To Middle 2", "glFTM2"); lst.Add("Frint To Middle 2 Name", "FTM2N"); lst.Add("Front To Back 1", "glFTB1"); lst.Add("Frint To Back 1 Name", "FTB1N"); lst.Add("Front To Back 2", "glFTB2"); lst.Add("Frint To Back 2 Name", "FTB2N"); lst.Add("Closer 1", "glCloser1"); lst.Add("Closer 1 Name", "Closer1N"); lst.Add("Closer 2", "glCloser2"); lst.Add("Closer 2 Name", "Closer2N"); lst.Add("Closer 3'", "glCloser3"); lst.Add("Closer 3 Name", "Closer3N"); lst.Add("Closer 4'", "glCloser4"); lst.Add("Closer 4 Name", "Closer4N"); lst.Add("Exit1", "glExit1"); lst.Add("Exit 1 Name", "Exit1N"); lst.Add("Exit2", "glExit2"); lst.Add("Exit 2 Name", "Exit2N"); lst.Add("Exit 3", "glExit3"); lst.Add("Exit 3 Name", "Exit3N"); lst.Add("Podium", "glPodium"); lst.Add("Podium Name", "PodiumN"); lst.Add("VLO", "glVLO"); lst.Add("VLO Name", "VLON"); lst.Add("Sh", "glShow"); lst.Add("Show D", "glShowD", EnumFormatTypeExcel.Date); lst.Add("Q", "glQ"); lst.Add("IO", "glInOut"); lst.Add("WO", "glWalkOut"); lst.Add("CT", "glCTour"); lst.Add("Re-Printed", "glReimpresion"); lst.Add("Re-Print Motive", "rmN"); return(lst); }
/// <summary> /// Genera las columnas que necesito en el reporte RPTStatistics /// </summary> /// <returns>List<ColumnFormat></returns> /// <history> /// [erosado] 23/Mar/2016 Created /// </history> public static ColumnFormatList getExcelFormatTable() { ColumnFormatList formatColumns = new ColumnFormatList(); formatColumns.Add("Sale ID", "saID"); formatColumns.Add("LS", "sals"); formatColumns.Add("SR", "sasr"); formatColumns.Add("Member. #", "saMembershipNum"); formatColumns.Add("Sale Type", "stN"); formatColumns.Add("Date", "saD", format: EnumFormatTypeExcel.Date); //Date formatColumns.Add("Proc Date", "saProcD", format: EnumFormatTypeExcel.Date); //Date formatColumns.Add("Last Name", "saLastName1"); formatColumns.Add("Closer", "saCloser1"); formatColumns.Add("Closer Name", "Closer1N"); formatColumns.Add("Closer 2", "saCloser2"); formatColumns.Add("Closer 2 Name", "Closer2N"); formatColumns.Add("Closer 3", "saCloser3"); formatColumns.Add("Closer 3 Name", "Closer3N"); formatColumns.Add("Exit", "saExit1"); formatColumns.Add("Exit Name", "Exit1N"); formatColumns.Add("Exit 2", "saExit2"); formatColumns.Add("Exit 2 Name", "Exit2N"); formatColumns.Add("Amount", "saGrossAmount", format: EnumFormatTypeExcel.Currency); //Currency formatColumns.Add("Cxld", "saCancel", format: EnumFormatTypeExcel.Boolean); //Boolean formatColumns.Add("Cancel D", "saCancelD", format: EnumFormatTypeExcel.Date); //Date return(formatColumns); }
/// <summary> /// Formato para el reporte Deposit By PR /// </summary> /// <history> /// [edgrodriguez] 19/Abr/2016 Created /// [jorcanche] 19/ago/2016 modified se cambio de lugar de IM.ProcessorGeneral.Classes a IM.Base.Reports /// [edgrodriguez] 05/Sep/2016 Modified. Se cambio el formato. /// </history> public static ColumnFormatList RptDepositByPr() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("PR", "guPRInvit1", axis: ePivotFieldAxis.Row, isGroup: true, isVisible: false); lst.Add("GUID", "guID", axis: ePivotFieldAxis.Row); lst.Add("Out Invit", "guOutInvitNum", axis: ePivotFieldAxis.Row); lst.Add("Guest", "Guest", axis: ePivotFieldAxis.Row); lst.Add("Hotel", "guHotel", axis: ePivotFieldAxis.Row); lst.Add("LS", "guls", axis: ePivotFieldAxis.Row); lst.Add("SR", "gusr", axis: ePivotFieldAxis.Row); lst.Add("Book Date", "guBookD", EnumFormatTypeExcel.Date, axis: ePivotFieldAxis.Row); lst.Add("Deposited", "guDeposit", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, function: DataFieldFunctions.Sum); lst.Add("Received", "guDepositReceived", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, function: DataFieldFunctions.Sum); lst.Add("CxC", "CxC", EnumFormatTypeExcel.Currency, axis: ePivotFieldAxis.Values, isCalculated: true, formula: "[guDeposit]-[guDepositReceived]"); lst.Add("Currency", "gucu", axis: ePivotFieldAxis.Column, sort: eSortType.Ascending); lst.Add("Payment Type", "gupt", axis: ePivotFieldAxis.Column, sort: eSortType.Descending); lst.Add("guInvitD", "guInvitD", isVisible: false); lst.Add("PR Name", "peN", isVisible: false); return(lst); }
/// <summary> /// Formato para el excel de Personnel Log /// </summary> /// <returns> List of ColumnFormat</returns> /// <history> /// [emoguel] 17/10/2016 created /// </history> public static ColumnFormatList RptPersonnelLog() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("Changed By", "plgChangedBy", aligment: ExcelHorizontalAlignment.Left); lst.Add("Changed By Name", "ChangedByN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Update Date/Time", "plgDT", aligment: ExcelHorizontalAlignment.Left); lst.Add("Personnel", "plgpe", aligment: ExcelHorizontalAlignment.Left); lst.Add("Personnel Name", "peN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Department", "plgde", aligment: ExcelHorizontalAlignment.Left); lst.Add("Department Name", "deN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Post", "plgpo", aligment: ExcelHorizontalAlignment.Left); lst.Add("Post Name", "poN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Sales Room", "plgsr", aligment: ExcelHorizontalAlignment.Left); lst.Add("Sales Room Name", "srN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Location", "plglo", aligment: ExcelHorizontalAlignment.Left); lst.Add("Location Name", "loN", aligment: ExcelHorizontalAlignment.Left); lst.Add("Roles", "Roles", aligment: ExcelHorizontalAlignment.Left); lst.Add("Sales Rooms", "SalesRooms", aligment: ExcelHorizontalAlignment.Left); lst.Add("Lead Sources", "LeadSources", aligment: ExcelHorizontalAlignment.Left); return(lst); }
/// <summary> /// Formato para el reporte de asignacion po PR /// </summary> /// <history> /// [vku] 31/Mar/2016 Created /// [vku] 20/Jul/2016 Modified. Elimine las columnas PR ID, PR N Assigned /// Se corrigio el orden de las columnas /// </history> public static ColumnFormatList getExcelFormatTableAssignByPR() { ColumnFormatList lst = new ColumnFormatList(); lst.Add("In", "guCheckInD", format: EnumFormatTypeExcel.Date); lst.Add("Out", "guCheckOutD", format: EnumFormatTypeExcel.Date); lst.Add("Room", "guRoomNum", format: EnumFormatTypeExcel.Id); lst.Add("Last Name", "guLastName1"); lst.Add("First Name", "guFirstName1"); lst.Add("Agency ID", "guag", format: EnumFormatTypeExcel.Id); lst.Add("Agency", "agN"); lst.Add("Member #", "guMemberShipNum"); lst.Add("Pax", "guPax", format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Comments", "guComments"); lst.Add("Contract", "guO1"); lst.Add("Monday", "monday", format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Tuesday", "tuesday"); lst.Add("Wednesday", "wednesday"); lst.Add("Thursday", "thursday", format: EnumFormatTypeExcel.DecimalNumberWithCero); lst.Add("Friday", "friday"); lst.Add("Saturday", "saturday"); lst.Add("Sunday", "sunday"); return(lst); }