API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 31st, 2020
138
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 11.26 KB | None | 0 0
raw download clone embed print report
  1. session_start();
  2. ob_start();
  3.  
  4. define("ROW_PER_PAGE",50);
  5. $connection = require $_SERVER['DOCUMENT_ROOT'] . "/wp-content/php_dr/db/dbconn.php";
  6.  
  7.     try {
  8.         $dbconnect = new PDO("mysql:host={$connection['host']};dbname={$connection['dbname']};charset=utf8",
  9.                 $connection['dbuser'],
  10.                 $connection['dbpass'],
  11.                 [   PDO::ATTR_EMULATE_PREPARES => false,
  12.                     PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ]
  13.                 );
  14.     } catch (PDOException $e) {
  15.         exit("Connection error." . $e->getMessage());
  16.     }
  17. ?>
  18. <html>
  19. <head>
  20. <style>
  21.  
  22. .tbl-qa{width: 100%;font-size:0.9em;background-color: #f5f5f5;}
  23. .tbl-qa th.table-header {padding: 5px;text-align: left;padding:10px;}
  24. .tbl-qa .table-row td {padding:10px;background-color: #FDFDFD;vertical-align:top;}
  25. .button_link {color:#FFF;text-decoration:none; background-color:#428a8e;padding:10px;}
  26. #keyword{border: #CCC 1px solid; border-radius: 4px; padding: 7px;}
  27. .btn-page{margin-right:10px;padding:5px 10px; border: #CCC 1px solid; background:#FFF; border-radius:4px;cursor:pointer;}
  28. .btn-page:hover{background:#F0F0F0;}
  29. .btn-page.current{background:#F0F0F0;}
  30. </style>
  31. </head>
  32. <body>
  33. <? 
  34.     /*$search_keyword = '';
  35.     if(!empty($_POST['search']['keyword'])) {
  36.         $search_keyword = $_POST['search']['keyword'];
  37.     } */
  38.     $sql = "select
  39.                     t1.id, t1.user_login,
  40.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'first_name') as 'firstname',
  41.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'last_name') as 'lastname',
  42.                     t1.user_email,
  43.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'next_ad_int_mobile') as 'mobile',
  44.                     t3.meta_value as 'title',
  45.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'next_ad_int_department') as 'department',
  46.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'next_ad_int_telephone') as 'telephone',
  47.                     (select meta_value from wp_usermeta where user_id = t1.id and meta_key = 'next_ad_int_company') as 'company'
  48.                     from wp_users t1
  49.                     join wp_usermeta t2 on (t2.user_id = t1.id and t2.meta_key = 'wp_capabilities' and t2.meta_value not like '%zwolnieni%')
  50.                     join wp_usermeta t3 on (t3.user_id = t1.id and t3.meta_key = 'next_ad_int_title')
  51.                     WHERE t1.id != 1
  52.                     ORDER BY 4 asc";
  53.  
  54.    
  55.     $per_page_html = '';
  56.     $page = 1;
  57.     $start=0;
  58.     if(!empty($_GET["page"])) :
  59.         $page = $_GET["page"];
  60.         $start=($page-1) * ROW_PER_PAGE;
  61.     endif;
  62.  
  63.     $limit=" LIMIT " . $start . "," . ROW_PER_PAGE;
  64.     $pagination_statement = $dbconnect->prepare($sql);
  65.  
  66.     $pagination_statement->execute();
  67.  
  68.     $row_count = $pagination_statement->rowCount();
  69.     if(!empty($row_count)) :
  70.         $per_page_html .= "<div style='text-align:center;margin:20px 0px;'>";
  71.         $page_count=ceil($row_count/ROW_PER_PAGE);
  72.         if($page_count>1) :
  73.             for($i=1;$i<=$page_count;$i++) :
  74.                 if($i==$page){
  75.                     $per_page_html .= '<input type="submit" name="page" value="' . $i . '" class="btn-page current" />';
  76.                 } else {
  77.                     $per_page_html .= '<input type="submit" name="page" value="' . $i . '" class="btn-page" />';
  78.                 }
  79.             endfor;
  80.         endif;
  81.         $per_page_html .= "</div>";
  82.     endif;
  83.    
  84.     $query = $sql.$limit;
  85.     $pdo_statement = $dbconnect->prepare($query);
  86.  
  87.     $pdo_statement->execute();
  88.     $result = $pdo_statement->fetchAll();
  89.  
  90.  
  91. ?>
  92.  
  93. <form method="get" action="https://intra.vector.net/o-grupie/" name="searchbox" role="form">
  94.     <input type="search" name="q" placeholder="Wpisz szukaną wartość" required="required">
  95.     <button type="submit" name="s" value="t">szukaj</button>
  96. </form>
  97.  
  98. <form name='vector-employees' action='' method='get'>
  99. <style>.member-container{
  100.  
  101. width:1100px;
  102. margin: 0 auto;
  103.  
  104. text-align:center;
  105. }
  106. .member-container div{
  107. display: inline-block;
  108.  
  109. vertical-align: middle;
  110.  
  111. }
  112. body { font-family: arial; }
  113. .col { display: inline-block; width: 30%; height:500px;background: #fafafa; border: solid 1px #ebebeb; box-shadow: 0 0 25px rgba(68, 68, 69, 0.2);margin-bottom: 2%; margin-right: 2%;}
  114. .member-info {
  115.     display: block;
  116. }
  117. </style>
  118. <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
  119.  <div class="member-container">
  120.  
  121. <?
  122.  
  123. ?>
  124.     <?
  125. foreach ($result as $res) :
  126.     $id = $res['id'];
  127.     $firstname = $res['firstname'];
  128.     $lastname = $res['lastname'];
  129.     $email = $res['user_email'];
  130.     $title = $res['title'];
  131.     $department = $res['department'];
  132.     $telephone = $res['telephone'];
  133.     $mobile = $res['mobile'];
  134.     $company = $res['company'];
  135.     $userlogin = $res['user_login'];
  136.     $memberborder = $res['company'];
  137.     $displayname = $firstname . ' ' .$lastname;
  138.  
  139.  
  140.  
  141.     ?>
  142.  
  143.  
  144.  
  145.    <div class="col">
  146.     <div class="member-photo"> <?php echo get_avatar($id, $size = 300); ?>
  147.        
  148.     </div> <!-- .member-photo -->
  149.     <div class="member-name"><a href="/employee/?id=<?=$id;?>"><?= $firstname . ' ' . $lastname;?></a>
  150.     </div> <!-- .member-name -->
  151.     <div class="member-tagline"><?= $company; ?>
  152.     </div> <!-- .member-tagline -->
  153.     <div class="member-showmore">
  154.         <a class="showmore-id-<?=$id;?>">show more</a>
  155.     </div> <!-- .member-showmore -->
  156.     <div class="showmore-desc-id-<?=$id;?>" style="display: none;">
  157.         <div class="member-info" style="display: grid; text-align: left;">
  158.         <span class="company">Firma: <?php echo CompanyLink($company); ?></span>
  159.         <span class="department">Dział: <?= $department;?></span>
  160.         <span class="title">Stanowisko: <?=$title;?></span>
  161.         <span class="e-mail">Adres e-mail: <a href="mailto:<?=$email;?>"><?=$email;?></a></span>
  162.         <span class="telephone">Telefon: <a href="javascript:DoMakeCall('<?=$telephone;?>', '<?=$displayname;?>', 'telephonenumber')"><?= $telephone;?></a></span>
  163.         <span class="mobile">Tel. kom: <a href="javascript:DoMakeCall('<?=$mobile;?>', '<?=$displayname;?>', 'telephonenumber')"><?=$mobile;?></a></span>
  164.         </div>
  165.     <span class="showless">pokaz mniej</span>
  166.     </div>
  167. </div> <!-- .column-center -->
  168.  
  169.         <script>
  170. $(".showmore-id-<?=$id;?>").on('click', function() {
  171.     $(".showmore-desc-id-<?=$id;?>").show(500);
  172.     $(this).hide();
  173. });
  174. $(".showless").click(function() {
  175.         $(".showmore-desc-id-<?=$id;?>").hide(500);
  176.         $('.showmore-id-<?=$id;?>').show(500);
  177. });
  178. </script>
  179. <? endforeach; ?>
  180. </div>
  181. <?= $per_page_html; ?>
  182. </form>
  183. <?
  184.  
  185.     /*function BorderColor($companycolor) {
  186.         switch($companycolor) :
  187.             case stripos($companycolor, 'ector sp. z o.o.') !== false;
  188.                 return 'border: 2px solid transparent;
  189.                         border-image: linear-gradient(to bottom, #476585, #002b4e);
  190.                         border-image-slice: 1;';
  191.                 break;
  192.             case stripos($companycolor, 'solutions') !== false;
  193.                 return 'border: 2px solid transparent;
  194.                         border-image: linear-gradient(to bottom, #44c7ee, #008fbd);
  195.                         border-image-slice: 1;';
  196.                 break;
  197.             case stripos($companycolor, 'technologies') !== false;
  198.                 return 'border: 2px solid transparent;
  199.                         border-image: linear-gradient(to bottom, #71c8b5, #00ae8d);
  200.                         border-image-slice: 1;';
  201.                 break;
  202.             case stripos($companycolor, 'smart data') !== false;
  203.                 return 'border: 2px solid transparent;
  204.                         border-image: linear-gradient(to bottom, #f38ba8, #EE2B7A);
  205.                         border-image-slice: 1;';
  206.                 break;
  207.             case stripos($companycolor, 'v systems') !== false;
  208.                 return 'border: 2px solid transparent;
  209.                         border-image: linear-gradient(to bottom, #76c47f, #00d664);
  210.                         border-image-slice: 1;';
  211.                 break;             
  212.             default: return 'border: none;';
  213.  
  214.         endswitch;
  215.  
  216.     } */
  217.  
  218.     function CompanyLink($companylink) {
  219.  
  220.                 switch($companylink) :
  221.                     case stripos($companylink, 'ector sp. z o.o.') !== false;
  222.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-shared-services">' . $companylink . '</a>';
  223.                         break;
  224.                     case stripos($companylink, 'solutions') !== false;
  225.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-solutions">' . $companylink . '</a>';
  226.                         break;
  227.                     case stripos($companylink, 'technologies') !== false;
  228.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-technologies">' . $companylink . '</a>';
  229.                         break;
  230.                     case stripos($companylink, 'smart data') !== false;
  231.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-smart-data">' . $companylink . '</a>';
  232.                         break;
  233.                     case stripos($companylink, 'v systems') !== false;
  234.                         return '<a href="/o-grupie/struktura-funkcjonalna/falcon-v-systems">' . $companylink . '</a>';
  235.                         break;
  236.                     case stripos($companylink, 'x labs') !== false;
  237.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-x-labs">' . $companylink . '</a>';
  238.                         break;
  239.                     case stripos($companylink, 'blue hub') !== false;
  240.                         return '<a href="/o-grupie/struktura-funkcjonalna/vector-blue-hub">' . $companylink . '</a>';
  241.                         break;
  242.                     default: return $companylink;
  243.                 endswitch;
  244.     }
  245.       /*
  246.     function Department($departmentlink) {
  247.         switch($departmentlink) :
  248.             case stripos($departmentlink, 'DA.AK') !== false;
  249.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=AK">' . $departmentlink . '</a>';
  250.                 break;
  251.             case stripos($departmentlink, 'DA.AZ') !== false;
  252.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=AZ">' . $departmentlink . '</a>';
  253.                 break;
  254.             case stripos($departmentlink, 'DK.FK') !== false;
  255.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=FK">' . $departmentlink . '</a>';
  256.                 break;
  257.             case stripos($departmentlink, 'DN.NI') !== false;
  258.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=NI">' . $departmentlink . '</a>';
  259.                 break;
  260.             case stripos($departmentlink, 'DN.NA') !== false;
  261.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=NA">' . $departmentlink . '</a>';
  262.                 break;
  263.             case stripos($departmentlink, 'Administracja') !== false;
  264.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=NA">' . $departmentlink . '</a>';
  265.                 break;
  266.             case stripos($departmentlink, 'DN.NP') !== false;
  267.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=NP">' . $departmentlink . '</a>';
  268.                 break;
  269.             case stripos($departmentlink, 'DF.FK') !== false;
  270.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=FK">' . $departmentlink . '</a>';
  271.                 break;
  272.             case stripos($departmentlink, 'DF.FF') !== false;
  273.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=FF">' . $departmentlink . '</a>';
  274.                 break;
  275.             case stripos($departmentlink, 'DF.FC') !== false;
  276.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=FC">' . $departmentlink . '</a>';
  277.                 break;
  278.             case stripos($departmentlink, 'DP.DK') !== false;
  279.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=KL">' . $departmentlink . '</a>';
  280.                 break;
  281.             case stripos($departmentlink, 'DP.KM') !== false;
  282.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=KM">' . $departmentlink . '</a>';
  283.                 break;
  284.             case stripos($departmentlink, 'MK Komunikacja') !== false;
  285.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=MK">' . $departmentlink . '</a>';
  286.                 break;
  287.             case stripos($departmentlink, 'SR Serwis') !== false;
  288.                 return '<a href="/o-grupie/struktura-funkcjonalna/vector-shared-services/srs-serwis/">' . $departmentlink . '</a>';
  289.                 break;
  290.             case stripos($departmentlink, 'DP.SR') !== false;
  291.                 return '<a href="/o-grupie/struktura-funkcjonalna/sf/?sf=SRS">' . $departmentlink . '</a>';
  292.                 break;
  293.  
  294.  
  295.             default: return $departmentlink;
  296.         endswitch;
  297.     } */
  298. ?>
  299. </body>
  300. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!