fulllllllllll

function getDesignerCollection()
	{
	global $is_admin;
	$user_home = new USER();
	require_once '../../app/Mage.php';

	Mage::app();

	$stmts = $user_home->runQuery("SELECT * FROM tbl_users WHERE userID=:uid");
	$stmts->execute(array(
		":uid" => $_SESSION['userSession']
	));
	$rows = $stmts->fetch(PDO::FETCH_ASSOC);

	/* date search */
	if (isset($_POST['post_at']) && $_POST['post_at'] != '')
		{
		$orderFromDate = $_POST['post_at'] . " 00:00:00 ";

		}
	  else
		{
		$orderFromDate = '';
		}

	if (isset($_POST['post_at_to_date']) && $_POST['post_at_to_date'] != '')
		{
		$orderToDate = $_POST['post_at_to_date'] . "    23:59:59  ";

		}
	  else
		{
		$orderToDate = '';
		}
   /* date search end*/

	$accountType = $rows['type'];
	if ($accountType == "admin")
		{
		$is_admin = true;
		$order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
			'nin' => '0'
		));
		if ($orderFromDate != '') $order->addFieldToFilter('created_at', array(
			'gteq' => $orderFromDate
		));
		if ($orderToDate != '') $order->addFieldToFilter('created_at', array(
			'lteq' => $orderToDate
		));
		}
	  else
		{
		$order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
			'like' => '%' . $_SESSION['userSession'] . '%'
		));
		if ($orderFromDate != '') $order->addFieldToFilter('created_at', array(
			'gteq' => $orderFromDate
		));
		if ($orderToDate != '') $order->addFieldToFilter('created_at', array(
			'lteq' => $orderToDate
		));
		}

	$i = 0;

	foreach($order as $orderData)
{
$k = 0;
$orderitems = $orderData['dproduct_id'];
$orderitemsarray = explode(",", $orderitems);

$oDate = new DateTime($orderData['created_at']);
$sDate = $oDate->format("M d, Y");

while ($k < count($orderitemsarray))
{

if ($orderitemsarray[$k] != '0')
{
$stmtorders = $user_home->runQuery("SELECT * FROM order_details");
$stmtorders->execute(array(":dorder_id" => $orderData['entity_id']));
$roworders = $stmtorders->fetch(PDO::FETCH_ASSOC);


if($data['type']=="admin")continue;

if($data['dpaid_status']=='P'){$dorderStatus='Paid';}
if($data['dpaid_status']=='U'){$dorderStatus='Unpaid';}
if($data['dpaid_status']=='R'){$dorderStatus='Returned';}
if($data['dpaid_status']==''){$dpaid_status='';}

if ($roworders[

'dproduct_id'] == '')
{
$dorderStatus = "Unpaid";
}
else
{
$dorderStatus = $roworders['dpaid_status'];
}

if ($roworders['dproduct_id'] == '')
{
$commission = "comm";
}
else
{
$commission = $roworders['commission'];
}

$productdetail = Mage::getModel('catalog/product')->load($orderitemsarray[$k]);
$designer_id = $productdetail->getDesignerID() ;

if($accountType == "admin"){
$designerName = getDesignerName($productdetail->getDesignerID()) . " -(" . $productdetail->getDesignerID() . ")";
$responce[] = array(
$orderData->getIncrementId() ,
$orderData->getIncrementId() ,
$orderitemsarray[$k],
$productdetail->getName() ,
$designerName,
$orderData['status'],
$orderData['grand_total'],
$orderData['customer_email'],
$commission,
$dorderStatus,
$sDate
);

}

else
{

if( $designer_id== $_SESSION['userSession'] ){
$designerName = getDesignerName($productdetail->getDesignerID()) . " -(" . $productdetail->getDesignerID() . ")";
$responce[] = array(
$orderData->getIncrementId() ,
$orderData->getIncrementId() ,
$orderitemsarray[$k],
$productdetail->getName() ,
$designerName,
$orderData['status'],
$orderData['grand_total'],
$orderData['customer_email'],
$commission,
$dorderStatus,
$sDate
);
}
}
}

$k++;
$i++;
}
}

	echo json_encode($responce);
	}