Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.78 KB | None | 0 0
  1. function getDesignerCollection()
  2. {
  3.  
  4. $user_home = new USER();
  5. require_once '../../app/Mage.php';
  6.  
  7. Mage::app();
  8. $stmts = $user_home->runQuery("SELECT * FROM tbl_users WHERE userID=:uid");
  9. $stmts->execute(array(
  10. ":uid" => $_SESSION['userSession']
  11. ));
  12. $rows = $stmts->fetch(PDO::FETCH_ASSOC);
  13.  
  14. $accountType = $rows['type'];
  15. if ($accountType == "admin")
  16. {
  17. $is_admin = true;
  18. $order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
  19. 'nin' => '0'
  20. ));
  21. }
  22. else
  23. {
  24. $order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
  25. 'like' => '%' . $_SESSION['userSession'] . '%'
  26. ));
  27. }
  28.  
  29. $i = 0;
  30. foreach($order as $orderData)
  31. {
  32. $orderitems = $orderData['dproduct_id'];
  33. $orderitemsarray = explode(",", $orderitems);
  34. $k = 0;
  35.  
  36. while ($k < count($orderitemsarray))
  37. {
  38.  
  39. if($data['type']=="admin")continue;
  40.  
  41. if($data['dpaid_status']=='P'){$dpaid_status='Paid';}
  42. if($data['dpaid_status']=='U'){$dpaid_status='Unpaid';}
  43. if($data['dpaid_status']=='R'){$dpaid_status='Returned';}
  44. if($data['dpaid_status']==''){$dpaid_status='';}
  45. if ($orderitemsarray[$k] != '0')
  46. {
  47. $stmtorders = $user_home->runQuery("SELECT * FROM order_details WHERE designerorder_id=:designerorder_id");
  48. $stmtorders->execute(array(
  49. ":designerorder_id" => $orderData['entity_id']
  50. ));
  51. $roworders = $stmtorders->fetch(PDO::FETCH_ASSOC);
  52. if ($roworders['dproduct_id'] == '')
  53. {
  54. $dorderStatus = "Unpaid";
  55. }
  56. else
  57. {
  58. $dorderStatus = $roworders['dpaid_status'];
  59. }
  60.  
  61. $productdetail = Mage::getModel('catalog/product')->load($orderitemsarray[$k]);
  62. $designerName = getDesignerName($productdetail->getDesignerID()) . " -(" . $productdetail->getDesignerID() . ")";
  63. $responce[] = array(
  64. $orderData->getIncrementId() ,
  65. $orderData->getIncrementId() ,
  66. $orderitemsarray[$k],
  67. $productdetail->getName() ,
  68. $designerName,
  69. $orderData['status'],
  70. $orderData['grand_total'],
  71. $orderData['customer_email'],
  72. $commission,
  73. $dorderStatus,
  74. $sDate
  75. );
  76. }
  77.  
  78. $k++;
  79. $i++;
  80. }
  81. }
  82. echo json_encode($responce);
  83. }
  84.  
  85. <form action='' method="post" enctype="multipart/form-data">
  86. <input type="hidden" name="delete_package_id" id="delete_package_id" value=""/>
  87. Action:
  88.  
  89. <select name="massaction" id="massaction">
  90. <option value="">Select</option>
  91. <option value="P">Paid</option>
  92. <option value="U">Unpaid</option>
  93. <option value="R">Returned</option>
  94. </select>
  95.  
  96. <input type="button" value="Submit" id="delete-grid-button" onclick="massAction()" />
  97. </form>
  98.  
  99. function massAction()
  100. {
  101. var e=document.getElementById("massaction");
  102. var strUser = e.options[e.selectedIndex].value;
  103.  
  104. massStatusChangeVerified(strUser);
  105.  
  106. }
  107.  
  108.  
  109. function massStatusChangeVerified(status)
  110. {
  111. var checkboxes = document.getElementsByName('dorder_id');
  112. var vals = "";
  113. for (var i=0, n=checkboxes.length;i<n;i++) {
  114. if (checkboxes[i].checked)
  115. {
  116. vals += ","+checkboxes[i].value;
  117. }
  118. }
  119. if(vals=='')
  120. {
  121. alert("No record selected");
  122. return false;
  123. }
  124. retactiveVal=confirm("Are you sure want to Change the status");
  125. if( retactiveVal == true )
  126. {
  127. if (vals) vals = vals.substring(1);
  128. document.getElementsByName('delete_package_id').value=vals;
  129. var url="http://sbdev2.kidsdial.com:81/php/site6/update_order_status.php?designer_id="+vals+"&order_status="+status;
  130. var request = jQuery.ajax( {
  131. url: url ,
  132. type: 'POST',
  133. } );
  134.  
  135. request.done( function (result)
  136. {
  137. document.getElementById('msgresult').style.display="block";
  138. var explode = function(){
  139. location.reload();
  140. };
  141. setTimeout(explode, 2000);
  142.  
  143.  
  144. } );
  145. request.fail( function ( error )
  146. {
  147. console.dir(error);
  148. } );return true;
  149. }else{
  150. return false;
  151. }
  152. }
  153.  
  154. if( isset($_GET['order_status']) && !empty($_GET['order_status']) && $_GET['order_status']!="" )
  155. { $staus=$_GET['order_status']; }else{ $staus="";}
  156.  
  157. if( isset($_GET['designer_id']) && !empty($_GET['designer_id']) && $_GET['designer_id']!="" )
  158. { $allCheckedBoxes=$_GET['designer_id']; }
  159. else{ $allCheckedBoxes="";}
  160. $ArrallCheckedBoxes=explode(",",$allCheckedBoxes);
  161. if(isset($conVar) && !empty($conVar) && $conVar!=""){
  162. foreach($ArrallCheckedBoxes as $tempBoxes){
  163. $sqlQueryToUpdate=" UPDATE order_details SET dpaid_status = '".$staus."' WHERE userID = '".$tempBoxes."' ;";
  164. $sucessFlag=mysqli_query($conVar,$sqlQueryToUpdate);
  165. if($sucessFlag==TRUE){
  166. echo "Records Updated Sucessfully.";
  167. }else{
  168. echo " Record already Updated.";
  169. }
  170. }
  171. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement