File manager - Edit - G:/PleskVhosts/fullscreenksa.com/Falafel.fullscreenksa.com/StoresReports/ItemsEvaluationReport.aspx
Back
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Master_Page.Master" AutoEventWireup="true" CodeBehind="ItemsEvaluationReport.aspx.cs" Inherits="Erp_TotalReport.StoresReports.ItemsEvaluationReport" %> <%@ Register assembly="DevExpress.Web.v16.2, Version=16.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web" tagprefix="dx" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3">Items Evaluation Report</font></div> </div> <div class="panel-body"> <div class="row"> <div class="form-group col-md-offset-10"> <dx:aspxbutton ID="ASPxButton1" runat="server" ValidationGroup="aly" Text="Show Data" OnClick="ASPxButton1_Click" Theme="iOS"></dx:aspxbutton> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" SelectCommand="SELECT [CompanyID], [CompanyName] FROM [CompanyData]"></asp:SqlDataSource> </div> </div> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3"> Data</font></div> </div> <div class="panel-body" align="center" > <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="ASPxGridView1" Landscape="True"> </dx:ASPxGridViewExporter> <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" GridLines="Vertical" Theme="Default" AllowSorting="true" ShowFooter="true" EmptyDataText="لا يوجد نتائج" EnableTheming="True" CssClass="dt-responsive " KeyFieldName="ids" Width="100%" EnablePagingCallbackAnimation="True"> <SettingsDetail ExportMode="All" /> <StylesContextMenu> <Row> <Style HorizontalAlign="Center" VerticalAlign="Middle"> </Style> </Row> </StylesContextMenu> <SettingsPager NumericButtonCount="15" PageSize="15" Mode="ShowAllRecords"> </SettingsPager> <Settings ShowFilterRow="True" ShowGroupPanel="True" AutoFilterCondition="Contains" ShowFilterRowMenu="True" ShowFooter="True" VerticalScrollableHeight="500" VerticalScrollBarMode="Visible" HorizontalScrollBarMode="Visible" ShowFilterBar="Visible" ShowGroupFooter="VisibleAlways" VerticalScrollBarStyle="VirtualSmooth" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn Caption="Total Net Purcheses" FieldName="NetPurches" ShowInCustomizationForm="True" VisibleIndex="12" Name="NetPurches"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCCCCC" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Purcheses Quantity" FieldName="NetPurchesCount" Name="NetPurchesCount" VisibleIndex="13"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Diff Quantity" FieldName="SalesPurchesDiff" ShowInCustomizationForm="True" VisibleIndex="14" Name="SalesPurchesDiff"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Item Name " FieldName="ItemName" Name="ItemName" VisibleIndex="2"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Item Code" FieldName="ItemCode" Name="ItemCode" VisibleIndex="1"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <EditCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </EditCellStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle Font-Size="Smaller" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Sales Quantity" FieldName="NetSalesCount" Name="NetSalesCount" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Category Name" FieldName="CategoryName" VisibleIndex="3"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#CCCCCC"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Class Name" FieldName="ClassDesc" VisibleIndex="4"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#CCCCCC"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Last Sales Date" FieldName="LastSalesDate" VisibleIndex="18"> <PropertiesTextEdit DisplayFormatString="yyyy/MM/dd"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Last Purchase Date" FieldName="LastPurchaseDate" VisibleIndex="19"> <PropertiesTextEdit DisplayFormatString="yyyy/MM/dd"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Current Quantity" FieldName="Quantity" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Total Net Sales" Name="NetSales" VisibleIndex="6" FieldName="NetSales"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#CCCCCC"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Total Cost Sales" FieldName="NetCostSales" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Profit Value" FieldName="ProfitValue" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#FFFF99"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Profit Percentage" FieldName="ProfitPercentage" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <%-- <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="DeptAmount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CreditAmount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CurrentDeptBalance" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CrrentCreditBalance" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="Start_BalanceDept" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="Start_BalanceCredit" SummaryType="Sum" /> </TotalSummary>--%> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="Quantity" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetSales" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetCostSales" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="ProfitValue" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="ProfitPercentage" SummaryType="Average" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetSalesCount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetPurchesCount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="SalesPurchesDiff" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetPurches" SummaryType="Sum" /> </TotalSummary> <GroupSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="NetSales" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="ProfitValue" SummaryType="Sum" /> </GroupSummary> <Styles> <Table HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </Table> <Row HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#CCFFFF" Font-Bold="True"> </Row> <DetailRow HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </DetailRow> <GroupFooter HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </GroupFooter> </Styles> </dx:ASPxGridView> <div class="panel-heading"> <div align="center" > <dx:ASPxRoundPanel ID="ASPxRoundPanel1" runat="server" ShowCollapseButton="true" Width="200px" HeaderText="Export Data" HorizontalAlign="Center"> <HeaderStyle Font-Bold="True" Font-Size="Small" ForeColor="#6600FF" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <PanelCollection> <dx:PanelContent runat="server"> <table class="nav-justified"> <tr> <td> <asp:ImageButton ID="exl" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" runat="server" OnClick="exl_Click" /></td> <td><asp:ImageButton ID="word" ImageUrl="~/assets/export/word.png" Height="40px" Width="40px" runat="server" OnClick="word_Click" /></td> <td><asp:ImageButton ID="pdf" ImageUrl="~/assets/export/pdf.png" Height="40px" Width="40px" runat="server" OnClick="pdf_Click" /></td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxRoundPanel> </div> </div> </div> </div> </asp:Content>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.09 |
proxy
|
phpinfo
|
Settings