PlantANT PlantANT Supplier Info supplier_id,System.Int32 companyname,System.String phone1,System.String phone2,System.String fax,System.String certification,System.String companyemail,System.String website,System.String nurserytype,System.Int32 hours,System.String plants,System.Int32 supplies,System.Int32 services,System.Int32 request,System.Int32 paypal,System.Int32 visa,System.Int32 amex,System.Int32 mastercard,System.Int32 discover,System.Int32 cash,System.Int32 check,System.Int32 getemails,System.Int32 supplier_active,System.Int32 address_id,System.Int32 address1,System.String address2,System.String city,System.String state,System.Int32 companyzip,System.String latitude,System.String longitude,System.String country_id,System.Int32 addresstype_id,System.Int32 state_id,System.Int32 state_name,System.String state_ab,System.String logo,System.String 30 Supplier Info PlantANT SELECT * FROM suppliers JOIN supplieraddress ON suppliers.supplier_id = supplieraddress.supplier_id JOIN states ON states.state_id = supplieraddress.state WHERE suppliers.supplier_id = {supplier} Inventory supplier_id,System.Int32 scientific_name,System.String pid,System.Int32 iid,System.Int32 container_desc,System.String inventory_desc,System.String inventory_price,System.String priceunit_short,System.String inventory_active,System.Int32 state_ab,System.String commonnames,System.String features,System.Byte[] sizes,System.Byte[] description,System.Byte[] order,System.Int32 inventory_price,System.String sortorder,System.Decimal 30 Inventory PlantANT SELECT DISTINCT suppliers.supplier_id, plants.plant_id as pid, scientific_name, inventory.inventory_id as iid, REPLACE(containersizes.container_desc, """, "\"") as container_desc, containersizes.order, case (inventory.inventory_price mod 1 > 0) when true then FORMAT(inventory.inventory_price, 2) else inventory.inventory_price end AS inventory_price, IF(inventory.inventory_price = 0, 999999, inventory.inventory_price) as sortorder, priceunits.priceunit_short, inventory.inventory_active, states.state_ab, TRIM(BOTH ' ' FROM (SELECT GROUP_CONCAT(' ', common_name) FROM plants JOIN plantscommon ON plantscommon.plant_id = plants.plant_id WHERE plants.plant_id = pid AND common_name != scientific_name)) AS commonnames, REPLACE(TRIM(BOTH ', ' FROM CONCAT( IFNULL(inventory.inventory_desc, ''), ', ', (SELECT IFNULL(TRIM(BOTH ' ' FROM GROUP_CONCAT(' ', plantfeaturetype_desc)),'') FROM plantfeaturetype JOIN plantfeature ON plantfeature.plantfeaturetype_id = plantfeaturetype.plantfeaturetype_id WHERE plantfeature.inventory_id = iid), ', ', (SELECT IFNULL(TRIM(BOTH ' ' FROM GROUP_CONCAT(' ', plantsize_from, if(plantsize_to > 0, '-', ''), if(plantsize_to > 0, plantsize_to, ''), plantsizetype_desc2)), '') FROM plantsizetype JOIN plantsize ON plantsize.plantsizetype_id = plantsizetype.plantsizetype_id WHERE plantsize.inventory_id = iid) )), ', , ', ', ') AS description FROM plants JOIN plantscommon ON plantscommon.plant_id = plants.plant_id JOIN inventory ON inventory.plant_id = plants.plant_id JOIN suppliers ON suppliers.supplier_id = inventory.supplier_id JOIN containersizes ON containersizes.containersize_id = inventory.containersize_id JOIN priceunits ON priceunits.priceunit_id = inventory.priceunit_id JOIN states ON states.state_id = plants.native WHERE suppliers.supplier_id = {supplier} AND inventory.inventory_active = 1 AND inventory.deleted = 0 ORDER BY scientific_name ASC, containersizes.order ASC, ABS(sortorder) ASC ,supplier,supplier,System.String,_x0031_000002,False,False ,path,path,System.String,plants,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 0,0,11.6,0.8 Arial,12 http://www.stimulsoft.com 0,0,0,0 Text7 Up to date as of {Today.Month}/{Today.Day}/{Today.Year} | plantANT.com SaddleBrown Center Transparent 11.6,0,7.4,0.8 Arial,12 Right 0,0,0,0 Text6 {PageNofM} SaddleBrown Center PageFooterBand1 True Transparent True 13.6,0.4,5.4,3.8 ../supplierimages/image.php/{supplier}.jpg?width=600&height=600&image=/{path}/supplierimages/logos/{supplier}.jpg True Image2 OnlyFirstPage True Transparent 0,0.4,19,2.2 Transparent 0,0,13.4,1.6 Arial,18,Bold 0,0,0,0 Text5 {Supplier_Info.companyname} Availability List SaddleBrown Center ReportTitleBand1 Transparent True 0,3.4,19,3.2 Transparent True 0,0,6,1.6 Arial,10 True 0,0,0,15 Text14 {Supplier_Info.address1}{IIF(Supplier_Info.address2 + " " == " ", "", " ")}{Supplier_Info.address2} {Supplier_Info.city}, {Supplier_Info.state_ab} {Supplier_Info.companyzip} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent True True 6.4,0,7,1.6 Arial,10 0,0,0,15 Text15 {Supplier_Info.website}{IIF(Supplier_Info.website + " " == " ", "", " ")}{Supplier_Info.companyemail} Phone: {Supplier_Info.phone1}{IIF(Supplier_Info.phone2 + " " == " ", "", " Phone 2: ")}{Supplier_Info.phone2}{IIF(Supplier_Info.fax + " " == " ", "", " Fax: ")}{Supplier_Info.fax} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Transparent 0,1.8,13.4,1.4 Arial,10 0,0,0,0 Text1 {IIF(Supplier_Info.hours + " " == " ", "", "Hours: ")}{Supplier_Info.hours}{IIF(Supplier_Info.hours + " " == " ", "", " ")}Accepted Payment Types: {IIF(Supplier_Info.paypal == "1", "PayPal ", "")}{IIF(Supplier_Info.visa == "1", "Visa ", "")}{IIF(Supplier_Info.amex == "1", "Amex ", "")}{IIF(Supplier_Info.mastercard == "1", "MasterCard ", "")}{IIF(Supplier_Info.discover == "1", "Discover ", "")}{IIF(Supplier_Info.cash == "1", "Cash ", "")}{IIF(Supplier_Info.check == "1", "Check ", "")} Black Supplier Info DataBand3 Transparent 0,7.4,19,0.6 Peru 0,0,3.8,0.6 Arial,12,Bold 0,0,0,0 Text10 Size White Center Peru 3.8,0,12.2,0.6 Arial,12,Bold 0,0,0,0 Text12 DecreasingSize, OnlyInWidthOfComponent Description White Center Peru 16,0,3,0.6 Arial,12,Bold 0,0,0,0 Text13 Price White Center HeaderBand1 True Transparent True 0,8.8,19,1.4 Top;[0:0:0];1;Solid;False;4;Black [255:255:255] True 0,0,19,0.6 Arial,10,Bold 0,0,0,0 Text9 {Inventory.scientific_name} [0:0:0] Center Top;[0:0:0];1;None;False;4;Black [255:255:255] True 0,0.6,19,0.6 Arial,10 0,0,0,0 Text2 {Inventory.commonnames} [0:0:0] Center {Inventory.scientific_name} GroupHeaderBand1 Transparent 0,11,19,0.6 Transparent True 0,0,3.2,0.6 Arial,10 0,0,0,0 Text11 {Inventory.container_desc} Black Transparent True 3.8,0,11.6,0.6 Arial,10 0,0,0,0 Text16 {Inventory.description} Black Transparent True 16,0,3,0.6 Arial,10 0,0,0,0 Text17 {IIF(Inventory.inventory_price == "0", "Call", "$"+Inventory.inventory_price + " " + Inventory.priceunit_short)} Black Inventory Even DataBand2 Odd Transparent True 0,12.4,19,0.2 Transparent True 0,0,19,0.2 Arial,10 0,0,0,0 Text8 Black Center FooterBand1 True True 366bfdc35bcf48f3aeb38f2b5f58db21 1,1,1,1 Page1 29.7 21 Arial,100,Bold [50:0:0:0] StandardAndDotMatrix 33538047 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Base.Dll Stimulsoft.Controls.Dll Stimulsoft.Report.Dll Simple List 09/12/2012 03:28:11 PM 05/29/2004 06:02:24 AM SimpleList2.mrt c8fa924a5bd13f65ae8abbf3f8daba58 Report Centimeters 2012.1.1300 CSharp WhiteSmoke Arial,8 Odd Black Transparent Arial,8 Even Black