<?php
	include 'home.php';

$is_admin = false;

$user_home = new USER();
//$orderFromDate = '';
//$orderToDate = '';

/* to show selected date */

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 = '';
}
/* to show selected date */

//  $newPostDate = date("Y-m-d h:i:s", strtotime($postToDate));

function getDesignerName($designerId)
{
	$user_home = new USER();
	if (!$user_home->is_logged_in())
	{
		$user_home->redirect('index.php');
	}

	$stmt = $user_home->runQuery("SELECT * FROM tbl_users WHERE userID=:uid");
	$stmt->execute(array(
		":uid" => $designerId
));
	$row = $stmt->fetch(PDO::FETCH_ASSOC);
	return $row['name'];
}

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);

	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 = '';
	}



	$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'] . '%'
	))






// ->addAttributeToSelect('updated_at')  //nothing
	->addAttributeToSelect('dproduct_id')
//->addAttributeToSelect('product_id')
//->addAttributeToSelect('product_name')
//->addAttributeToSelect('name')
//->addAttributeToSelect('productdetail')
//->addAttributeToSelect('designer_id')
//->addAttributeToSelect('dorder_id')
//->addAttributeToSelect('designerorder_id')
//->addAttributeToSelect('entity_id')
	->addAttributeToSelect('created_at')
	->addAttributeToSelect('increment_id')  // order id
	->addAttributeToSelect('status')
	->addAttributeToSelect('grand_total')
	->addAttributeToSelect('customer_email')
	->addAttributeToSelect('state');
//unset($orderitems['designer_id']);

		/*
		 ->addAttributeToSelect('created_at')
		 ->addAttributeToSelect('entity_id')
		 ->addAttributeToSelect('product_id')
		 ->addAttributeToSelect('product_name')
		 ->addAttributeToSelect('status')
		 ->addAttributeToSelect('grand_total')
		 ->addAttributeToSelect('customer_email')
		 ->addAttributeToSelect('paid_status')
		 ->addAttributeToSelect('commission');
		 */


		if ($orderFromDate != '') $order->addFieldToFilter('created_at', array(
			'gteq' => $orderFromDate
	));
		if ($orderToDate != '') $order->addFieldToFilter('created_at', array(
			'lteq' => $orderToDate
	));
	}

	$i = 0;
	foreach($order as $orderData)
	{
		$orderitems = $orderData['dproduct_id'];
		$orderitemsarray = explode(",", $orderitems);
		$k = 0;
		$oDate = new DateTime($orderData['created_at']);
		$sDate = $oDate->format("Y-m-d");
		while ($k < count($orderitemsarray))
		{
			if ($orderitemsarray[$k] != '0')
			{
				$stmtorders = $user_home->runQuery("SELECT * FROM order_details WHERE designerorder_id=:designerorder_id");
				$stmtorders->execute(array(
					":designerorder_id" => $orderData['entity_id']
			));
				$roworders = $stmtorders->fetch(PDO::FETCH_ASSOC);
				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]);
				$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);

}

?>
<head>

<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
	<script src= "http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.js"></script>

	<link rel="stylesheet" href="assets/css/jquery-ui.css">
	<script src="assets/js/jquery-1.10.2.js"></script>
	<script src="assets/js/jquery-ui.js"></script>
	<script src="assets/js/jquery-ui.js"></script>


	<script type="text/javascript" language="javascript" src="http://sbdev2.kidsdial.com:81/php/site6/bootstrap/js/outthinking/gt_msg_en.js"></script>

	<script type="text/javascript" language="javascript" src="http://sbdev2.kidsdial.com:81/php/site6/bootstrap/js/outthinking/gt_grid_all.js"></script>


	<link rel="stylesheet" type="text/css" href="http://sbdev2.kidsdial.com:81/php/site6/bootstrap/css/outthinking/css/skinstyle.css"/>
	<link rel="stylesheet" type="text/css" href="http://sbdev2.kidsdial.com:81/php/site6/bootstrap/css/outthinking/css/gt_grid.css"/>



	</head>


	<h2> Designer List</h2>

<div>
<div class="delete_grid" >

	<form>
	Search:
<select id="f_value2">
	<option value="entity_id">Order Id</option>
<option value="designer_id">Designer Id</option>
</select>
<input type="text" onkeyup="doFilter()" value="" id="f_value1" >
	<input type="reset" value="Reset" onClick="window.location.reload()">
	</form>

	<br/>


	<form name="frmSearch" method="post" action="">
	<input type="text" placeholder="From Date" id="post_at" value="<?php

if ($orderFromDate != '')
{
	echo $orderFromDate;
} ?>" name="post_at"  />
<input type="text" placeholder="To Date" id="post_at_to_date" value="<?php

if ($orderToDate != '')
{
	echo $orderToDate;
} ?>" name="post_at_to_date"  />
<input type="submit" name="search" value="search" id="searchButton">



	<input type="button" value="Reset" id="clear-dates">
	</form>

	<br/>


	<div class="delete_grid_select">
	<form  action='' method="post" id="package_form" enctype="multipart/form-data">
	<input type="hidden" name="delete_package_id" id="delete_package_id" value=""/>
	Action:
