From 54e587272a8da664594aef2ed5f04e976a475c25 Mon Sep 17 00:00:00 2001
From: INOPIAE <inopiae@cacert.org>
Date: Sun, 26 Jan 2014 11:42:34 +0100
Subject: bug 550: added output for org server certifcates

---
 includes/notary.inc.php | 124 +++++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 122 insertions(+), 2 deletions(-)

(limited to 'includes')

diff --git a/includes/notary.inc.php b/includes/notary.inc.php
index 337d8d5..03bf92e 100644
--- a/includes/notary.inc.php
+++ b/includes/notary.inc.php
@@ -1342,7 +1342,7 @@ function output_orgclientcert_table_header($orgname){
     <?
 }
 
-function output_orgclient_table_row($verified, $row, $support = 0){
+function output_orgclientcert_table_row($verified, $row, $support = 0){
     ?>
     <tr>
         <td class="DataTD"><?=$row['ou']?></td>
@@ -1379,7 +1379,7 @@ function output_orgclient_table_row($verified, $row, $support = 0){
     <?
 }
 
-function output_orgclient_table_footer($support = 0){
+function output_orgclientcert_table_footer($support = 0){
     ?>
     <tr>
         <td class="DataTD" colspan="11">
@@ -1397,3 +1397,123 @@ function output_orgclient_table_footer($support = 0){
         </tr>
     <? }
 }
+
+
+function output_orgservercerts_data($orgadminid = 0, $orgfilterid = 0, $sorting, $status){
+    $query = "select UNIX_TIMESTAMP(`orgdomaincerts`.`created`) as `created`,
+        UNIX_TIMESTAMP(`orgdomaincerts`.`expire`) - UNIX_TIMESTAMP() as `timeleft`,
+        UNIX_TIMESTAMP(`orgdomaincerts`.`expire`) as `expired`,
+        `orgdomaincerts`.`expire` as `expires`, `revoked` as `revoke`,
+        UNIX_TIMESTAMP(`revoked`) as `revoked`, `CN`,
+        `orgdomaincerts`.`serial`,
+        `orgdomaincerts`.`id` as `id`,
+        `orgdomaincerts`.`description`, `orginfo`.`O`,
+        `cu`.`fname` as cfname, `cu`.`lname` as clname ,
+        `ru`.`fname` as rfname, `ru`.`lname` as rlname
+        from  `org`, `orginfo`, `orgdomaincerts`
+            left join users as `cu` on `orgdomaincerts`.`orgadminid` = `cu`.`id`
+            left join users as `ru` on `orgdomaincerts`.`revokeorgadminid` = `ru`.`id`
+        where `org`.`orgid`=`orgdomaincerts`.`orgid` and `orginfo`.`id` = `org`.`orgid` ";
+
+    if($orgadminid > 0)
+    {
+        $query .= "AND `org`.`memid` = $orgadminid ";
+    }
+
+    if($orgfilterid > 0)
+    {
+        $query .= "AND `org`.`orgid` = $orgfilterid ";
+    }
+
+    if(0 == $status)
+    {
+        $query .= "AND `oemail`.`revoked`=0 AND `orgdomaincerts`.`renewed`=0 ";
+        $query .= "HAVING `timeleft` > 0 AND `revoked`=0 ";
+    }
+    switch ($sorting){
+        case 0:
+            $query .= "ORDER BY `orginfo`.`O`, `orgdomaincerts`.`expire` desc";
+            break;
+        case 1:
+            $query .= "ORDER BY `orginfo`.`O`, `orgdomaincerts`.`CN`, `orgdomaincerts`.`expire` desc";
+            break;
+    }
+    return mysql_query($query);
+}
+
+function output_orgservercert_table_header($orgname){
+    ?>
+    <tr>
+        <td colspan="10" class="title"></td>
+    </tr>
+    <tr>
+        <td colspan="10" class="title"><? printf(_("Certificates for %s"), $orgname)?> </td>
+    </tr>
+    <tr>
+        <td class="DataTD"><?=_("Renew/Revoke/Delete")?></td>
+        <td class="DataTD"><?=_("Status")?></td>
+        <td class="DataTD"><?=_("CommonName")?></td>
+        <td class="DataTD"><?=_("SerialNumber")?></td>
+        <td class="DataTD"><?=_("Created by")?></td>
+        <td class="DataTD"><?=_("Revoked")?></td>
+        <td class="DataTD"><?=_("Revoked by")?></td>
+        <td class="DataTD"><?=_("Expires")?></td>
+        <td colspan="2" class="DataTD"><?=_("Comment *")?></td>
+    </tr>
+    <?
+}
+
+function output_orgservercert_table_row($verified, $row, $support = 0){
+    ?>
+    <tr>
+        <? if($verified == _("Valid") || $verified == _("Expired")) { ?>
+            <td class="DataTD"><input type="checkbox" name="revokeid[]" value="<?=$row['id']?>"></td>
+            <td class="DataTD"><?=$verified?></td>
+            <td class="DataTD"><a href="account.php?id=23&cert=<?=$row['id']?>"><?=$row['CN']?></a></td>
+        <? } elseif($support == 1) { ?>
+            <td class="DataTD">&nbsp;</td>
+            <td class="DataTD"><?=$verified?></td>
+            <td class="DataTD"><?=$row['CN']?></td>
+        <? } else if($verified == _("Pending")) { ?>
+            <td class="DataTD"><input type="checkbox" name="delid[]" value="<?=$row['id']?>"></td>
+            <td class="DataTD"><?=$verified?></td>
+            <td class="DataTD"><?=$row['CN']?></td>
+        <? } else { ?>
+            <td class="DataTD">&nbsp;</td>
+            <td class="DataTD"><?=$verified?></td>
+            <td class="DataTD"><a href="account.php?id=23&cert=<?=$row['id']?>"><?=$row['CN']?></a></td>
+        <? } ?>
+        <td class="DataTD"><?=$row['serial']?></td>
+        <td class="DataTD"><?=$row['cfname'] . ' ' . $row['clname']?></td>
+        <td class="DataTD"><?=$row['revoke']?></td>
+        <td class="DataTD"><?=$row['rfname'] . ' ' . $row['rlname']?></td>
+        <td class="DataTD"><?=$row['expires']?></td>
+        <? if($support == 1) { ?>
+            <td class="DataTD"><?=htmlspecialchars($row['description'])?></td>
+            <td class="DataTD">&nbsp;</td>
+        <? } else { ?>
+            <td class="DataTD"><input name="comment_<?=$row['id']?>" type="text" value="<?=htmlspecialchars($row['description'])?>" /></td>
+            <td class="DataTD"><input type="checkbox" name="check_comment_<?=$row['id']?>" /></td>
+        <? } ?>
+    </tr>
+    <?
+}
+
+function output_orgservercert_table_footer($support = 0){
+    ?>
+    <tr>
+        <td class="DataTD" colspan="10">
+        <?=_('* Comment is NOT included in the certificate as it is intended for your personal reference only. To change the comment tick the checkbox and hit "Change Settings".')?>
+        </td>
+    </tr>
+    <? if ($support == 0) { ?>
+        <tr>
+            <td class="DataTD" colspan="7"><input type="submit" name="renew" value="<?=_("Renew")?>">&#160;&#160;&#160;&#160;
+              <input type="submit" name="revoke" value="<?=_("Revoke/Delete")?>"></td>
+            <td class="DataTD" colspan="3"><input type="submit" name="change" value="<?=_("Change settings")?>"> </td>
+        </tr>
+        <tr>
+            <td class="DataTD" colspan="10"><?=_("From here you can delete pending requests, or revoke valid certificates.")?></td>
+        </tr>
+    <? }
+}
-- 
cgit v1.2.1