Guest User

designerpaidstatus.php

a guest
Jan 4th, 2017
64
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. require_once 'class.user.php';
  3.  
  4.  
  5. $conVar=mysqli_connect($host,$user,$password,$dbName);
  6. $deliverydDate=date('Y-m-d');
  7. $user_homes = new USER();
  8. $id=$_GET['designer_id'];
  9.  
  10.  
  11.  
  12.  
  13. require_once '../../app/Mage.php';
  14. Mage::app();
  15. $order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id',array('like' => '%'.$id.'%')
  16.  
  17.  
  18. );
  19.  
  20. $htmltext='';
  21. //$htmltext.="<select id='designerpaidstatus.php' name='designerorder_id' onchange='getProductDetail(this.value)' class='selectvalue'><option value=''>Select Order</option>";
  22. $htmltext.="<option value=''>Select Order</option>";
  23. $data=array();
  24. foreach ($order as $orderData)
  25. {
  26.  
  27. /* for order hide */
  28.  
  29. $sqlq1="select dproduct_id from order_details where designer_id='".$id."' and designerorder_id='".$orderData->getIncrementId()."'";
  30. $sqlq=mysqli_query($conVar,$sqlq1);
  31.  
  32. while($rdata=mysqli_fetch_assoc($sqlq))
  33. {
  34. $data[]=$rdata['dproduct_id'];
  35.  
  36. }
  37.  
  38.  
  39. //$orderitems=$orderData['dproduct_id'];
  40. $orderitems=$orderData->getData('dproduct_id');
  41. $oitem=explode(',',$orderitems);
  42. $finalValue=$orderData->getIncrementId()."-".$orderitemsarray[$k];
  43. $result=array_diff($oitem,$data);
  44. $result1=implode(',',$result);
  45.  
  46. if(count($result)>1){
  47.  
  48. $htmltext=$htmltext.'<option class="'.$result1.'" name="'.$result1.'" value="'.$orderData->getIncrementId().'">'. $orderData->getIncrementId().'</option>';
  49.  
  50.  
  51. /* for order hide end */
  52.  
  53. /* for designer hide */
  54.  
  55.  
  56.  
  57. /* for designer end */
  58. } }
  59.  
  60. $htmltext=$htmltext."</select>";
  61. echo $htmltext;exit;
  62. ?>
RAW Paste Data Copied