2018-04-26 - Evols DBS PEOPLE

Panel RH :
- masquer les fins de contrat
- recherche directe
- affichage par entrepot de défaut
- rendre l'entrepot obligatoire
- suggestion en cas de création d'un existant

Contrats :
- heure de début
- heure de pause
- 36h, affectation à un jour de la semaine / fractionnée

Productivités :
1-Config
- configuration, par entrepot / client, des CATEGORIES >> Unités d'oeuvre  <=> Roles
- configuration des indirects de prod : affectation statique en ratio sur CATEGORIES (par client ?)

2-Fonctions de calculs
Params :
- entrepot
- société / client
- période dates

Ruptures :
- par role
- Par catégories ou développer à l'UO

Calculs :
- prod réelle
- prod théorique
- prod vendue




Evols TRAMOS
- brancher UI existante sur données DWR (SNA/SLS)




















<start>
# Optional variables for a backup script
MYSQL_USER="root"
MYSQL_PASS="something"
BACKUP_DIR=/srv/backup/$(date +%Y-%m-%dT%H_%M_%S);
test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"
# Get the database list, exclude information_schema
for db in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases' | grep -v information_schema)
do
  # dump each database in a separate file
  mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "$db" | gzip > "$BACKUP_DIR/$db.sql.gz"
done
</stop>






2016-10 InnoDB

mysql -e "SELECT concat('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'op5_dbs_prod_mach'  AND ENGINE =  'MyISAM'  AND TABLE_TYPE='BASE TABLE'" | tail -n+2 > ~/alter_inno.sql


2016-07 Terminal ?
http://www.masswerk.at/termlib/
http://dailyjs.com/2015/01/22/terminaljs/




2015-08-18 Sencha compile cmd :
sencha -sdk extjs compile -classpath=extjs/packages/ext-charts/src,js/ux,js/ext,js/sch,js/app,app.js -debug=false page --compress -in=index.html -out=build/index.html


********* Desktop 1304 ***********

2013-04-12 Model vs Store :
http://stackoverflow.com/questions/7404870/extjs-how-to-use-proxy-model-how-are-they-related


2013-07-15 buffered store with local sorting (client-side)
http://stackoverflow.com/questions/11037540/buffered-store-with-local-sorting-client-side
QueryResultPanel


2013-07-17 Weird behavior of MemoryProxy with embeddedgrid + feature RowBody
- utilisation de la feinte Ext.calendar , override updateOperation + sync() à chaque operation


2013-07-18   LIMIT 1 inside JOIN from specific tables in MySQL?
http://stackoverflow.com/questions/4115057/limit-1-inside-join-from-specific-tables-in-mysql
Example :
select o.outbound_id , o.product,o.date, p1.price,p1.date,p2.price,p2.date 
FROM outbound o 
LEFT OUTER JOIN price p1 ON p1.product=o.product AND o.date > p1.date
LEFT OUTER JOIN price p2 ON p2.product=p1.product AND o.date > p2.date AND p2.date>p1.date 
WHERE 1 
AND p2.date IS NULL
ORDER BY outbound_id;



2013-08-31 : paracrm_lib_data_file_join.inc.php

- Chargement de la map, OK.
- Identification des valeurs flottantes (=>dates)
	- pour chaque field concerné, chargement de toutes les valeurs distinctes (maximum ???)

- Etape 1 : calcul du HASH selon le join Map

- Etape 2 : recherche de la valeur dans le cache





2013-09-19 : Grid.Panel w/ local store hangs loading

tmp fix : 
commit 88d9dc904d8361d23bf16abfbe1bf64af5730053
Author: Damien Mirand <dm@mirabel-sil.com>
Date:   Thu Sep 19 04:40:58 2013 +0200
    JS - CRM QueryResult, pagingScroller fix

possible fix (not working) :
/*
* Bug EXTJSIV-6988
* fixed in 4.1.2
* http://www.sencha.com/forum/showthread.php?230125-Buffered-store-w-grid-locks-up-in-loading&p=856067&viewfull=1#post856067
* override purpose : remove "me.loading" after beforeprefetch firing
*/