agws_secupay_flex/version/408/adminmenu/inc/agws_secupay_flex_overview_inc.php
/**
 * secupay Payment Module
 *
 * Copyright (c) 2018 secupay AG
 *
 * @category  Payment
 * @author    secupay AG
 * @copyright 2018, secupay AG
 *
 * Description:
 * JTL Plugin for integration of secupay AG payment services
 */
secupay Payment Module
Copyright (c) 2018 secupay AG

@category  Payment
@author    secupay AG
@copyright 2018, secupay AG

JTL Plugin for integration of secupay AG payment services
secupay Payment Module Copyright ( c ) 2018 secupay AG @category Payment @author secupay AG @copyright 2018 secupay AG JTL Plugin for integration of secupay AG payment services
function gibBestellungsUebersicht($cLimitSQL, $cSuchFilter, $cSecZA)
{
    $oPlugin = Plugin::getPluginById('agws_secupay_flex');
    $helper = agwsPluginHelperSecupay::getInstance($oPlugin);
    $oBestellung_arr = array();
    $cSuchFilterSQL = " WHERE kBestellung IN(" . $cSecZA. ")";
    if (strlen($cSuchFilter)) {
        $cSuchFilterSQL .= " AND cBestellNr LIKE '%" . $cSuchFilter . "%'";
    }
    $sql = "SELECT kBestellung FROM tbestellung" . $cSuchFilterSQL . " ORDER BY dErstellt DESC" . $cLimitSQL;
    ($helper->isShop4()) ?
            $oBestellungToday_arr = Shop::DB()->executeQuery($sql, 2):
            $oBestellungToday_arr = $GLOBALS['DB']->executeQuery($sql, 2);
    if (is_array($oBestellungToday_arr) && count($oBestellungToday_arr) > 0) {
        foreach ($oBestellungToday_arr as $oBestellungToday) {
            if (isset($oBestellungToday->kBestellung) && $oBestellungToday->kBestellung > 0) {
                $oBestellung = new Bestellung($oBestellungToday->kBestellung);
                $oBestellung->fuelleBestellung(1, 0, false);
                $sql = "SELECT * FROM xplugin_agws_secupay_flex_tsyslog WHERE kBestellung = ".$oBestellungToday->kBestellung." ORDER BY kLogId DESC";
                ($helper->isShop4()) ?
                        $oBestellungSecLog_arr = Shop::DB()->executeQuery($sql, 8):
                        $oBestellungSecLog_arr = $GLOBALS['DB']->executeQuery("$sql", 8);
                $oBestellung->agws_seclog_cHash = $oBestellungSecLog_arr['cHash'];
                $oBestellung->agws_seclog_cTACode = $oBestellungSecLog_arr['cTACode'];
                $oBestellung->agws_seclog_kAmountSecupay = $oBestellungSecLog_arr['kAmountSecupay'] / 100;
                $oBestellung->agws_seclog_dSuccDat = $oBestellungSecLog_arr['dSuccDat'];
                $oBestellung->agws_seclog_dPushDat = $oBestellungSecLog_arr['dPushDat'];
                $oBestellung->agws_seclog_dVersandDat = $oBestellungSecLog_arr['dVersandDat'];
                $oBestellung->agws_seclog_cSecupayZA  = $oBestellungSecLog_arr['cSecupayZA'];
                $oBestellung_arr[] = $oBestellung;
            }
        }
    }
    return $oBestellung_arr;
}
function gibBestellungsUebersicht ( $ cLimitSQL , $ cSuchFilter , $ cSecZA ) { $ oPlugin = Plugin :: getPluginById ( 'agws_secupay_flex' ) ; $ helper = agwsPluginHelperSecupay :: getInstance ( $ oPlugin ) ; $ oBestellung_arr = array ( ) ; $ cSuchFilterSQL = "  WHERE kBestellung IN( " . $ cSecZA . " ) " ; if ( strlen ( $ cSuchFilter ) ) { $ cSuchFilterSQL .= "  AND cBestellNr LIKE '% " . $ cSuchFilter . " %' " ; } $ sql = " SELECT kBestellung FROM tbestellung " . $ cSuchFilterSQL . "  ORDER BY dErstellt DESC " . $ cLimitSQL ; ( $ helper -> isShop4 ( ) ) ? $ oBestellungToday_arr = Shop :: DB ( ) -> executeQuery ( $ sql , 2 ) : $ oBestellungToday_arr = $ GLOBALS [ 'DB' ] -> executeQuery ( $ sql , 2 ) ; if ( is_array ( $ oBestellungToday_arr ) && count ( $ oBestellungToday_arr ) > 0 ) { foreach ( $ oBestellungToday_arr as $ oBestellungToday ) { if ( isset ( $ oBestellungToday -> kBestellung ) && $ oBestellungToday -> kBestellung > 0 ) { $ oBestellung = new Bestellung ( $ oBestellungToday -> kBestellung ) ; $ oBestellung -> fuelleBestellung ( 1 , 0 , false ) ; $ sql = " SELECT * FROM xplugin_agws_secupay_flex_tsyslog WHERE kBestellung =  " . $ oBestellungToday -> kBestellung . "  ORDER BY kLogId DESC " ; ( $ helper -> isShop4 ( ) ) ? $ oBestellungSecLog_arr = Shop :: DB ( ) -> executeQuery ( $ sql , 8 ) : $ oBestellungSecLog_arr = $ GLOBALS [ 'DB' ] -> executeQuery ( " $ sql " , 8 ) ; $ oBestellung -> agws_seclog_cHash = $ oBestellungSecLog_arr [ 'cHash' ] ; $ oBestellung -> agws_seclog_cTACode = $ oBestellungSecLog_arr [ 'cTACode' ] ; $ oBestellung -> agws_seclog_kAmountSecupay = $ oBestellungSecLog_arr [ 'kAmountSecupay' ] / 100 ; $ oBestellung -> agws_seclog_dSuccDat = $ oBestellungSecLog_arr [ 'dSuccDat' ] ; $ oBestellung -> agws_seclog_dPushDat = $ oBestellungSecLog_arr [ 'dPushDat' ] ; $ oBestellung -> agws_seclog_dVersandDat = $ oBestellungSecLog_arr [ 'dVersandDat' ] ; $ oBestellung -> agws_seclog_cSecupayZA = $ oBestellungSecLog_arr [ 'cSecupayZA' ] ; $ oBestellung_arr [ ] = $ oBestellung ; } } } return $ oBestellung_arr ; }
secupay Payment Module
 Copyright (c) 2018 secupay AG
secupay Payment Module Copyright ( c ) 2018 secupay AG