001.<!-- page content -->
002.<div class="right_col" role="main">
003. <div class="row">
004. <div class="col-md-12 col-sm-12 col-xs-12">
005. <div class="x_panel">
006. <div class="x_title">
007. <h2>Search Product Category<small><!--different form elements--></small></h2>
008. <ul class="nav navbar-right panel_toolbox">
009. <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
010. <!--<li class="dropdown">
011. <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
012. <ul class="dropdown-menu" role="menu">
013. <li><a href="#">Settings 1</a></li>
014. <li><a href="#">Settings 2</a></li>
015. </ul>
016. </li>-->
017. <!--<li><a class="close-link"><i class="fa fa-close"></i></a></li>-->
018. </ul>
019. <div class="clearfix"></div>
020. </div>
021. <div class="x_content">
022. <br />
023. <form id="search" action="product_category_query.php" method="post" data-parsley-validate class="form-horizontal form-label-left">
024. <div class="form-group">
025. <label class="control-label col-md-3 col-sm-6 col-xs-12" >Product Categroy </label>
026. <div class="col-md-6 col-sm-6 col-xs-12">
027. <input type="text" id="category_name" name="category_name" class="form-control col-md-7 col-xs-12" value="<?php if(isset($_REQUEST["category_name"])){echo $_REQUEST["category_name"];}?>">
028. </div>
029. </div>
030. <div class="form-group">
031. <label class="control-label col-md-3 col-sm-6 col-xs-12">Status </label>
032. <div class="col-md-6 col-sm-6 col-xs-12">
033. <select class="form-control" id="status" name="status">
034. <option value="">-- ทั้งหมด --</option>
035. <?php echo config("status", $_REQUEST["status"], $conn);?>
036. </select>
037. </div>
038. </div>
039. <!--<div class="form-group">
040. <label class="control-label col-md-3 col-sm-6 col-xs-12">Sort By </label>
041. <div class="col-md-6 col-sm-6 col-xs-12">
042. <select class="form-control" id="order_by" name="order_by">
043. <?php echo order_by_category($_REQUEST["order_by"]);?>
044. </select>
045. </div>
046. </div>-->
047. <input type="hidden" id="order_by" name="order_by" value="no_id">
048. <div class="form-group">
049. <label class="control-label col-md-3 col-sm-6 col-xs-12">Rows Per Page </label>
050. <div class="col-md-6 col-sm-6 col-xs-12">
051. <select class="form-control" id="rows_per_page" name="rows_per_page">
052. <?php echo rows_per_page($_REQUEST["rows_per_page"]);?>
053. </select>
054. </div>
055. </div>
056. <div class="ln_solid"></div>
057. <div class="form-group">
058. <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
059. <input type="hidden" name="mode" value="listing">
060. <!--<input type="reset" class="btn btn-primary" value="Reset">-->
061. <input type="submit" class="btn btn-success" value="Search">
062. <input type="button" class="btn btn-danger" onclick="add();" value="Add">
063. </div>
064. </div>
065. </form>
066. </div>
067. </div>
068. </div>
069. <div class="col-md-12 col-sm-12 col-xs-12">
070. <div class="x_panel">
071. <div class="x_title">
072. <h2>Listing Product Category <small><!--Custom design--></small></h2>
073. <ul class="nav navbar-right panel_toolbox">
074. <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
075. <!--<li class="dropdown">
076. <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
077. <ul class="dropdown-menu" role="menu">
078. <li><a href="#">Settings 1</a></li>
079. <li><a href="#">Settings 2</a></li>
080. </ul>
081. </li>
082. <li><a class="close-link"><i class="fa fa-close"></i></a></li>-->
083. </ul>
084. <div class="clearfix"></div>
085. </div>
086.
087. <div class="x_content">
088. <!--<p>Add class <code>bulk_action</code> to table for bulk actions options on row select</p>-->
089. <table class="table table-striped responsive-utilities jambo_table bulk_action">
090. <thead>
091. <tr class="headings">
092. <th class="column-title no-link last"><span class="nobr">Action</span></th>
093. <th class="column-title">Row </th>
094. <th class="column-title">Product Category </th>
095. <th class="column-title">Status </th>
096. <th class="column-title">Remark </th>
097. <!--<th class="bulk-actions" colspan="7"><a class="antoo" style="color:#fff; font-weight:500;">Bulk Actions ( <span class="action-cnt"> </span> ) <i class="fa fa-chevron-down"></i></a></th>-->
098. </tr>
099. </thead>
100. <tbody>
101. <?php $row=$Page_Start;?>
102. <?php
103. while($r=mysqli_fetch_array($objQuery)){$row++;?>
104. <?php if($row%2==0)
105. {
106. $class = "even pointer";
107. }
108. else
109. {
110. $class = "odd pointer";
111. }?>
112. <tr class=<?php echo $class;?>>
113. <td class=" last">
114. <a href="product_category_query.php?mode=edit&no_id=<?php echo $r["no_id"];?>#edit" class="btn btn-info btn-xs"><i class="fa fa-pencil"></i> Edit</a>
115. <a href="product_category_query.php?mode=deleted&no_id=<?php echo $r["no_id"];?>&category_name=<?php echo $_REQUEST["category_name"];?>&status=<?php echo $_REQUEST["status"];?>&order_by=<?php echo $_REQUEST["order_by"];?>&rows_per_page=<?php echo $_REQUEST["rows_per_page"];?>&Page=<?php echo $Prev_Page;?>" title="Delete" onclick="return check_delete();" class="btn btn-danger btn-xs"><i class="fa fa-trash-o"></i> Delete</a>
116. </td>
117. <td class=" "><?php echo $row;?></td>
118. <td class=" "><?php echo $r["category_name"];?></td>
119. <td class=" "><?php echo config_name("status", $r["status"], $conn);?></td>
120. <td class=" "><?php echo $r["remark"];?></td>
121. </tr>
122. <?php }?>
123. </tbody>
124. </table>
125. <code>Totals <?= $Num_Rows;?> rows : <?=$Num_Pages;?> page :
126. <?php if($Prev_Page){
127. echo " <a href='$_SERVER[SCRIPT_NAME]?mode=listing&category_name=$_REQUEST[category_name]&status=$_REQUEST[status]&order_by=$_REQUEST[order_by]&rows_per_page=$_REQUEST[rows_per_page]&Page=$Prev_Page'><< Back</a> ";
128. }
129. for($i=1; $i<=$Num_Pages; $i++){
130. if($i != $Page){
131. echo "[ <a href='$_SERVER[SCRIPT_NAME]?mode=listing&category_name=$_REQUEST[category_name]&status=$_REQUEST[status]&order_by=$_REQUEST[order_by]&rows_per_page=$_REQUEST[rows_per_page]&Page=$i'>$i</a> ]";
132. }else{
133. echo "<b> $i </b>";
134. }
135. }
136. if($Page!=$Num_Pages){
137. echo " <a href ='$_SERVER[SCRIPT_NAME]?mode=listing&category_name=$_REQUEST[category_name]&status=$_REQUEST[status]&order_by=$_REQUEST[order_by]&rows_per_page=$_REQUEST[rows_per_page]&Page=$Next_Page'>Next>></a> ";
138. }?>
139. </code>
140. </div>
141. </div>
142. </div>
143. </div>
144.</div>
