panel_producer_admin.php

/public_html/panel_producer_admin.php

https://gitlab.com/Henaway/CLFC
PHP | 308 lines | 245 code | 27 blank | 36 comment | 29 complexity | adb9009e811a270d9a89a60f37aedad0 MD5 | raw file

<?php
include_once ('config_foodcoop.php');
include_once ('general_functions.php');
session_start();
valid_auth('producer_admin');


$producer_admin_true = 0;
if (CurrentMember::auth_type('producer_admin')) $producer_admin_true = 1;
else header("Location: index.php");

// Check if we need to change the unlisted_producer status
if (isset ($_REQUEST['list_producer']) && $_SESSION['producer_id_you'] != '' )
  {
    if ( $_REQUEST['list_producer'] == 'relist' )
      {
        $unlisted_producer = 0;
      }
    elseif($_REQUEST['list_producer'] == "unlist")
      {
        $unlisted_producer = 1;
      }
    elseif($_REQUEST['list_producer'] == "suspend")
      {
        $unlisted_producer = 2;
      }
    $sqlr = '
      UPDATE
        '.TABLE_PRODUCER.'
      SET
        unlisted_producer = "'.mysql_real_escape_string ($unlisted_producer).'"
      WHERE
        producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"';
    $resultr = @mysql_query($sqlr,$connection) or die(debug_print ("ERROR: 904933", array ($sqlr,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
    $message = 'Producer # '.$producer_id.' has been updated.<br>';
  }

if ($_GET['producer_id_you'])
  {
    // Make sure we are authorized to "become" this producer
    // Either we are the member who is the producer or we are a producer admin
    $query = '
      SELECT
        business_name
      FROM
        '.TABLE_PRODUCER.'
      WHERE
        producer_id = "'.mysql_real_escape_string ($_GET['producer_id_you']).'"';
    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860943 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
    while ($row = mysql_fetch_object($result))
      {
            $_SESSION['producer_id_you'] = $_GET['producer_id_you'];
            $active_business_name = $row->business_name;
          }
      }

// // If we have reached this point without a producer_id_you, then we need to get a default one or abort...
// // Make sure we are authorized to "become" this producer
// // Either we are the member who is the producer or we are a producer admin
// if (! $_SESSION['producer_id_you'])
//   {
//     $query = '
//       SELECT
//         producer_id,
//         business_name
//       FROM
//         '.TABLE_PRODUCER.'
//       WHERE
//         member_id = '.mysql_real_escape_string ($_SESSION['member_id']).'
//         OR producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"
//       ORDER BY
//         business_name
//       LIMIT 0,1';
//     $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 537557 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
//     while ($row = mysql_fetch_object($result))
//       {
//         if ($row->producer_id)
//           {
//             $_SESSION['producer_id_you'] = $row->producer_id;
//             $active_business_name = $row->business_name;
//           }
//       }
//   }

// Get a list of all the producer_id values for this member
$query = '
  SELECT
    member_id,
    producer_id,
    business_name,
    pending AS pending_producer,
    unlisted_producer
  FROM
    '.TABLE_PRODUCER.'
  WHERE
    1
  ORDER BY
    unlisted_producer,
    business_name';
$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 759326 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
while ( $row = mysql_fetch_object($result) )
  {
    $pending_producer = $row->pending_producer;
    // Preset/clear variables
    $active_class = '';
    $active_display = '';
    $pending_class = '';
    $pending_display = '';

    if ($row->pending_producer == 1)
      {
        $pending_class = ' pending';
        $pending_display = '[PENDING] ';
      }
    if ($row->producer_id == $_SESSION['producer_id_you'])
      {
        $active_class = ' current';
        $active_display = '';
        $active_business_name = $row->business_name;
      }

    if ($row->unlisted_producer == 0)
      {
        $producer_list = '
      <li class="listed'.$active_class.$pending_class.'"><a href="'.$_SERVER['PHP_SELF'].'?producer_id_you='.$row->producer_id.'">'.$active_display.$pending_display.htmlspecialchars($row->business_name, ENT_QUOTES).'</a> (Listed)</li>';
      if ($row->producer_id == $_SESSION['producer_id_you'])
        $list_status_html = '
          <ul class="fancyList1">
            '.$producer_list.'<br>
            <li class="unlisted"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=unlist">Unlist '.$active_business_name.'</a><br>(Temporarily remove all '.$active_business_name.' products from the shopping lists)</li><br>
            <li class="suspended last_of_group"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=suspend">Suspend '.$active_business_name.'</a><br>(Temporarily remove '.$active_business_name.' from all producer lists and all '.$active_business_name.' products from the shopping lists)</li>
          </ul>';
      }
    elseif ($row->unlisted_producer == 1)
      {
        $producer_list = '
      <li class="unlisted'.$active_class.$pending_class.'"><a href="'.$_SERVER['PHP_SELF'].'?producer_id_you='.$row->producer_id.'">'.$active_display.$pending_display.htmlspecialchars($row->business_name, ENT_QUOTES).'</a> (Unlisted)</li>';
      if ($row->producer_id == $_SESSION['producer_id_you'])
        $list_status_html = '
          <ul class="fancyList1">
            '.$producer_list.'<br>
            <li class="listed"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=relist">Relist '.$active_business_name.'</a><br>(Make retail and wholesale products available.  This does not change the status of products that are unlisted or archived)</li><br>
            <li class="suspended last_of_group"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=suspend">Suspend '.$active_business_name.'</a><br>(Temporarily remove '.$active_business_name.' from all producer lists and all '.$active_business_name.' products from the shopping lists)</li>
          </ul>';
      }
    elseif ($row->unlisted_producer == 2)
      {
        $producer_list = '
      <li class="suspended'.$active_class.$pending_class.'"><a href="'.$_SERVER['PHP_SELF'].'?producer_id_you='.$row->producer_id.'">'.$active_display.$pending_display.''.htmlspecialchars($row->business_name, ENT_QUOTES).'</a> (Suspended)</li>';
      if ($row->producer_id == $_SESSION['producer_id_you'])
        $list_status_html = '
          <ul class="fancyList1">
            '.$producer_list.'<br>
            <li class="unlisted"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=unlist">Unsuspend '.$active_business_name.'</a><br>(Temporarily remove all '.$active_business_name.' products from the shopping lists)</li><br>
            <li class="listed last_of_group"><a href="'.$_SERVER['PHP_SELF'].'?list_producer=relist">Relist '.$active_business_name.'</a><br>(Make retail and wholesale products available.  This does not change the status of products that are unlisted or archived)</li>
          </ul>';
      }

    if ($producer_admin_true)
      $admin_list .= $producer_list;

    $producer_count ++;
  }





/////////////// FINISH PRE-PROCESSING AND BEGIN PAGE GENERATION /////////////////




// Generate the display output
$display .= '
  <table width="100%" class="compact">
    <tr valign="top">
      <td align="left" width="50%">';

// If there is a current producer_id_you, then show the current status
if ($list_status_html)
  {
    $display .= '
        <img src="grfx/status.png" width="32" height="32" align="left" hspace="2" alt="Status"><br>
        <b>Selected Producer Status:</b> '.$list_status_html;
  }

// Generate the administrative display list of producers
$display .= '
    <img src="grfx/producer3.png" width="32" height="32" align="left" hspace="2" alt="Select producer identity"><br>
    <b>ADMIN: Select Producer Identity</b>
    <p>Producer administrators may choose an identity below to edit on behalf of the producer.</p>
    <div class="height_400">
    <ul class="fancyList1">'.$admin_list.'
    </ul>
    </div>';

$display .= '
      </td>
      <td align="left" width="50%">';
if ($_SESSION['producer_id_you'])
  {
    $display .= '
      <div id="this_producer">
        <div class="title">Links for '.$active_business_name.'</div>
        <img src="grfx/labels.png" width="32" height="32" align="left" hspace="2" alt="Delivery Day Labels"><br>
        <b>'.$active_business_name.' Delivery Day Labels</b>
        <ul class="fancyList1">
          <li><a href="product_list.php?&type=labels_bystoragecustomer">One Label per Customer/Storage</a></li>
          <li class="last_of_group"><a href="product_list.php?&type=labels_byproduct">One Label per Item</a></li>
        </ul>
          <img src="grfx/invoices.png" width="32" height="32" align="left" hspace="2" alt="Producer invoices"><br>
          <b>'.$active_business_name.' Producer Orders</b>
          <ul class="fancyList1">
            <!-- <li><a href="orders_prdcr_cust.php">by Customer</a></li> -->
            <!-- <li><a href="orders_prdcr_cust_storage.php">by Storage/Customer</a></li> -->
            <!-- <li><a href="orders_prdcr.php">by Product</a></li> -->
            <!-- <li><a href="orders_prdcr_multi.php">Multi-sort / Mass-update</a></li> -->
            <li><a href="product_list.php?&type=producer_byproduct">Producer Basket (by product)</a></li>
            <li><a href="product_list.php?&type=producer_bystoragecustomer">Producer Basket List (by storage/customer)</a></li>
            <li class="last_of_group"><a href="product_list.php?&type=producer_bycustomer">Producer Basket List (by customer)</a></li>
            <li><a href="order_summary.php">Order Summary</a></li>
            <li><a href="show_report.php?type=producer_invoice">Producer Invoice</a></li>
            <li class="last_of_group"><a href="orders_saved2.php">Past Producer Invoices</a></li>
            <li><a href="route_list.php?delivery_id='.ActiveCycle::delivery_id().'&type=pickup&producer_id='.$_SESSION['producer_id_you'].'">Routing Checklist (by customer)</a></li>
            <li class="last_of_group"><a href="route_list.php?delivery_id='.ActiveCycle::delivery_id().'&type=dropoff&producer_id='.$_SESSION['producer_id_you'].'">Routing Checklist (by destination)</a></li>
          </ul>
          <img src="grfx/product.png" width="32" height="32" align="left" hspace="2" alt="Edit your products"><br>
          <b>Edit '.$active_business_name.' Products</b>
          <ul class="fancyList1">
            <li><a href="product_list.php?a=retail&type=producer_list">Listed&nbsp;Retail</a></li>
            <li><a href="product_list.php?a=wholesale&type=producer_list">Listed&nbsp;Wholesale</a></li>
            <li><a href="product_list.php?a=unfi&type=producer_list">Listed&nbsp;UNFI</a></li>
            <li><a href="product_list.php?a=unlisted&type=producer_list">Unlisted</a></li>
            <li class="last_of_group"><a href="product_list.php?a=archived&type=producer_list">Archived</a></li>
            <li class="last_of_group"><a href="edit_products.php?producer_id='.$_SESSION['producer_id_you'].'">Add A New Product</a></li>
            <li class="last_of_group"><a href="edit_inventory.php">Manage Inventory</a></li>
          </ul>
        </div>';
  }
$display .= '
      <div id="all_producers">
        <div class="title">General producer links</div>
          <img src="grfx/producers.png" width="32" height="32" align="left" hspace="2" alt="Food Stamps"><br>
          <b>Manage Producers and Products</b>
          <ul class="fancyList1">
            <!-- <li><a href="edit_prdcr_list.php">Producer/Product List</a></li> -->
            <li><a href="product_list.php?type=confirm">Confirm Changed Products</a></li>
            <li><a href="edit_info_list.php">Edit Producer Info</a></li>
          </ul>
          <img src="grfx/kcron.png" width="32" height="32" align="left" hspace="2" alt="Delivery Cycle Functions"><br>
          <b>Delivery Cycle Functions</b>
          <ul class="fancyList1">
            <li class="last_of_group"><a href="orders_prdcr_list.php?delivery_id='.ActiveCycle::delivery_id().'">Producers with Customers this Cycle</a></li>
          </ul>
          <img src="grfx/bottom.png" width="32" height="32" align="left" hspace="2" alt="Producer Membership Information"><br>
          <b>Producer Membership Information</b>
          <ul class="fancyList1">
            <li><a href="producers_pending.php">Pending Producers</a></li>
            <li class="last_of_group"><a href="producer_applications.php">Producer Applications</a></li>
          </ul>
          <img src="grfx/report.png" width="32" height="32" align="left" hspace="2" alt="Manage products"><br>
          <b>Reports</b>
          <ul class="fancyList1">
            <li> <a href="producers_labels.php">All Producers</a></li>
            <li><a href="prdcr_list_email.php">Producer Email Addresses</a></li>
            <li><a href="coopproducers.php">Producer Contact Info</a></li>
            <li class="last_of_group"> <a href="report_members.php?p=1">Download a Spreadsheet of All Members/Producers</a></li>
          </ul>
<!--        <img src="grfx/invoices.png" width="32" height="32" align="left" hspace="2" alt="Available Products"><br>
          <b>Printable Product Lists</b>
          <ul class="fancyList1">
          <li><strike><a href="printprod_new.php" target="_blank">New Products</a></strike></li>
          <li><strike><a href="printprod_changed.php" target="_blank">Changed Products</a></strike></li>
          <li><strike><a href="printprod_deleted.php" target="_blank">Unlisted Products</a></strike></li>
          <li class="last_of_group"><strike><a href="printprod_list_all.php" target="_blank">Full Product List</a></strike></li>
          </ul>-->
        </div>
        </td>
      </tr>
    </table>';


$page_specific_css .= '
<style type="text/css">
#this_producer {
  border:3px solid #ddd;
  padding:0.5em;
  }
#all_producers {
  margin-top:1em;
  border:3px solid #ddd;
  padding:0.5em;
  }
</style>';


$page_title_html = '<span class="title">'.$active_business_name.'</span>';
$page_subtitle_html = '<span class="subtitle">Producer Admin Panel</span>';
$page_title = $active_business_name.': Producer Admin Panel';
$page_tab = 'producer_admin_panel';

include("template_header.php");
echo '
  <!-- CONTENT BEGINS HERE -->
  '.$display.'
  <!-- CONTENT ENDS HERE -->';
include("template_footer.php");