jmueller17/aixada

Aixada helps self-managed consumption cooperatives to organize their flow of products, money, and information.

aixada's Issues

deactivate product

When deactivating an entire product under Manage > Products > De/active which already has ordered items these need to be deleted as well. This is identical as when deactivating only a single cell (date/product).

Provider without UF is not listed

Hi,
I was trying to setup aixada providers so, first, I wanted to add all provider and later attach a UF. I've realised thant you can add new provider without UF but then is not possible to see it on the list as they don't have UF (manage_providers.php?).

Of course, I've sorted out adding UF to database.

Salutacions,
Xavi

theme específic per aixada

(No se si és el millor lloc on posar això)
Vaig conèixer el projecte a una reunió amb la resta de coopes al xing. M'encanta el projecte, tot i que la nostra coope és tan jove i petita (de moment) que em sembla que trigarem a utilitzar una eina amb tantes opcions. O no, l'assemblea dirà.

Ara m'he animat a instalar-me'l (de moment per diversió) i no m'he pogut estar de voler contribuir d'alguna manera. I com que no hi entenc gaire de js ni de php... a veure si puc aportar alguna cosa al css. De moment, un theme, cooperatheme: PauKokura#1
(He fet un fork per no enredar amb la part de desenvolupament. Per no molestar gaire, vaja)
Salut i agroecologia! 🌴

finalizing preorder sets order_items to null

when finalizing a preorder, the order_id in aixada_order_item is set to null causing to appear duplicated orders in the order listing (if they have been closed and send off already).

Borrado de miembros

Cuando eliminas un miembro de la unidad familiar, sigue apareciendo en la lista de Miembros. Si haces clic sobre ese miembro que no tiene UF asignada, no se muestran datos de usuario, la pantalla se queda en blanco sólo con el encabezado. No hay forma de eliminar un usuario
definitivamente.

Credentials validation

Apparently the password validation on the main page only takes the first 8 characters of the password into account. If your password is "ThisIsMe555" you can also access that account using "ThisIsMe973" or "ThisIsMeANYTHING".

illegal collation in mysql during installation

After installation following the exact steps of the instructions in the wiki I got to the web browser and open ourdomain.coop/aixada and I see the Aixada header and login box at the right hand. Great so far! When trying to login with admin&admin I get this error:

CALL check_credentials('admin','axgSb.Vaqch9E') generated error 1267:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_unicode_ci,IMPLICIT) for operation '='

Thanks for your quick help in resolving this error!

Product activation problem

I'm trying to activate products, but I couldn't.
When I try to select provider from the top right list, it appears void. See image:

(and I have 2 providers, both with products)

finish web installer

finish the web installer wizard.

Product edit form fields needed to change to refelct its real value

When adding few products in a row for the same provider, the selects of "Responsible HU", "Buy unit" and "Sell unit" displays the value of the previous entered product. When clicking on "Save" those fields raise the error that they cannot be left empty, though.

I suspect the select displays a value from the previous page load but that value is not stored in the data structure that got validated before saving. I have not enough knowledge of the code to start looking at this issue. Guidelines will be welcome :)

A temporary workaround is to go back to providers list (explicitly reloading /manage_providers.php) and start over. That's a PITA when we have a few products to enter for the same provider and responsability of the same household.

width of revision order table

the revision order table can get quite wide. would need a way to collapse the UF columns in order to compare product item column (first) with the total (revised) order column. Either hide the UF columns or use title to put the product name at the end column, or use the total(revised) column directly after the product column.

Missing files

So I'm trying to install the database, but some files appear to be missing. Instead of copying them myself I'll put up the comment here, because probably the files I have are outdated already.

It looks like the whole js/ directory is missing:

Here's the error log:
[Tue May 22 00:46:43 2012] [error] [client 127.0.0.1] File does not exist: /var/www/aixada/css/ui-themes/redmond, referer: http://localhost/aixada/login.php?originating_uri=/aixada/
[Tue May 22 00:46:43 2012] [error] [client 127.0.0.1] File does not exist: /var/www/aixada/js/jqueryui/jqueryui.js, referer: http://localhost/aixada/login.php?originating_uri=/aixada/
[Tue May 22 00:46:43 2012] [error] [client 127.0.0.1] Symbolic link not allowed or link target not accessible: /var/www/aixada/js/jquery/jquery.js, referer: http://localhost/aixada/login.php?originating_uri=/aixada/
[Tue May 22 00:46:44 2012] [error] [client 127.0.0.1] File does not exist: /var/www/aixada/js/jqueryui/jqueryui.js, referer: http://localhost/aixada/login.php?originating_uri=/aixada/

