documentation/zencart/orders__download_8php_source.html

00001 <?php
00009 if (!defined('IS_ADMIN_FLAG')) {
00010   die('Illegal Access');
00011 }
00012   // select downloads for current order
00013   $orders_download_query = "select * from " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " where orders_id='" . (int)$_GET['oID'] . "'";
00014   $orders_download = $db->Execute($orders_download_query);
00015
00016 // only display if there are downloads to display
00017   if ($orders_download->RecordCount() > 0) {
00018 ?>
00019       <tr>
00020         <td class="main"><table border="1" cellspacing="0" cellpadding="5">
00021           <tr>
00022             <td class="smallText" align="center"><?php echo TEXT_LEGEND; ?></td>
00023             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_AVAILABLE . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_CURRENT); ?></td>
00024             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_EXPIRED . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED); ?></td>
00025             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_MISSING . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_MISSING); ?></td>
00026           <tr>
00027             <td colspan="4" class="smallText" align="center"><strong><?php echo TEXT_DOWNLOAD_TITLE; ?></strong></td>
00028           </tr>
00029           <tr>
00030             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_STATUS; ?></td>
00031             <td class="smallText" align="left"><?php echo TEXT_DOWNLOAD_FILENAME; ?></td>
00032             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_MAX_DAYS; ?></td>
00033             <td class="smallText" align="center"><?php echo TEXT_DOWNLOAD_MAX_COUNT; ?></td>
00034           </tr>
00035 <?php
00036 // add legend
00037     while (!$orders_download->EOF) {
00038       // $order->info['date_purchased'] . ' vs ' . (zen_date_diff($order->info['date_purchased'], date('Y-m-d')) > $orders_download->fields['download_maxdays'] ? 'NO' : 'YES') . ' vs ' .
00039       switch (true) {
00040         case ($orders_download->fields['download_maxdays'] <= 0 && $orders_download->fields['download_count'] <= 0):
00041           $zc_file_status = TEXT_INFO_EXPIRED_DATE . '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_on=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED) . '</a>';
00042           break;
00043         case ($orders_download->fields['download_maxdays'] != 0 && (zen_date_diff($order->info['date_purchased'], date('Y-m-d')) > $orders_download->fields['download_maxdays'])):
00044           $zc_file_status = TEXT_INFO_EXPIRED_DATE . '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_on=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED) . '</a>';
00045           break;
00046         case ($orders_download->fields['download_maxdays'] == 0):
00047           $zc_file_status = '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_off=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_CURRENT) . '</a>';
00048           break;
00049         case ($orders_download->fields['download_maxdays'] > 0 and $orders_download->fields['download_count'] > 0):
00050           $zc_file_status = '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_off=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_CURRENT) . '</a>';
00051           break;
00052 /*
00053         case ($orders_download->fields['download_maxdays'] <= 1 or $orders_download->fields['download_count'] <= 1):
00054           $zc_file_status = TEXT_INFO_EXPIRED_COUNT . '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_on=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED) . '</a>';
00055           break;
00056 */
00057         case ($orders_download->fields['download_maxdays'] !=0 && $orders_download->fields['download_count'] <= 1):
00058           $zc_file_status = TEXT_INFO_EXPIRED_COUNT . '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_on=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED) . '</a>';
00059           break;
00060         default:
00061           $zc_file_status = '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit&download_reset_on=' . $orders_download->fields['orders_products_download_id'], 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_STATUS_EXPIRED) . '</a>';
00062           break;
00063           break;
00064       }
00065
00066 // if not on server show red
00067       if (!zen_orders_products_downloads($orders_download->fields['orders_products_filename'])) {
00068         $zc_file_status = zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF);
00069       }
00070 ?>
00071           <tr>
00072             <td class="smallText" align="center"><?php echo $zc_file_status; ?></td>
00073             <td class="smallText" align="left"><?php echo $orders_download->fields['orders_products_filename']; ?></td>
00074             <td class="smallText" align="center"><?php echo $orders_download->fields['download_maxdays']; ?></td>
00075             <td class="smallText" align="center"><?php echo $orders_download->fields['download_count']; ?></td>
00076           </tr>
00077 <?php
00078         $orders_download->MoveNext();
00079     }
00080 ?>
00081       </table></td>
00082     </tr>
00083 <?php
00084   } // only display if there are downloads to display