<select name="massaction" id="massaction">
	<option value="">Select</option>
	<option value="paid">Paid</option>
	</select>
	<input type="button" value="Submit" id="delete-grid-button" onclick="massAction()" />
	</form>
	</div>


	</div>
	</div>
	<div id="myGrid"></div>

	<script type="text/javascript">

var __TEST_DATA__=eval('<?php
echo getDesignerCollection(); ?>');
var grid_demo_id = "myGrid" ;
var dsOption= {
	fields :[
		{name : 'entity_id'  },
		{name : 'entity_id'  },
		{name : 'product_id'  },
		{name : 'product_name'},
		{name : 'designer_id'  },
		{name : 'status'  },
		{name : 'grand_total'  },
		{name : 'customer_email'  },
		{name : 'commission'  },
		{name : 'dpaid_status'  },
		{name : 'created_at'},
	],
	recordType : 'array',
	data : __TEST_DATA__
}


function my_renderId(value ,record,columnObj,grid,colNo,rowNo)
{
	var no= record[columnObj.fieldIndex];

	return "<input type='checkbox' value='"+record[0]+"' name='userID'/>";
}

var colsOption = [
	{id: 'entity_id' , header: "Order Id" , width :"15",renderer : my_renderId},
	{id: 'created_at' , header: "Order Date" , width :"120"},
	{id: 'entity_id' , header: "Order Id" , width :"75"},
	{id: 'product_id' , header: "Product Id" , width :"70"},
	{id: 'product_name' , header: "Product Name" , width :"200"},
<?php if (!$is_admin) echo "{id: 'designer_id' , header: "Designer" , width :"110"},"; ?>
	{id: 'status' , header: "Order Status" , width :"100"},
	{id: 'grand_total' , header: " Order Amount" , width :"120"},
	{id: 'customer_email' , header: "User Email" , width :"150"},
	{id: 'dpaid_status' , header: "Paid status" , width :"80"},
	{id: 'commission' , header: "commission" , width :"80"}

];

var gridOption={
	id : grid_demo_id,

	// height: "285",  //"100%", // 330,

	pageSize:20,
	pageSizeList : [5,10,15,20],
	container : 'myGrid',
	replaceContainer : true,
	dataset : dsOption ,
	columns : colsOption ,
	toolbarContent : 'nav goto | pagesize | filter state | sortable | search',
	onRowClick:function(value, record , cell, row,  colNO, rowNO,columnObj,grid){
	}
};
var mygrid=new Sigma.Grid(gridOption);
Sigma.Util.onLoad( Sigma.Grid.render(mygrid) );




function doFilter() {
	var filterInfo=[
		{
			fieldName : $('select[id=f_value2]').val(),
			logic : "startWith",
			value : Sigma.Util.getValue("f_value1")
		},
		{
			fieldName : Sigma.Util.getValue("f_fieldName12"),
			logic : "greatEqual",
			value : Sigma.Util.getValue("f_value12")
		}
	]
	var grid=Sigma.$grid("myGrid");
	var rowNOs=grid.applyFilter(filterInfo);
}
function doUnfilter(){
	var grid=Sigma.$grid("myGrid1");
	var rowNOs=grid.unfilterGrid();

}


function doUnfilter(){
	var grid=Sigma.$grid("myGrid1");
	var rowNOs=grid.unfilterGrid();

}

function massAction()
{
	var e=document.getElementById("massaction");
	var strUser = e.options[e.selectedIndex].value;

	switch(strUser)
	{
		case "paid":
			retactiveVal=confirm("Are you sure want to Change the Paid status");
			if( retactiveVal == true )
			{
				massdesignerpaidstatus();
				return true;
			}else{
				return false;
			}

			return false;
	}
}

function massdesignerpaidstatus()
{

	var checkboxes = document.getElementsByName('userID');
	var vals = "";
	for (var i=0, n=checkboxes.length;i<n;i++) {
		if (checkboxes[i].checked)
		{
			vals += ","+checkboxes[i].value;
		}
	}
	if(vals=='')
	{
		alert("No record selected");
		return false;
	}
	if (vals) vals = vals.substring(1);
	document.getElementsByName('delete_package_id').value=vals;
	var url="http://sbdev2.kidsdial.com:81/php/site6/designerpaidstatus.php?order_id="+vals+"&designer_dpaid_status='Paid'";
	var request = jQuery.ajax( {
		url: url ,
		type: 'POST',
	} );

	request.done( function (result)
	{
		location.reload();

	} );
	request.fail( function ( error )
	{
		console.dir(error);
	} );

}

<!-- Date Picker -->


jQuery.datepicker.setDefaults({
	showOn: "button",
	buttonImage: "assets/img/datepicker.png",
	buttonText: "Date Picker",
	buttonImageOnly: true,
	dateFormat: 'yy-mm-dd'
});
$(function() {
	$("#post_at").datepicker();
	$("#post_at_to_date").datepicker();
});


<!-- reset date -->
var $dates = $('#post_at, #post_at_to_date').datepicker();


$("#clear-dates").click(function(){
	location.reload();
	$("#post_at").removeAttr('value');
	$("#post_at_to_date").removeAttr('value');
	if(!$("#post_at_to_date").val()) {
		$( "#searchButton" ).trigger( "click" );
	}
});

</script>