Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getDesignerCollection()
- {
- $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);
- $accountType = $rows['type'];
- if ($accountType == "admin")
- {
- $is_admin = true;
- $order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
- 'nin' => '0'
- ));
- }
- else
- {
- $order = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('designer_id', array(
- 'like' => '%' . $_SESSION['userSession'] . '%'
- ));
- }
- $i = 0;
- foreach($order as $orderData)
- {
- $orderitems = $orderData['dproduct_id'];
- $orderitemsarray = explode(",", $orderitems);
- $k = 0;
- while ($k < count($orderitemsarray))
- {
- if($data['type']=="admin")continue;
- if($data['dpaid_status']=='P'){$dpaid_status='Paid';}
- if($data['dpaid_status']=='U'){$dpaid_status='Unpaid';}
- if($data['dpaid_status']=='R'){$dpaid_status='Returned';}
- if($data['dpaid_status']==''){$dpaid_status='';}
- 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'];
- }
- $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);
- }
- <form action='' method="post" 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="P">Paid</option>
- <option value="U">Unpaid</option>
- <option value="R">Returned</option>
- </select>
- <input type="button" value="Submit" id="delete-grid-button" onclick="massAction()" />
- </form>
- function massAction()
- {
- var e=document.getElementById("massaction");
- var strUser = e.options[e.selectedIndex].value;
- massStatusChangeVerified(strUser);
- }
- function massStatusChangeVerified(status)
- {
- var checkboxes = document.getElementsByName('dorder_id');
- 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;
- }
- retactiveVal=confirm("Are you sure want to Change the status");
- if( retactiveVal == true )
- {
- if (vals) vals = vals.substring(1);
- document.getElementsByName('delete_package_id').value=vals;
- var url="http://sbdev2.kidsdial.com:81/php/site6/update_order_status.php?designer_id="+vals+"&order_status="+status;
- var request = jQuery.ajax( {
- url: url ,
- type: 'POST',
- } );
- request.done( function (result)
- {
- document.getElementById('msgresult').style.display="block";
- var explode = function(){
- location.reload();
- };
- setTimeout(explode, 2000);
- } );
- request.fail( function ( error )
- {
- console.dir(error);
- } );return true;
- }else{
- return false;
- }
- }
- if( isset($_GET['order_status']) && !empty($_GET['order_status']) && $_GET['order_status']!="" )
- { $staus=$_GET['order_status']; }else{ $staus="";}
- if( isset($_GET['designer_id']) && !empty($_GET['designer_id']) && $_GET['designer_id']!="" )
- { $allCheckedBoxes=$_GET['designer_id']; }
- else{ $allCheckedBoxes="";}
- $ArrallCheckedBoxes=explode(",",$allCheckedBoxes);
- if(isset($conVar) && !empty($conVar) && $conVar!=""){
- foreach($ArrallCheckedBoxes as $tempBoxes){
- $sqlQueryToUpdate=" UPDATE order_details SET dpaid_status = '".$staus."' WHERE userID = '".$tempBoxes."' ;";
- $sucessFlag=mysqli_query($conVar,$sqlQueryToUpdate);
- if($sucessFlag==TRUE){
- echo "Records Updated Sucessfully.";
- }else{
- echo " Record already Updated.";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement