Package net.virtuemart.www.VM_SQLQueries

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest

405
406
407
408
409
410
411
412
413
414
415
    }

    public int getOrderID (String note) throws RemoteException {
        String query = "SELECT order_id FROM #__{vm}_orders ";
        SQLRequest sqlr = new SQLRequest(wsLogin, query);

        try {
//            queriesProxy.executeSQLUpdateQuery(sqlr);
            SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
            if (results.length == 1) {
View Full Code Here
451
452
453
454
455
456
457
458
459
460
461
462
        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'C', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'C' WHERE order_id = "+orderID+";";


        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
486
        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'S', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'S' WHERE order_id = "+orderID+" AND order_status = 'C';";


        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
       SQLResult[] results;
        if (dateReturn!=null) {
            dateR = df.format(dateReturn);
            String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'D', '"+dateR+"', '0', 'Date return'); ";
            SQLRequest sqlr = new SQLRequest(wsLogin,query);

            try {
               results = queriesProxy.executeSQLQuery(sqlr);
           
            } catch (IOException ioe) {
                ioe.printStackTrace();
                returnvalue = false;
            }

        }


        String query2 = " UPDATE #__{vm}_order_history SET date_added = '"+dateC+"' WHERE order_status_code = 'P' AND order_status_history_id ="+orderID+"; ";
        String query3 = " UPDATE #__{vm}_orders SET cdate=UNIX_TIMESTAMP('"+dateC+"') WHERE order_id = "+orderID+";";

        SQLRequest sqlr2 = new SQLRequest(wsLogin,query2);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {

           results = queriesProxy.executeSQLQuery(sqlr2);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
407
408
409
410
411
412
413
414
415
416
417
    }

    public int getOrderID (String note) throws RemoteException {
        String query = "SELECT order_id FROM #__{vm}_orders ";
        SQLRequest sqlr = new SQLRequest(wsLogin, query);

        try {
//            queriesProxy.executeSQLUpdateQuery(sqlr);
            SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
            if (results.length == 1) {
View Full Code Here
453
454
455
456
457
458
459
460
461
462
463
464
        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'C', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'C' WHERE order_id = "+orderID+";";


        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
477
478
479
480
481
482
483
484
485
486
487
488
        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'S', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'S' WHERE order_id = "+orderID+" AND order_status = 'C';";


        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
       SQLResult[] results;
        if (dateReturn!=null) {
            dateR = df.format(dateReturn);
            String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'D', '"+dateR+"', '0', 'Date return'); ";
            SQLRequest sqlr = new SQLRequest(wsLogin,query);

            try {
               results = queriesProxy.executeSQLQuery(sqlr);
           
            } catch (IOException ioe) {
                ioe.printStackTrace();
                returnvalue = false;
            }

        }


        String query2 = " UPDATE #__{vm}_order_history SET date_added = '"+dateC+"' WHERE order_status_code = 'P' AND order_status_history_id ="+orderID+"; ";
        String query3 = " UPDATE #__{vm}_orders SET cdate=UNIX_TIMESTAMP('"+dateC+"') WHERE order_id = "+orderID+";";

        SQLRequest sqlr2 = new SQLRequest(wsLogin,query2);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);

        try {

           results = queriesProxy.executeSQLQuery(sqlr2);
           results = queriesProxy.executeSQLQuery(sqlr3);
View Full Code Here
TOP

Related Classes of net.virtuemart.www.VM_SQLQueries.SQLRequest

  • net.virtuemart.www.possync.ExternalSalesHelper
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.