Local Food Coop Software

Local Food Cooperative Software

The Jist: This software operates on an order cycle instead of an “always open” system. Producers/farmers can log in and add products to their product catalog at anytime for sale. During a designated time, cooperative members place orders.

Home • Who’s Using It? • Downloads • How to Help • Other Resources

Always make back-ups before applying changes.

_v1.4.2 "Ketchup"_

This is a "catch-up" release that includes several small updates and a few additions and bug fixes.

Features

Member balance calculation bug fix
Allow administrator users to edit general delivery information in admin area
Update for MySQL 5
Add table heading and page break (for PDFs) for when storage codes change within a producer invoice. This enables the frozen items of an invoice to be handled by a different person than refrigerated or non-refridgerated items on delivery day.
Allow an email to go out to new members when they're approved
Update so storage code updates made by producers are applied immediately to public product list
Defined constants added to config files
Orders per hub report added
New option to download a spreadsheet of all members or only producers

Contributors to this Update

Roy Guisinger, Lisa Cross, Ben Anderman, Emma McCauley.

_v1.4.2 Database Changes _

ALTER TABLE `transactions` CHANGE `transaction_batchno` `transaction_batchno` INT UNSIGNED DEFAULT NULL;
ALTER TABLE `members` CHANGE `address_line1` `address_line1` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;
ALTER TABLE `members` CHANGE `address_line2` `address_line2` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;
ALTER TABLE `members` CHANGE `work_address_line1` `work_address_line1` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `members` CHANGE `work_address_line2` `work_address_line2` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci;
UPDATE `subcategories` SET `subcategory_name` = 'Paper Supplies, Notecards, Office' WHERE `subcategory_id` = '111' LIMIT 1 ;

_v1.4.2 Changes to Files_

Member Balance Function bug fix
shop/admin/member-balance-function.php

Find the two places in the file with this line, around lines 106 and 115:
WHERE transaction_type = ttype_id and ttype_parent = '20'

Add at the end of those lines:
AND tt.ttype_whereshow = 'customer'
Allow Administrator Users Edit General Delivery Info
shop/admin/index.php

Find this around line 45:
session_register("admin_member_id");

Add this on the next line:
session_register("auth_type");

shop/admin/delivery_editroute.php