product edit form

does not adequately reflect db values in the HTML selects. The question is if a rewrite of the provider overview and create/edit as well as the product create/edit would not improve things. jqgrid could still work in the background for other tables.

Alpha sorting units of measure

The drop down for units of measure in the product add/edit section could be alphasorted by unit description rather than by ID.

Stats reports

Visualize evolution of prices and other common statistics.

create pdfs directly

for incidents or orders using php pdf libraries.

Missing table on install 'aixada_order_item'

After installing a clean setup (using
Pop up with text:
An error "CALL get_orders_listing('2012-07-29','9999-12-30','1','0') generated error 1146: Table 'aixada.aixada_order_item' doesn't exist", status "error" occurred during loading data: CALL get_orders_listing('2012-07-29','9999-12-30','1','0') generated error 1146: Table 'aixada.aixada_order_item' doesn't exist

Products with different buy units: aggregation from individual orders

We're testing Aixada for using it on our local cooperative and it mostly fits all of our needs. The only thing we're having issues with is one of our providers.

That provider sells stuff in big packaging (like say: 25kg) and small/medium ones (3 or 5kg) for the same product. The big packaging has a better price. When managing orders from families we want to aggregate those individual orders (ie. orders of 1, 5 or 11.5kg) and then select which packaging combo fits better in order to get a lower price.

I know that's a very special case that's obviously not coded into Aixada. I can code, so may you give me some comments about the problem and where may I start to dig into the code for implementing a possible solution to it?

Thanks,

Currency symbol

As you can see in this picture:

The currency symbol is euro by default.

It's very important to have the hability to change that symbol, to another, for example: dollar, peso (are the same), pound, krona, etc..

where is 'install.php'

Hi all,
thanks for all your efforts developing this nice tool.

We would like to install aixada on a server where we don't have full access so we need to user 'install.php' but this last version doesn't include it. Is that ok ? May we are doing something wrong?

thanks
Xiquetam

Standing / permanent order

Add an option to products (inherited from the provider) to make them a standing or permanent order. So, the user orders it once and every time at the periodic delivery interval, he/she receives his order. This is then an order that the user should make just once - and can adjust sporadically when needed. This way, families don't need to think about the basic needs like bread, eggs, milk, yoghurt, it automagically arrives at the warehouse :)

Now the frequency of deliveries may vary by provider: can be weekly, biweekly or monthly.

Installation about CDMON hosting: create new provider issue

When we try to create a new provider, there are an error:

INSERT INTO aixada_provider (active,name,nif,contact,address,city,zip,phone1,phone2,email,web,notes,responsible_uf_id,bank_name,bank_account,offset_order_close,__utma,__utmz) VALUES ('1','errer','','','','','','333333333','','[email protected]','','','1','','','','50364397.1107340903.1355312469.1355339808.1355348979.4','50364397.1355348979.4.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=mantas huerto'); generated error 1054: Unknown column '__utma' in 'field list'

It seems that these fields are added by our url has Analitycs google scripts from another application installed

The cure is to modify the php file php/ctrl/TableManager.php to delete fields __utma and __utmz

$ignore_keys = array('oper' => 1, 'table' => 2, 'key' => 3, 'val' => 4,
'USERAUTH' => 5, 'PHPSESSID' => 6, 'logintheme' => 7,
'cprelogin' => 8, 'cpsession' => 9, 'lang' => 10,
'langedit' => 11, '__utma'=>12, '__utmz'=>13);

Language issues

As I can see, there are some language issues, for examble in the image below:

You can see spanish texts, marked with red and english texts marked with blue.

question about the provider don't bring all product

When the provider brings the products to the consumer group, and we review the goods has arrived, if the provider has not brought all the products, can we fix the products that has come into the program Aixada? to review the order of the provider, and press the button Received, the program displays the list of products that have been asked the provider, but if we change any amount, in total or in UF, the value is not changed. Do not know if it's because the program does not allow it, because it is a bug, or because there is something we are doing wrong
Thanks in advance
Acacio

Alpha sorting elements in the Manage lists

I just realised that it's not possible to alpha sort elements in any of the lists with products, UFs, providers, etc. Perhaps this could be implemented along with a filter feature so that you can view only those providers/products which a specific UF is responsible for.

summary of purchases by provider

see validated total amount per provider not just for orders but for purchases for specific date.

ignore config.php and remove

How do you manage not to commit the config.php file?

I was thinking of renaming it to config.php.sample and adding a line instructing to duplicate the file and rename it to config.php, and including this config.php in the .gitignore.

In this way there will not be a possibility of accidentally committing my credentials or modifying the real config.php, everybody should have their own only. This is how Wordpress handles it.

This would need updating also the installation instructions page

What do you think @jmueller17 @julian-git ?

Alpha sorting elements in the Manage lists

Sorry - Duplicate! Please close and take action on #34

usability of stock page

Needs save button or clear indication of how to save add/edit stock

Cart does not disappear after validation

Sometimes, a validated cart does not disappear from the list of to-do validations even though it has been validated and the due-amount has been charged to the Household account.

One possible explanation for this bug could be that a user is logged in, and viewing the shopping page with the full cart. Since the cart saves automatically every X min. it could happen that the cart gets validated and then automatically saved again - in which case it would not disappear from the to-validate list?

min order

default minimum order to be reached for each product. Used to filter out order items in the reports if minimum is not reached.

Missing or wrong parameter name: date in URL

Using current master branch after installing and getting the error reported in #4 on clicking on "Fes una incidencia' (''Report an issue' in english, i guess) i get another pop up.

An error "get_param: Missing or wrong parameter name: date in URL", status "error" occurred during loading data: get_param: Missing or wrong parameter name: date in URL

order of iva/tax display

in validation cart change order of how tax is displayed: first total, then amount of tax included.

select + print incidents

introduce checkboxes for incidents listing - to print/download selected.

hosting?

Anyone can recommend me some free/unexpensive/secure hosting to be used? I would prefer not to host aixada in my own/"private" space, as its a potential problem for me and/or the rest of people when i leave te cooperative. I think its a common question in collectives, so maybe some of you has an answer.

incidents email functionality

send out incidents directly when internet is available. needs to be implemented.

Añadir nuevo miembro a UF - Validación de nombre

• En la gestión de la UF, pulsa en Nuevo miembro
• Si introduces una cadena de más de 15 caracteres en el campo Nombre, no pasa la validación y sale mensaje de error diciendo que falta el nombre.

Idioma

¡Hola! Te escribo desde Valladolid, que estamos investigando la posibilidad de pasar nuestra red de consumo a L'Aixada... y he empezado con mal pie, me temo: una vez instalado en el servidor de mi cooperativa, accedo a 'settings' pero no me aparece la posibilidad de elegir el idioma 'castellano' ¿alguna sugerencia?

Gracias por la ayuda y enhorabuena por el trabajo, que tiene una pinta interesantísima

Añadir nuevo miembro a UF

Si falta únicamente el nombre y le das a guardar, la validación te dice también que faltan teléfono e email, aunque esos dos campos tengan valores correctos.

can't empty out order cart

when saving an empty order cart (after deleting all items) the sql throws an error. tmp work around: put quantity of last item to 0 and save

automatically copy responsible UF

when creating a new product for a given provider the responsible household should be copied automatically to the product in the corresponding select box

images for products

activate images for products: upload functionality and then show images option for buy/order products.

extra order fees

transportation or other additional fees need to be added to individual orders. options to distribute/add extra cost to ordered items or not.

canned queries filter length

the filter parameter for the canned queries is set to char(100) for example in aixada_provider_list_all_query. Since we pass product_ids or provider_ids for the export function this may get larger than 100 chars...! Should be changed to char(255) or even more???

Installation about CDMON hosting: language issue

After installing the development version, and enter the first time with the admin user, seems all right, but on entering My Account -> Settings, the language field appears with a list of the type (0). Any change made on the configuration, save a 0 in the table aixada_user languaje. This makes the following login with the admin user, generate errors because the program is not able to locate a file 0.php languages.
The solution was to modify the php file /utilities/general.php, I have set the lang file to static, so no need to read the names of the files
This solution working only works in mozilla and chrome

index type in aixada_incidents table scheme

in aixada_incidents table we have

ufs_concerned varchar(100),
commission_concerned varchar(100),
provider_concerned varchar(100),

that should be

family_unit_id integer,
commission_id integer,
provider_id integer,

import / export

import csv, xls, ods, google spreadsheets, our own xml

export xml, csv

Email order reports

Order reports should be send out automatically after the closing date for the provider/order to the responsible HU or the provider directly. There should be the possibility to add a custom message-body to the email.

default next order

When all orders have been closed for a given date, the default order date when entering the order page should be the one with at least one open provider.

revision of order

add / edit products and ufs not part of the original order.