����C %# , #&')*)-0-(0%()(��C (((((((((((((((((((((((((((((((((((((((((((((((((((����"�������@�@�hC��}!���Ѱ��<"� 9iׂIIIHk�+?�c?��*Y�����!�du)b�T�9вU�$8G��I.�澬��D���Sq� q�}.<��Z�l�V!X� *x�-�\����t3i�Ũ�sNv71�ƛ\��z|t�L���$�����*f��kʮ��7�H;���~F%�'3�@�H�q�` 9mOL����/x@ @��G
d�8F�ه��Ka�Kdr�Fh.�]y4 JЛ��]�K�B�E$��$ $ �PR�����G�]��u�i$�$���'! "#031���C/Td=S�Q?���62Ccj{ ����̏d�چ/c�V�`��Wz͈�{Y`�d�h�L �]OB���l���o���mr���n��s-ڗEZ��N�_��1%b���H�ϣ������V�7):�ӷ)�}�~�(�;�!�b1�5K��[E�vϻ>��q.%� ���O���(�c�#x�$�'+��`٥v��v(�����M�"�v��B��.�a ���T�~�ϕ�hy(6nݱl��1yNɓx�������AR�8�rqv1.cS�+��_���&@�� �u�M�5Ĉ�Xm���eL�X�q��y#�9]�c�}ɄL��d�eJ몓���I1T�d��CaM�$��T�,�X �bʭ�!�%F5��X1x#���!�q��\��F��2��&Rq���C�ol~�̱�.0ϦL�d�`.������ ���m{�Y~k{C��}bv�;U��c<�r�~ɜs�1�j��]W�l��*նCr��Q�N9�-������d��E؛��nF��eړ�8(q��5UgRȱGTA��*������̆��V�珰����ezN��h�U]�T�FG�^���<��ay�,!���5.� �u�bΚ�V�J%��m�Dxn'�����6�@BPa�`��Hts� �ɮ���Ŏ�Zɬ��%B�X��d5Z���hC}�䅸�p+ k=��ʒ(�aՏFG&�%@/�{+�Yu+�ȣGѩ"O%�|vȲxF>�N(��ou�h6 &Y5��8�7�E$-��']n,@TD\��+���Ry�U��U^�Q,f>��1�����q��f��U��� ����F���ڥ��>I�����fNUw�u��#OMMQ6� N�*��_�� k� ����rS��`���1�:��!�F'<+� � b?O��2 !Q12A��� "3a������#$��?�,�7�!`yǮ(�1�6w��a���� �F�#��?*"s���v>��Ⱥ����f�v��͑���s����������]Gn��S ���ȥpG ы�E�g�)Z���x�rY�q�]�@f�_܃�pչEڎّC ����Ŝ*/ �h�O�Sv�و\��5��U��y��|o�Hm2C�S�BW����)��5��{T��W���=o*RA��<����L0g4{��쁢�ep�rw�8��7��U���t<Ԍѻ7�fGf�k}���Ê�㛆Gռz�Q@��{C��'G��8�!�S$�j��x���|���צV<��,����u�k�uu�rM�f�_dϣi ߫�ԟn�!K����mxu�=�槻�'j�X�����������%!A "1QR#Br��?�R:��R�n�b[�II?#��6<:�$gN����lGNlrr��dעMMn`ɿy�,�%B�e�W��dVS��r���� %�tT��(�ɷ��S�]�O]#�_LEMHN�M���kv���~X���O6�U�V_�����b���J�t�774����D!1AQa"2q�#3BRb����0���� 4CSr����cst�����?��^q���7�dG�U�"p��moz��'��n_x���唹e������<6��O�t���R>k��s=�Cr���e�?�i��� ����/��ں$be���o`ޮ�GHy�;fNAl�8��.�\�S������"���a�úF�YvNk�-*`v�k�ʈ2f�EE��Wa�,� �fF^#�;��[9��^~������Y$:0#W3������Z*���I�Z�ڹ�k�n--9=��G��;7F)m{T�Ɇ��=�����Ȭ5�5�B�aڞ5M����#m�5Ʀ��m�8��+Hh���$�}�:&�e�Q�[;i]С�:�:��o����$<~��5RB�?�s3�5�r��O��ֿ�w�P/��̅���(�Z6�R>)��N��4�!ʊ�wz�-�r�w+�yk���q�1�bKhƸ�4N�Ӑ�X����Q��_��})�+e1�5��n��q?��[�^�9�<�z3Fsi�8�'�)9p)�{��RP�Z+�*��p(aY��V����6l�g�9��;���d�u���Nt@�3�sTwzaŇ�GT�b�H��(#��*zc�������9K�b1�����t����Ê��
�Z?g�iD���H�R���B���^M����v���O���L�D,'d�q�C�P�����$Δ��U�֟֊=�s��F�$��J�ދZ?�N��������A�N�WP��,�� �¦�&;�x��dup�����i���Ipd���;�Dž!��ֿѮAb%�u��}j��-p��>I�[�N�bi����G�'�;4w�m]H�]����#LӘNN��R��������s�.]��en��-�8e��Ps����Q��;���ț�E�ݫ���7��g�_L��W��EZ:/��I���a�g�n�ܤ��iٹ���ŷ�T���H~i�a�����֎�~KV������ A-2m]�F"�m�9-Zbǰ�״ @����~�4�N�[�Uxč�tl>������u#r�gѐ�3���;M9�<�J�����1�vfL8����1�P�HgP�Xv��������{����O�}�n��KQ؋����7<�l�fey<�}�>�bX���4<`Y7���si��V)�s�:�{�rO�h�z �@4VW�B���&�������ɡob܋�F��4>y�s�fXWS�N�O$�,.u:�ԫ��g�yao4��$h��D#��ٸf^kh�7�#1Z�֥&���*�v-��;bޭ����Q�����h�ow�y]�ه.+�7�M�ⴻ �JY��g�f�i3q��KC��3�¹�?5�Z.N��^Z w���KF͂���7��ރ۞��wj��T�J.�q��\Sv1U����R��욽&�N����pЖ`�`у��m`v�n#z��4��>e��V�`'���h�����'�j�AҔ�-�4:H���n]9�h<��n����U�6m��2c�E�1/�Y�%���I��~ʏ�|VBƟ@����;�������%�M9M���}��1�D��d����%g���O��]��у&�r��f�7�uܲ���(!1AQaq�������0� ���?!��*��@)�Je�G��j��{�['��v+���������)���(�/����д%젍Z��kk�Lu�Rm���j.c���@Z� V�J��d��j���h6���2AO�� a;oBu���H�=���nK�W8�B�ɰ�u?��бأm,�sr����|����8˨i��qI2tZ�ۄJP��XE��������zޔj~]UMu����zv!����N�&�1�Y��zJ�ՠ��\p��o'ሸ�C؊Y��TD"HM5�Ъ��i߯a���F����A)�����ڮ����z�E���@�hg�֝8�1jk��\�M�3�8ܢ�� ������s�7����N}�ޭ������GN�Bc���L pk�;�J�δ3�e�iU�gAYW]\�>�GyگQ=��f�KA;T�a`eM+Q �� �Ln���̌]GM�����<Ħ�j���H��N�M�x�}aX{̣S� ��ԅ��n�MA�S�r�(����(�L��zo9���.�;
�ӳf������`Ӕ٢3�� IW��\9~_���saa�\ԊW�ܭX:���ӆ�38�ty*����N�qP����BI�Y��jE��>DP�!�R%-��4��'�皺;��~J�!�7m���X��h�P!曭���$�\�AYj�.lC��4��+�jD�dgC0-*���|��`ZD�+л�C"��)��s��8Kq�pq���Ms��4� ��7\U`�.��[Ey8��AH!/��,���(:M -�T䓥�~O�4-���Ԓn��}HDN7���K���$�_Ԕ䚞`�R�hB�_aX?4V��ŗ�@ه�u�a�;�{PcT+�������7YBo�?��r-ͩ{�ĎA�� ����˼n��M286��G���1���V�˜Jв"l��V5���5�C]h���̊�A���%� �'p���Ԃ���Ր��9=�d�=�e�{�'<3�_ �:^�~��4�(�n�-C�s��5m![�jmIqU�~�Tw8��`���p�H8�u�Д l m�aP�0�������9y����CM��F1G糞�.�U~�������FC�{�!e(Y�:���P����7~;�L�N^{�1r�\���ԬG(���0d�ÏO�qK�Z�⑼�T�{ 2��s��Kd�Տ?mMQ��=���6�7�i�����H+����9��d��=��;�QؤH8n�Lb�D��yS%�(�{b���Cu���p�t#C���$A"�H{���jqᶯ�:�n=E����hH�`�!�m��MA������?�v6���+MԿ⟚qK�i�D�*Q5��CZ���2�|]�:Xd+�t�:o@��M��� :�32��b����[\5=�ֵ7])�|t��Ϻ����w�B�ń�e���!`�:��I,��9:����j@/a 8����+<�u�(T^ۺ~��2oE�B�%b)��z��ݳځ�)��i�j��&��Fi`qr��w���7�@��P�� �3Z&<�m�S�C����7t�T����ƴ�q~J�e�r6�Z]�rL���ه�E17'�x���+[�ܜTc6�/�����W�`�qpMJ���N5^����x�}{l�Fm������1�oZ\�����/d�/6� �uӸ�0elXuX;M��$M�}mB��������Z%e���3f�js����O�J~2�z�86�*PB��v�Ν��e-��.�/��L�O����2����9���4}|��T5M���hÐ7�F*��l+y0����:|��=k[�d�;|�ԉe�=w�<��õ�<��'!1AQaq����� ������?��5����)�(���+>v����6&{���Ǹ@����M�����v��iA 6T'�w��h�s �E}�x��G&'g�� J~1q�f�f���&��q˘���-���vYm
�/i1 �I��6��u,)�#�,����l}*&`�$�ͬe�%�w3�x�Ѥ�Xc�D��执g�峕�5B/�|$��=���%8 a��2.l� c�@G� �\�/x[өq�]�v5?�����N|�!���\��,>��{�"r�/��?��&!1QAa�� ��ᑱ����?ĊD�肭�� nv@�yޝ (�����I ����U - ���b�m�E>,��1v!�d�&�� ���&�檔�5D�&0P��Ԕ�͒@Z��:E"� Q��`>PH:~�O�����P�3W��@hM��k�U��\�O��R�������5ʄ�,��f�|��r���}јxo)�"+h�QK���/��0�`�5�{M~�� ���'!1AQaq���0 �������?�?�k��#^�~�G��#V,������#Z�1'ܤ����������~p�O%O�O�\�q�`�~��}��E�Ű5 �輸�du����x\�$���s[�{T2t`B��gq�4Z]b� 㛪�3,(@����bAp�r)9:@|b�!r�g:N�^�Ʌ��� �x_�\��pm7I��0?>^k��������w���|.K�[sF@�]Gn*L �yO� le�P�.p��֍�j�S�=�ʨ�ןQF�"��5zʼn���k�*8�u" ����Fg��� �cSy�V������Ƈ��N��ؐ(�����48hV�A�ӎ^��^ ���jyB� ��p"�����y]�ļlU�(�7�U`3�pCGF'&yg������o��z������X��ν:�P"@�G@x[��o&MJ�$F.����hi w;}�/^͇q���n�mN�/�TQ���އ��O1\,}��bQ #¯^S!)��X���#GPȏ�t�� c^\��' }iIZ���a�)��������z��4͊�Ξy��48,��f���#�����KP!Jx�|w�ʆ�������������#��Z�������< �~K��r�p&qH/;�R���沽�+�E�R���~0v���V#ʀ�T��S(-ڝ��B�y�b�C�D������b��������8��~�= �Y�ͧ]��@n����M�k2�%�;�%,�r6�LR腻?^��;KŇ=�ք ���=`�ɥ��/����z�&�I{���#J��M���C��}�H9^UJ�,P ��pS����G�d69Ϭu���%"��ˢP��K�"k)��=��9� ����㇌,��Oli��Xzh� " � ������R��^�s����N�k��Q>�63(���� ��PQ�Py�����3����$f+W՛=4�ǁ`*��^��Eb�K�t�6��^��!�籷��ȭ��K{/;�L���p�x�����;a���Oلz�[�.NP4�]Gc�T�v����~sg'LED��]j��'�G�]�6rY����UPw�*O�İՋi�'8�۴�#g�Xx+=�eU6�R��c�"�u2��~�?n�y�;�u��3�'��6�f������b��߬M�$*��k&?6���*^1n����ێz)<��Gz� �����7����Y� ��ۃ)$A��2�L6� ե�H�<�r��#ʽ2��O��R���z�A��XW��@���������<�G� Ϥ�^�˓i�M�W���6 ��0��m){c�;ݧ�>R�a����}1�ٯ%�EY2�Q��Ep���$ ��E��qS��t#+x� *�h�UI��XM?�'//��a'�G�����q@���<��z��؟����cd��z�ˬT_u�Ѯ����&�z�k ��n ]�a%�py»�`Qd�xc������n�� ��*��oTd�;'j�<�!j���'�(~�ʹW�M� P�mȘ��@֨V+��R�`�$��`�+@��_[�kG����P���Zh9�R����&5b�v���Z���#p�&�Ա+��8�etZ7G���;��@"�e0���v7����?��z�?_���_�q1�T�"�p�ˎ/U 6_�B�>��0( ��}G#������Ȣ�p�� �9��;/& `�B&$�y��t(�*z�x���Ӕ������S�?Kȏ3���{p� b � ۍ-�z܈֦��6?<���ǬP�N�G �更� �6�/h�����0Z���������i�ua��e�*M'A� �x��v�q.>�F� oN{��Q���{gD��L��u��=|���O xN���d���q�8(��E�Uu��,��O� t�DJ ����;��G����e���C��VYZ�� ���T4{����(�Ӳ'c�t�f��w�c�jr�e�m �#7,�6��B�E4Q�P�.P�(&��^{9H-�m�o ��q�g1���=��>p�)/"p0!4�mS6ú�FN���h��D �)��XdT �FؤZ⸚�k���H�c8v� <���u�P�Հ���:��_�EN��|�ӛ��u?-�/�o�Lhk�ܸ�S�;�Rī�����T"�N����M��px7<�� j�$��`�Y)Pjh 5` K�Qf�4�C�bX"�D���;HD�Z�9R b�F)�UA����v�#��HD�!{������>I� �`�ԁ i�4�)t*�ç�Le�_���>ru�GEQg��ǔct��ō0��l6v���d�� ��GG8���v^�|�#JyZPSO�� Y�CuAߐ�"�x���OfHF@�K�V�!少Eҕ]h� ��[���)��.q����*0I<8��^�6�}p��^tho���ig�i����DK���p,��2�3�I��5����쓄OY�6s7Qs�Ow^�w�J/�A➰������0������g(Մ��y��Kԇ����QS��?H���w�X�=��ҞX�~���Q=�'���p?7�@g�~�G�}�r��g�T?���
One Hat Cyber Team
One Hat Cyber Team
Your IP :
13.58.12.108
Server IP :
162.0.235.113
Server :
Linux premium146.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
Server Software :
LiteSpeed
PHP Version :
5.6.40
Buat File
|
Buat Folder
Dir :
~
/
home
/
jouhnipz
/
www
/
is-admin
/
Edit File Name:
index.php
<?php require_once("../config.php"); if(!isset($_SESSION['id'])){ header('location: login.php'); } ?> <!DOCTYPE html> <html lang="zxx"> <head> <meta charset="utf-8"> <title>iStore - CPanel</title> <meta name="description" content="iStore - CPanel"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="robots" content="noindex,nofollow" /> <!-- General CSS Settings --> <link rel="stylesheet" href="css/general_style.css"> <!-- Main Style of the template --> <link rel="stylesheet" href="css/main_style.php"> <!-- Landing Page Style --> <link rel="stylesheet" href="css/reset_style.css"> <!-- Awesomefont --> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.4.1/css/all.css" integrity="sha384-5sAR7xN1Nv6T6+dT2mhtzEpVJvfS3NScPQTrOxhwjIuvcA67KV2R5Jz6kr4abQsz" crossorigin="anonymous"> <!-- DateRangePicker --> <link rel="stylesheet" type="text/css" href="css/daterangepicker.css" /> <!-- Fav Icon --> <link rel="shortcut icon" href="<?php echo $websiteurl;?>/favicon.ico"> <!-- OneSignal Push Notification --> <?php include("../is-themes/".$parameters['theme']."/onesignal.php");?> </head> <body> <!-- Background --> <div class="lx-background"> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> <div class="lx-background-item"></div> </div> <!-- Wrapper --> <div class="lx-wrapper"> <!-- Header --> <div class="lx-header"> <?php include('header.php');?> </div> <!-- Main --> <div class="lx-main"> <div class="lx-main-leftside"> <?php include('mainmenu.php');?> </div> <!-- Main Content --> <div class="lx-main-content"> <div class="lx-page-header"> <h2>Statistiques</h2> </div> <?php if($_SESSION['type'] == "moderator"){ ?> <div class="lx-g1 lx-pb-0"> <div class="lx-stats-bloc"> <h3>Dépenses et revenus</h3> <?php $back = $bdd->query("SELECT SUM(cost) AS sm FROM expenses WHERE type='Dépense' AND trash='1'"); $expenses = $back->fetch(); ?> <div class="lx-g3 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #39add1;"> <a href="javascript:;"> <span>Dépenses</span> <div class="lx-clear-fix"></div> <strong><?php echo $expenses['sm'];?> <?php echo $parameters['currency'];?></strong> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT SUM(cost) AS sm FROM expenses WHERE type='Revenu' AND trash='1'"); $incomes = $back->fetch(); ?> <div class="lx-g3 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #39add1;"> <a href="javascript:;"> <span>Revenus</span> <div class="lx-clear-fix"></div> <strong><?php echo $incomes['sm'];?> <?php echo $parameters['currency'];?></strong> <div class="lx-clear-fix"></div> </a> </div> </div> <div class="lx-g3 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #39add1;"> <a href="javascript:;"> <span>Profits</span> <div class="lx-clear-fix"></div> <strong><?php echo $incomes['sm']-$expenses['sm'];?> <?php echo $parameters['currency'];?></strong> <div class="lx-clear-fix"></div> </a> </div> </div> <div class="lx-clear-fix"></div> </div> </div> <?php } ?> <div class="lx-g1 lx-pb-0"> <div class="lx-stats-bloc"> <h3>Chiffre d'affaires estimé</h3> <?php $back = $bdd->query("SELECT COUNT(id) nb,SUM(price) AS sm FROM commands WHERE phase='shipping' AND trash='1'".$user); $row = $back->fetch(); $nbtotal = $row['nb']; if($nbtotal == 0 OR $nbtotal == ""){ $nbtotal = 1; } ?> <div class="lx-g4 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #39add1;"> <a href="javascript:;"> <span>Total chiffre d'affaires</span> <div class="lx-clear-fix"></div> <strong><?php echo $row['sm'];?> <?php echo $parameters['currency'];?></strong> <br /> <del><?php echo $row['nb'];?> commandes (100%)</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT COUNT(id) nb,SUM(price) AS sm FROM commands WHERE phase='shipping' AND state NOT IN('Livré','Change','Annulé','Refusé','Retourné','Manque de stock') AND trash='1'".$user); $row = $back->fetch(); ?> <div class="lx-g4 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #8dce68;"> <a href="javascript:;"> <span>Chiffre d'affaires en circulation</span> <div class="lx-clear-fix"></div> <strong><?php echo $row['sm'];?> <?php echo $parameters['currency'];?></strong> <br /> <del><?php echo $row['nb'];?> commandes (<?php echo round(($row['nb']*100)/$nbtotal,2)?>%)</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT COUNT(id) nb,SUM(price) AS sm FROM commands WHERE phase='shipping' AND state IN('Livré') AND trash='1'".$user); $row = $back->fetch(); ?> <div class="lx-g4 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #008000;"> <a href="javascript:;"> <span>Chiffre d'affaires livré</span> <div class="lx-clear-fix"></div> <strong><?php echo $row['sm'];?> <?php echo $parameters['currency'];?></strong> <br /> <del><?php echo $row['nb'];?> commandes (<?php echo round(($row['nb']*100)/$nbtotal,2)?>%)</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT COUNT(id) nb,SUM(price) AS sm FROM commands WHERE phase='shipping' AND state IN('Annulé','Refusé','Retourné','Manque de stock') AND trash='1'".$user); $row = $back->fetch(); ?> <div class="lx-g4 lx-pb-0"> <div class="lx-state-count" style="border-bottom:4px solid #8dce68;"> <a href="javascript:;"> <span>Chiffre d'affaires perdu</span> <div class="lx-clear-fix"></div> <strong><?php echo $row['sm'];?> <?php echo $parameters['currency'];?></strong> <br /> <del><?php echo $row['nb'];?> commandes (<?php echo round(($row['nb']*100)/$nbtotal,2)?>%)</del> <div class="lx-clear-fix"></div> </a> </div> </div> <div class="lx-clear-fix"></div> </div> </div> <?php if($_SESSION['type'] != "worker"){ ?> <div class="lx-g1 lx-pb-0"> <div class="lx-stats-bloc"> <h3>Taux de livraison</h3> <?php $back = $bdd->query("SELECT id FROM commands WHERE trash='1'"); $nbtotal = $back->rowCount(); if($nbtotal == 0){ $nbtotal = 1; } ?> <div class="lx-g3 lx-pl-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #000000;"> <a href="commands.php?s=En cours,Expédié,Injoignable,Pas de réponse,Pas de réponse 2 fois,Pas de réponse 3 fois,Pas de réponse 4 fois,Pas de réponse 5 fois,Reporté,Interessé"> <span>Total commandes</span> <div class="lx-clear-fix"></div> <strong>100%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE state IN('Nouveau') AND trash='1'"); ?> <div class="lx-g3 lx-plr-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #008000;"> <a href="commands.php?s=Nouveau"> <span>Nouveau</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE state IN('Livré') AND trash='1'"); ?> <div class="lx-g3 lx-plr-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #008000;"> <a href="commands.php?s=Livré"> <span>Livré</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <div class="lx-clear-fix"></div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE state IN('En cours','Expédié') AND trash='1'"); ?> <div class="lx-g4 lx-pl-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #FFAA00;"> <a href="commands.php?s=En cours,Expédié"> <span>En cours & Expédié</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE (state IN('Injoignable') OR state LIKE '%Pas de réponse%') AND trash='1'"); ?> <div class="lx-g4 lx-pl-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #FF7700;"> <a href="commands.php?s=Injoignable,Pas de réponse,Pas de réponse 2 fois,Pas de réponse 3 fois,Pas de réponse 4 fois,Pas de réponse 5 fois"> <span>PDR & Injoignable</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE state IN('Reporté','Interessé') AND trash='1'"); $row = $back->fetch(); ?> <div class="lx-g4 lx-pl-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #00CCFF;"> <a href="commands.php?s=Reporté,Interessé"> <span>Reporté & Interessé</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <?php $back = $bdd->query("SELECT id FROM commands c WHERE state IN('Annulé','Refusé','Retourné') AND trash='1'"); ?> <div class="lx-g4 lx-plr-0 lx-pb-0 lx-plr-0-mob"> <div class="lx-state-count" style="border-bottom:4px solid #CC0000;"> <a href="commands.php?s=Annulé,Refusé,Retourné"> <span>Annulé & Refusé</span> <div class="lx-clear-fix"></div> <strong><?php echo round(($back->rowCount()*100)/$nbtotal,2)?>%</strong> <br /> <del><?php echo $back->rowCount();?> commandes</del> <div class="lx-clear-fix"></div> </a> </div> </div> <div class="lx-clear-fix"></div> </div> </div> <?php } ?> <div class="lx-g3"> <div class="lx-stats-bloc"> <h3>Top 6 produits</h3> <table cellpadding="0" cellspacing="0"> <tr> <td>Produit</td> <td>Nb. com.</td> </tr> <?php $productsids = ""; $qtys = ""; $back = $bdd->query("SELECT id,title FROM products WHERE trash='1'"); while($row = $back->fetch()){ $productsids .= ",".$row['title']; $qtyn = 0; $back1 = $bdd->query("SELECT product,qty FROM commands WHERE phase='shipping' AND (product='".$row['id']."' OR product LIKE '".$row['id'].",%' OR product LIKE '%,".$row['id'].",%' OR product LIKE '%,".$row['id']."')"); while($row1 = $back1->fetch()){ $products = explode(",",$row1['product']); $qty = explode(",",$row1['qty']); for($i=0;$i<count($products);$i++){ if($products[$i] == $row['id']){ $qtyn += $qty[$i]; } } } $qtys .= ",".$qtyn; } $productsids = explode(",",substr($productsids,1)); $qtys = explode(",",substr($qtys,1)); for($i=0;$i<count($qtys);$i++){ for($j=0;$j<count($qtys);$j++){ if($qtys[$i] > $qtys[$j]){ $k = $qtys[$i]; $qtys[$i] = $qtys[$j]; $qtys[$j] = $k; // ------------ $k = $productsids[$i]; $productsids[$i] = $productsids[$j]; $productsids[$j] = $k; } } } $topproducts = ""; $productsids = array_slice($productsids,0,6); $qtys = array_slice($qtys,0,10); for($i=0;$i<count($productsids);$i++){ ?> <tr> <td><span><?php echo $productsids[$i];?></span></td> <td><span><?php echo $qtys[$i];?></span></td> </tr> <?php } ?> </table> </div> </div> <div class="lx-g3"> <div class="lx-stats-bloc"> <h3>Top 6 villes</h3> <table cellpadding="0" cellspacing="0"> <tr> <td>Ville</td> <td>Nb. com.</td> </tr> <?php $back = $bdd->query("SELECT COUNT(id) AS nb,city FROM commands WHERE phase='shipping' AND trash='1' GROUP BY city ORDER BY nb DESC LIMIT 0,6"); while($row = $back->fetch()){ ?> <tr> <td><span><?php echo $row['city'];?></span></td> <td><span><?php echo $row['nb'];?></span></td> </tr> <?php } ?> </table> </div> </div> <div class="lx-g3"> <div class="lx-stats-bloc"> <h3>Top 6 employés</h3> <table cellpadding="0" cellspacing="0"> <tr> <td>Employé</td> <td>Nb. com.</td> </tr> <?php $back = $bdd->query("SELECT COUNT(id) AS nb,(SELECT fullname FROM users WHERE id=c.worker) AS workername FROM commands c WHERE phase='shipping' AND trash='1' GROUP BY worker ORDER BY nb DESC LIMIT 0,6"); while($row = $back->fetch()){ ?> <tr> <td><span><?php echo ($row['workername']!="")?$row['workername']:"Modérateur";?></span></td> <td><span><?php echo $row['nb'];?></span></td> </tr> <?php } ?> </table> </div> </div> <div class="lx-clear-fix"></div> </div> </div> </div> <!-- JQuery --> <script src="js/jquery-1.12.4.min.js"></script> <!-- Main Script --> <script src="js/script.js"></script> </body> </html> <?php DB_Sanitize();?>
Save