We have a formula for shifts and a list of people, we need to fill a calendar with them.<\/p>\n
These are the iterations for each week “formula.txt”, each row is a week, the first value is the iteration number, the other 4 values in the row are the number for a team member, these iterations are the sequence of combinations so that people are not oncall too frequently:<\/p>\n
1 1 2 3 4
\n2 5 6 7 8
\n3 4 3 2 1
\n4 8 7 6 5
\n5 2 1 4 3
\n6 6 5 8 7
\n7 3 4 1 2
\n8 7 8 5 6<\/p>\n
the numbers for the team members are in “roster.txt”:<\/p>\n
1 FFlinstone \u00a0\u00a0 XXJA01
\n2 Jdoe \u00a0\u00a0 XXJD02
\n3 OOsbourne \u00a0\u00a0 XXHR01
\n4 AHitchcock \u00a0\u00a0 XXDD02
\n5 ARose \u00a0\u00a0 XXAW04
\n6 EAPoe \u00a0\u00a0 XXFP01
\n7 ACooper \u00a0\u00a0 XXBC06
\n8 BJovi \u00a0\u00a0 XXSL01<\/p>\n
this is “oncall.ksh”<\/p>\n
#!\/bin\/bash<\/p>\n
start_date=20120604
\nend_date=20120902
\nformula_current_row=5<\/p>\n
formula_rows=8<\/p>\n
get_roster()
\n{
\nfor p in `grep ^$1 formula.txt | awk ‘{ print $2″ “$3” “$4” “$5 }’`;do
\necho -n “`grep ^$p roster.txt|awk ‘{ print $3″ ” }’`”
\ndone
\necho “”
\n}<\/p>\n
get_weekend_roster()
\n{
\nfor p in `grep ^$1 formula.txt | awk ‘{ print $2″ “$3” “$2” “$3 }’`;do
\necho -n “`grep ^$p roster.txt|awk ‘{ print $3″ ” }’`”
\ndone
\necho “”
\n}<\/p>\n
get_oncall()
\n{
\ntmpw=0
\nW=`date -d “$start_date $tmpw day” +”%W”`
\nfor ((tmpw = 0; $(date -d “$start_date $tmpw day” +%s) <= $(date -d “$end_date” +%s); tmpw += 1))
\ndo
\nP=$W
\nW=`date -d “$start_date $tmpw day” +”%W”`
\nif [ “$P” != “$W” ];then
\nlet formula_current_row+=1
\nif [ $formula_current_row -gt $formula_rows ];then
\nformula_current_row=1
\nfi
\nfi
\nD=`date -d “$start_date $tmpw day” +”%Y-%m-%d\u00a0 %a%t”`
\nISWEEKEND=`echo $D|egrep -i ‘sat|sun’|wc -l`
\necho -n “$D ”
\nif [ $ISWEEKEND -gt 0 ];then
\nget_weekend_roster $formula_current_row
\nelse
\nget_roster $formula_current_row
\nfi
\ndone
\n}<\/p>\n
generate_sql()
\n{
\necho “use OnCall;”
\nget_oncall | while read l;do
\nISWEEKEND=`echo $l|egrep -i ‘sat|sun’|wc -l`
\nif [ $ISWEEKEND -gt 0 ];then
\necho $l | awk ‘{ print “insert into Detail (Date,Shift_C1_Pri,Shift_C1_Sec) values (“”$1″”,””$3″”,””$4″”) on DUPLICATE KEY UPDATE Shift_C1_Pri=””$3″”,Shift_C1_Sec=””$4″”;” }’
\nelse
\necho $l | awk ‘{ print “insert into Detail (Date,Shift_A1_Pri,Shift_A1_Sec,Shift_A2_Pri,Shift_A2_Sec) values (“”$1″”,””$3″”,””$4″”,””$5″”,””$6″”) on DUPLICATE KEY UPDATE Shift_A1_Pri=””$3″”,Shift_A1_Sec=””$4″”,Shift_A2_Pri=””$5″”,Shift_A2_Sec=””$6″”;” }’
\nfi
\ndone
\n}<\/p>\n
get_oncall
\ngenerate_sql > from_${start_date}_to_${end_date}.sql<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
We have a formula for shifts and a list of people, we need to fill a calendar with them. These are the iterations for each week “formula.txt”, each row is a week, the first value is the iteration number, the other 4 values in the row are the number for a team member, these iterations […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-694","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=694"}],"version-history":[{"count":0,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/694\/revisions"}],"wp:attachment":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=694"},{"taxonomy":"post_tag","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}