Find this around lines 9 and 19:
if($admin_member_id==$rtemgr_member_id){

Update both to this:
if($admin_member_id==$rtemgr_member_id || $_SESSION['auth_type']=='administrator'){
Producer Class Update for MySQL 5
shop/admin/libraries/producer.class.php

Find this around lines 66-67:
FROM $table_basket, $table_prod, $table_subcat,
$table_basket_all, $table_mem, $table_rt, $table_delcode

Put parentheses around the list of tables, like this (since it is followed by a LEFT JOIN):
FROM ($table_basket, $table_prod, $table_subcat,
$table_basket_all, $table_mem, $table_rt, $table_delcode)

Add Table Heading and Page Break (for PDFs) for when Storage Codes change within a Producer Invoice
shop/admin/libraries/producer.class.php

Find around line 123:
if($sc==$row['storage_code'] && $m==$member_id){

Paste this in ABOVE that line:

  if($sc && $sc!=$row['storage_code']){
    	$display .= '</table>
    	<HR BREAK>
    	<table width="100%" cellpadding="4" cellspacing="0" border="0">
  <tr>
    <th valign="bottom">PrdID</th>

    <th valign="bottom">Member</th>
    <th valign="bottom">Quantity</th>
    <th valign="bottom">(Add Later)<br>Weight</th>
    <th valign="bottom">Extra<br>Charge</th>
    <th valign="bottom">In/Out of Stock</th>

    <th valign="bottom">Total Item Price</th>
    <th valign="bottom">Edit Item</th>
  </tr>';
    }

Allow an email to go out to new members when they're approved
shop/admin/process_pending.php

Find on lines 303 and 428:
//sendApprovalEmail($member_id);

Uncomment so the email will go out:
sendApprovalEmail($member_id);

Product Editing - storage code updates applied immediately to public product list
shop/func/edit_product_screen_updatequery.php

Find the product_list update query that starts with '$sqlu2 = "UPDATE $table_prod SET ' around line 81. Put the update query inside an if statement to check if the product is in product_list table yet and add the storage_id to the update query. It should read like this:

  $sql = mysql_query("SELECT product_id FROM ".$table_prod." WHERE product_id = '".$product_id."'");
  if(mysql_num_rows($sql)>0){
    
    	$sqlu2 = "UPDATE $table_prod SET 
    	storage_id = \"$storage_id\",
    	inventory_on = \"$inventory_on\",
    	inventory = \"$inventory\"
    	WHERE producer_id = '$producer_id'
    	AND product_id = '$product_id'";
    	$resultu2 = @mysql_query($sqlu2,$connection) or die(mysql_error());
  }

Stripslashes in Customer Notes in Admin Area
shop/admin/query_notes.php

Find around line 72:
$notes = $row['customer_notes_to_producer'];

Replace with:
$notes = stripslashes($row['customer_notes_to_producer']);
Additional Display clean-up for producer names

shop/members/edit_prdcr_list.php

Config Files Update
Add defined constants (click for details below)
config_foodweb.php and config_foodweb_orders.php
Product Lists - PDF product list file update
shop/pdf.php

Remove all definition lines: define("CONSTANT", "Hello world.");
Replace with: include('../../config_foodweb.php');
Locations File Update
shop/locations.php

Find on line 2:
include("../../config_connect.php");

Replace with:
include('../../config_foodweb.php');
Producer Template
shop/template_prdcr.php

Remove line 3: $page_name = $PHP_SELF;

Find:
$producer_id = substr($page_name, -9, -4);

Replace with:
$producer_id = substr($_SERVER['PHP_SELF'],strrpos($_SERVER['PHP_SELF'],'/')+1,-4);
Spacing update
shop/members/edit_contact.php

Find line 21:
please email<a href

Replace with:
please email <a href

_v1.4.2 New Files_

New option to download a spreadsheet of all members or only producers
Upload new file: shop/admin/report-members.php

Add a link to it from this file: shop/admin/index.php
Find around line 72:
<li><a href="coopproducers.php">Producer Contact Info</a></li>

Add after that line:
<br /><br />
<li> <a href="report-members.php?p=1">Download a Spreadsheet of All Members/Producers</a></li>
Orders Per Hub Report
Upload new file: shop/admin/orders_perhub.php
No linking up necessary, link is already in place from admin main menu, file was missing out of previous release.

_v1.4.2 Changed Files Details_

Changed files:

config_foodweb.php and config_foodweb_orders.php
After adding the below info to the config files, you can do a find and replace on email addresses and files paths to use variables, but it's not necessary. This update is to help future code added to version 1 to move towards the way version 2 is set up.
Add (don't delete what's there, just add above what's there and update the database and path info to yours):

define("DB_NAME", "database_name");

define("HOST_NAME","localhost");
define("MYSQL_USER","username");
define("MYSQL_PASS","password");

//Table aliases
define("TABLE_PRODUCT", "product_list");
define("TABLE_MEMBER","members");
define("TABLE_PRODUCER","producers");
define("TABLE_CATEGORY", "categories");
define("TABLE_CUSTOMER_SALESTAX", "customer_salestax");
define("TABLE_SUBCATEGORY","subcategories");
define("TABLE_BASKET","customer_basket_items");
define("TABLE_BASKET_ALL","customer_basket_overall");
define("TABLE_PRODUCER_TOTALS", "producer_totals");
define("TABLE_AUTH",TABLE_MEMBER);//authentication tokens are in the member table
define("TABLE_DELCODE", "delivery_codes");
define("TABLE_DELDATE", "delivery_dates");
define("TABLE_DELTYPE", "delivery_types");
//define("TABLE_CURDEL", "current_delivery");
define("TABLE_ROUTE", "routes");
define("TABLE_PAY", "payment_method");
define("TABLE_FUTURE_DELIVERY", "future_deliveries" );
define("TABLE_ADJ", "adjustments");
define("TABLE_SALES_TAX", "sales_tax");
define("TABLE_ZIP_CITYTAXNO","zip_citytaxno");
define("TABLE_ZIP_COUNTYTAXNO","zip_countytaxno");
define("TABLE_PRODUCT_PREP", "product_list_prep");
define("TABLE_PRODUCT_PREV", "product_list_previous");
define("TABLE_PRODUCT_TYPES", "production_types");
define("TABLE_HUBS", "hubs");
define("TABLE_HOW_HEARD", "how_heard");
define("TABLE_AUTH_LEVELS", "authentication_levels");
define("TABLE_SUBCAT_MAP", "product_list_subcategories");
define("TABLE_TRANSACTIONS", "transactions");
define("TABLE_TRANS_TYPES", "transactions_types");

//field aliases for Security.class
define("FIELD_USER", "username_m");
define("FIELD_PASS","password");
define("FIELD_AUTH_TYPE","auth_type");	

//Directory aliases for graphics, forms, etc
define("DIR_FORMS","forms/");
define("DIR_GRAPHICS","grfx/");
define("DIR_LOGOS", "logos/");
define("DIR_PROD_IMAGES","prod_images/");
define("DIR_PRODUCERS", "producers/");
define("DIR_MEMBERS", "members/");

//General page information
define("BASE_URL","http://www.yourdomainname.org");
define("PATH","/shop/");
define("FILE_PATH","/home/yourusername/public_html");
define("PATH_PRDCR","producers/");
define("PATH_PDF","pdf/");
define("PATH_INVOICES","invoices/");
define("PATH_ADMIN","admin/pdf/");
define("MEMBER_LOGIN_PAGE", BASE_URL.PATH, false);
define("MEMBERSHIP_PAGE", BASE_URL.PATH."/join.php");//to refer membership questions
define("LOCATIONS_PAGE", BASE_URL.PATH."/locations.php");//to refer membership questions
define("DOMAIN_NAME","yourdomainname.org");
define("SELF",$_SERVER['PHP_SELF']);
define("SITE_NAME", "Local Food Cooperative");
define("PER_PAGE", 50); //default number of search results per page


define("CUSTOMER_EMAIL","customer@".DOMAIN_NAME);
define("GENERAL_EMAIL", "info@".DOMAIN_NAME, false);
define("HELP_EMAIL", "help@".DOMAIN_NAME, false);
define("MEMBERSHIP_EMAIL", "membership@".DOMAIN_NAME, false);
define("ORDER_EMAIL", "orders@".DOMAIN_NAME, false);
define("PAYPAL_EMAIL","paypal@".DOMAIN_NAME);
define("PRICELIST_EMAIL", "pricelist@".DOMAIN_NAME, false);
define("PROBLEMS_EMAIL","problems@".DOMAIN_NAME);
define("PRODUCER_CARE_EMAIL", "producer-care@".DOMAIN_NAME, false);
define("SOFTWARE_EMAIL", "software@".DOMAIN_NAME, false);
define("STANDARDS_EMAIL", "standards@".DOMAIN_NAME, false);
define("TREASURER_EMAIL", "treasurer@".DOMAIN_NAME, false);
define("VOLUNTEER_EMAIL","volunteer@".DOMAIN_NAME);
define("WEBMASTER_EMAIL", "web@".DOMAIN_NAME, false);

Local Food Cooperative Software

___v1.4.2 "Ketchup"___

Features

Contributors to this Update

___v1.4.2 Database Changes ___

___v1.4.2 Changes to Files___