designerpaidstatus.php

<?php
require_once 'class.user.php';


$conVar=mysqli_connect($host,$user,$password,$dbName);
$deliverydDate=date('Y-m-d');
$user_homes = new USER();
$id=$_GET['designer_id'];




	require_once '../../app/Mage.php';
	Mage::app();
	$order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id',array('like' => '%'.$id.'%')


);

	$htmltext='';
	//$htmltext.="<select id='designerpaidstatus.php' name='designerorder_id' onchange='getProductDetail(this.value)' class='selectvalue'><option value=''>Select Order</option>";
$htmltext.="<option value=''>Select Order</option>";
$data=array();
	foreach ($order as $orderData)
	{

/* for order hide */

 $sqlq1="select dproduct_id from order_details where designer_id='".$id."' and designerorder_id='".$orderData->getIncrementId()."'";
$sqlq=mysqli_query($conVar,$sqlq1);

while($rdata=mysqli_fetch_assoc($sqlq))
{
$data[]=$rdata['dproduct_id'];

}


		//$orderitems=$orderData['dproduct_id'];
		$orderitems=$orderData->getData('dproduct_id');
		$oitem=explode(',',$orderitems);
	       	$finalValue=$orderData->getIncrementId()."-".$orderitemsarray[$k];
$result=array_diff($oitem,$data);
$result1=implode(',',$result);

			if(count($result)>1){

$htmltext=$htmltext.'<option class="'.$result1.'" name="'.$result1.'" value="'.$orderData->getIncrementId().'">'. $orderData->getIncrementId().'</option>';


/* for order hide end */

/* for designer hide */



/* for designer end */
} }

	$htmltext=$htmltext."</select>";
	echo $htmltext;exit;
 ?>