12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564 |
- using System;
- using System.Collections.Generic;
- using System.Collections.ObjectModel;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows;
- using System.Windows.Controls;
- using System.Windows.Controls.Primitives;
- using System.Windows.Input;
- using System.Windows.Media;
- using System.Windows.Media.Imaging;
- using Comal.Classes;
- using InABox.Clients;
- using InABox.Configuration;
- using InABox.Core;
- using InABox.DynamicGrid;
- using InABox.Reports;
- using InABox.Core.Reports;
- using InABox.Wpf.Reports;
- using InABox.WPF;
- using Motorola.Snapi;
- using Motorola.Snapi.Constants.Enums;
- using Motorola.Snapi.EventArguments;
- using org.apache.commons.io.comparator;
- using BarcodeType = Comal.Classes.BarcodeType;
- using Color = System.Drawing.Color;
- using Image = System.Windows.Controls.Image;
- namespace PRSDesktop
- {
- /// <summary>
- /// Interaction logic for FactoryPanel.xaml
- /// </summary>
- public partial class FactoryPanel : UserControl, IPanel<ManufacturingPacket>
- {
- private Button _currentButton;
- private readonly BitmapImage barcode = PRSDesktop.Resources.barcode.AsBitmapImage();
- private readonly BitmapImage disabled = PRSDesktop.Resources.disabled.AsBitmapImage();
- //private Document document = null;
- private SetoutDocument[] documents = { };
- private readonly BitmapImage grouped = PRSDesktop.Resources.grouped.AsBitmapImage();
- private readonly string NEARLYDUE_COLOR = "Orange";
- private readonly string NOTYETDUE_COLOR = "PaleGreen";
- private readonly string OVERDUE_COLOR = "Salmon";
- private PDFEditorControl PDFEditor;
- private readonly string PRIORITY_COLOR = "Red";
- private readonly string QA_COLOR = "Silver";
- private QAGrid QAGrid;
- public List<IMotorolaBarcodeScanner> Scanners = new();
- private readonly string SELECTED_COLOR = "Yellow";
- private FactoryFloorLocalSettings settings;
- private readonly string SHARED_COLOR = "Lime";
- private readonly BitmapImage speechbubble = PRSDesktop.Resources.speechbubble.AsBitmapImage();
- private readonly BitmapImage starred = PRSDesktop.Resources.report.AsBitmapImage(48, 48);
- private readonly string TREATED_COLOR = "DarkOrchid";
- public FactoryPanel()
- {
- InitializeComponent();
- var CanConfigure = Security.IsAllowed<CanConfigureFactoryFloor>();
- Section.IsEnabled = CanConfigure;
- Station.IsEnabled = CanConfigure;
- PendingVisible = Security.IsAllowed<CanManagePendingPackets>();
- Kanbans = new ObservableCollection<ManufacturingKanban>();
- RackContents.ItemsSource = rackcontents;
- }
- public bool IsReady { get; set; }
- public void Setup()
- {
- settings = new LocalConfiguration<FactoryFloorLocalSettings>().Load();
- if (settings.Section.Equals(CoreUtils.FullGuid) && settings.Station.Equals(-1))
- {
- var user = new UserConfiguration<FactoryFloorSettings>().Load();
- settings.Section = user.Section;
- settings.Station = user.Station;
- settings.LineColor = ColorTranslator.ToHtml(Color.Red);
- settings.FontSize = 16;
- new LocalConfiguration<FactoryFloorLocalSettings>().Save(settings);
- }
- var setups = Client.QueryMultiple(
- new KeyedQueryDef<ManufacturingFactory>(),
- new KeyedQueryDef<ManufacturingSection>(
- new Filter<ManufacturingSection>(x => x.Hidden).IsEqualTo(false),
- null,
- new SortOrder<ManufacturingSection>(x => x.Factory.Sequence).ThenBy(x => x.Sequence)),
- new KeyedQueryDef<ManufacturingTrolley>(),
- new KeyedQueryDef<Employee>(
- LookupFactory.DefineFilter<Employee>(),
- new Columns<Employee>(x => x.ID, x => x.Name, x => x.UserLink.ID),
- new SortOrder<Employee>(x => x.Name)),
- new KeyedQueryDef<Shipment>(
- LookupFactory.DefineFilter<Shipment>(),
- new Columns<Shipment>(x => x.ID, x => x.Code, x => x.Description, x => x.BarCode),
- null));
- Factories = setups[nameof(ManufacturingFactory)].Rows.Select(x => x.ToObject<ManufacturingFactory>()).ToArray();
- Sections = setups[nameof(ManufacturingSection)].Rows.Select(x => x.ToObject<ManufacturingSection>()).ToArray();
- Trolleys = setups[nameof(ManufacturingTrolley)].Rows.Select(x => x.ToObject<ManufacturingTrolley>()).ToArray();
- Employees = setups[nameof(Employee)].ToDictionary<Employee, Guid, string>(x => x.ID, x => x.Name);
- var myRow = setups[nameof(Employee)].Rows.FirstOrDefault(r => r.Get<Employee, Guid>(c => c.UserLink.ID).Equals(ClientFactory.UserGuid));
- myID = myRow != null ? myRow.Get<Employee, Guid>(c => c.ID) : Guid.Empty;
- myName = myRow != null ? myRow.Get<Employee, string>(c => c.Name) : "(Unknown Employee)";
- Shipments = setups[nameof(Shipment)];
- CurrentSection = Sections.FirstOrDefault(x => x.ID.Equals(settings.Section));
- if (CurrentSection == null)
- CurrentSection = Sections.FirstOrDefault();
- var iSection = 0;
- var iCount = 0;
- foreach (var section in Sections)
- {
- if (section == CurrentSection)
- {
- iSection = Section.Items.Count;
- iCount = section.Stations; //Sections[id].Item2;
- }
- Section.Items.Add(string.Format("{0}: {1}", section.Factory.Name, section.Name));
- }
- Section.SelectedIndex = iSection;
- Station.Items.Clear();
- for (var i = 1; i <= (CurrentSection != null ? CurrentSection.Stations : 0); i++)
- Station.Items.Add(string.Format("Station #{0}", i));
- CurrentStation = settings.Station + 1;
- if (CurrentStation < 1)
- CurrentStation = 1;
- if (CurrentStation > iCount)
- CurrentStation = iCount;
- Station.SelectedIndex = CurrentStation - 1;
- SetupScanner();
- }
- public void Shutdown()
- {
- ShutdownScanner();
- //UpdateTimeTracking(true);
- LoadDrawing(null);
- }
- public void CreateToolbarButtons(IPanelHost host)
- {
- //if (Security.IsAllowed<CanViewManufacturingSelfAssessment>())
- // host.CreatePanelAction(new PanelAction() { Caption = "Self Assessment", Image = PRSDesktop.Resources.star, OnExecute = DoSelfAssessment });
- host.CreatePanelAction(new PanelAction { Caption = "Lost Time", Image = PRSDesktop.Resources.smiley, OnExecute = DoSelectLostTime });
- host.CreatePanelAction(new PanelAction
- { Caption = "Treament PO", Image = PRSDesktop.Resources.purchase, OnExecute = DoCreatePurchaseOrder });
- host.CreatePanelAction(new PanelAction
- { Caption = "Treatment Delivery", Image = PRSDesktop.Resources.barcode, OnExecute = DoScanDeliveryItems });
- host.CreatePanelAction(new PanelAction { Caption = "Select Rack", Image = PRSDesktop.Resources.forklift, OnExecute = DoSelectRack });
- host.CreatePanelAction(new PanelAction { Caption = "Close Rack", Image = PRSDesktop.Resources.forklift, OnExecute = DoCloseRack });
- host.CreatePanelAction(new PanelAction { Caption = "Scan Barcode", Image = PRSDesktop.Resources.product, OnExecute = DoScanBarcode });
- }
- public Dictionary<string, object[]> Selected()
- {
- var rows = Packets.Rows.Where(p => Kanbans.Any(k => k.Checked && p.Get<ManufacturingPacket, Guid>(c => c.ID).ToString().Equals(k.ID)));
- var pkts = rows.ToArray().Select(r => r.ToObject<ManufacturingPacket>());
- return new Dictionary<string, object[]> { { typeof(ManufacturingPacket).EntityName(), pkts.ToArray() } };
- }
- public string SectionName => "Factory";
- public DataModel DataModel(Selection selection)
- {
- var rows = (Packets == null) || (selection == Selection.None)
- ? new CoreRow[] { }
- : selection == Selection.Selected
- ? Packets.Rows.Where(p => Kanbans.Any(k => k.Checked && p.Get<ManufacturingPacket, Guid>(c => c.ID).ToString().Equals(k.ID)))
- : Packets.Rows;
- var ids = rows.Any() ? rows.Select(r => r.Get<ManufacturingPacket, Guid>(x => x.ID)).ToArray() : new[] { CoreUtils.FullGuid };
- return new ManufacturingPacketDataModel(new Filter<ManufacturingPacket>(x => x.ID).InList(ids));
- }
- public event DataModelUpdateEvent OnUpdateDataModel;
- public void Heartbeat(TimeSpan time)
- {
- // Security Descriptor should be disabled for non-manufacturing staff
- if (!Security.IsAllowed<CanTrackManufacturingHistory>() || CurrentSection == null)
- return;
- // If Lost Time is Active, let's record that
- if (LostTime != null)
- {
- var history = new ManufacturingHistory();
- history.Date = DateTime.Today;
- history.Employee.ID = myID;
- history.Packet.ID = Guid.Empty;
- history.LostTime.ID = LostTime.ID;
- history.Description = LostTime.Description;
- //history.Setout.ID = CheckedPackets[id].Item3;
- //history.Job.ID = CheckedPackets[id].Item4;
- history.Section.ID = CurrentSection.ID;
- history.Station = CurrentStation;
- history.Activity.ID = LostTime.Activity.ID;
- history.WorkDuration = new TimeSpan(time.Ticks);
- history.QACompleted = 0;
- history.WorkCompleted = 0;
- history.Window = time;
- new Client<ManufacturingHistory>().Save(history, "", (o, e) => { });
- }
- else
- {
- var CheckedPackets = new Dictionary<Guid, Tuple<DateTime, DateTime, Guid, Guid, string>>();
- foreach (var kanban in Kanbans.Where(x => x.Checked))
- {
- var packet = KanbanToPacket(kanban);
- if (packet != null)
- {
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(packet.ID)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- if (stagerow != null)
- {
- var stage = stagerow.ToObject<ManufacturingPacketStage>();
- if (stage.Station != 0)
- CheckedPackets[packet.ID] = new Tuple<DateTime, DateTime, Guid, Guid, string>(stage.Started, stage.Completed,
- packet.SetoutLink.ID, packet.SetoutLink.JobLink.ID, packet.Serial);
- }
- }
- }
- if (!CheckedPackets.Any())
- CheckedPackets[Guid.Empty] =
- new Tuple<DateTime, DateTime, Guid, Guid, string>(DateTime.MinValue, DateTime.MinValue, Guid.Empty, Guid.Empty, "No Packet");
- var updates = new List<ManufacturingHistory>();
- var slice = time.Ticks / CheckedPackets.Count;
- foreach (var id in CheckedPackets.Keys)
- {
- var history = new ManufacturingHistory();
- history.Date = DateTime.Today;
- history.Employee.ID = myID;
- history.Packet.ID = id;
- history.Description = CheckedPackets[id].Item5;
- //history.Setout.ID = CheckedPackets[id].Item3;
- //history.Job.ID = CheckedPackets[id].Item4;
- history.Section.ID = CurrentSection.ID;
- history.Activity.ID = CurrentSection.Activity.ID;
- history.Station = CurrentStation;
- if (CheckedPackets[id].Item1.Equals(DateTime.MinValue))
- history.QADuration = new TimeSpan(slice);
- else
- history.WorkDuration = new TimeSpan(slice);
- history.QACompleted = CheckedPackets[id].Item1.Equals(DateTime.MinValue) ? 0 : 0;
- history.WorkCompleted = CheckedPackets[id].Item2.Equals(DateTime.MinValue) ? 0 : 1;
- history.Window = time;
- updates.Add(history);
- }
- if (updates.Any())
- new Client<ManufacturingHistory>().Save(updates, "", (o, e) => { });
- }
- }
- public static IEnumerable<T> FindVisualChildren<T>(DependencyObject depObj) where T : DependencyObject
- {
- if (depObj != null)
- for (var i = 0; i < VisualTreeHelper.GetChildrenCount(depObj); i++)
- {
- var child = VisualTreeHelper.GetChild(depObj, i);
- if (child != null && child is T) yield return (T)child;
- foreach (var childOfChild in FindVisualChildren<T>(child)) yield return childOfChild;
- }
- }
- private void ShutdownScanner()
- {
- try
- {
- foreach (var scanner in Scanners) scanner.Actions.ToggleLed(LedMode.GreenOff);
- BarcodeScannerManager.Instance.DataReceived -= Instance_DataReceived;
- BarcodeScannerManager.Instance.Close();
- }
- catch (Exception e)
- {
- MessageBox.Show("Error Shutting down Scanner!\n\n" + e.Message);
- }
- }
- private void SetupScanner()
- {
- Scanners.Clear();
- BarcodeScannerManager.Instance.Open();
- BarcodeScannerManager.Instance.RegisterForEvents(EventType.Barcode, EventType.Pnp, EventType.Image, EventType.Other, EventType.Rmd);
- BarcodeScannerManager.Instance.GetDevices();
- foreach (var scanner in BarcodeScannerManager.Instance.GetDevices())
- {
- Scanners.Add(scanner);
- scanner.Actions.ToggleLed(LedMode.RedOn);
- scanner.Actions.SoundBeeper(BeepPattern.FastWarble);
- }
- BarcodeScannerManager.Instance.DataReceived += Instance_DataReceived;
- }
- private void Instance_DataReceived(object sender, BarcodeScanEventArgs e)
- {
- Dispatcher.Invoke(() => { ProcessCode(Scanners[(int)e.ScannerId], e.Data); });
- }
- private void ProcessCode(IMotorolaBarcodeScanner scanner, string code)
- {
- try
- {
- var isGuid = Guid.TryParse(code, out var guid);
- if (isGuid)
- {
- if (Sections.Any(x => x.ID.Equals(guid)))
- {
- IsReady = false;
- CurrentSection = Sections.First(x => x.ID.Equals(guid));
- Section.SelectedIndex = Array.IndexOf(Sections, CurrentSection);
- IsReady = true;
- Progress.Show("Changing Sections");
- DoRefresh(true);
- Progress.Close();
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FastWarble);
- }
- else if (Trolleys.Any(x => x.ID.Equals(guid)))
- {
- var trolley = Trolleys.First().Code;
- var updates = new List<ManufacturingPacket>();
- foreach (var kanban in Kanbans.Where(x => x.Checked))
- {
- var packet = KanbanToPacket(kanban);
- packet.Trolleys = trolley;
- updates.Add(packet);
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(Guid.Parse(kanban.ID)));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(packet.ID)
- && r.Get<ManufacturingPacketStage, Guid>(
- c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- pktrow.Set<ManufacturingPacket, string>(x => x.Trolleys, packet.Trolleys);
- LoadModel(kanban, pktrow, stagerow, true);
- UpdateSelectedKanban(false);
- }
- if (updates.Any())
- new Client<ManufacturingPacket>().Save(updates, "Set Trolley to " + trolley, (o, e) => { });
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.LowHigh);
- }
- else
- {
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FourLowShort);
- }
- }
- else
- {
- var shiprow = Shipments.Rows.FirstOrDefault(r => r.Get<Shipment, string>(c => c.BarCode).Equals(code));
- if (shiprow != null)
- {
- if (string.Equals(code, rackbarcode))
- {
- RackPanel.Visibility = Visibility.Collapsed;
- RackContents.ItemsSource = null;
- rackid = Guid.Empty;
- rackbarcode = "";
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.ThreeLowShort);
- }
- else
- {
- RackContents.ItemsSource = null;
- rackid = shiprow.Get<Shipment, Guid>(c => c.ID);
- rackbarcode = code;
- var rows = DeliveryItems.Rows.Where(r => r.Get<DeliveryItem, Guid>(c => c.ShipmentLink.ID).Equals(rackid)).ToArray();
- rackcontents.Clear();
- rackcontents.AddRange(rows.Select(x => x.ToObject<DeliveryItem>()));
- RackContents.ItemsSource = rackcontents;
- RackName.Content = string.Format("Rack {0}", shiprow.Get<Shipment, string>(c => c.Code));
- RackCount.Content = rows.Length.ToString();
- RackPanel.Visibility = Visibility.Visible;
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.ThreeHighShort);
- }
- }
- else
- {
- if (RackPanel.Visibility == Visibility.Visible)
- {
- var row = DeliveryItems.Rows.FirstOrDefault(r => r.Get<DeliveryItem, string>(c => c.Barcode).Equals(code));
- if (row != null)
- {
- var delitem = rackcontents.FirstOrDefault(x => string.Equals(x.Barcode, code));
- if (delitem != null)
- {
- rackcontents.Remove(delitem);
- delitem.ShipmentLink.ID = Guid.Empty;
- new Client<DeliveryItem>().Save(delitem, "Item Removed From Rack", (o, e) => { });
- row.Set<DeliveryItem, Guid>(x => x.ShipmentLink.ID, Guid.Empty);
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.HighLow);
- }
- else
- {
- delitem = row.ToObject<DeliveryItem>();
- delitem.ShipmentLink.ID = rackid;
- rackcontents.Add(delitem);
- new Client<DeliveryItem>().Save(delitem, "Item Added to " + RackName.Content, (o, e) => { });
- row.Set<DeliveryItem, Guid>(x => x.ShipmentLink.ID, rackid);
- if (Kanbans.Any(x => string.Equals(x.ID, delitem.ManufacturingPacketLink.ID.ToString())))
- ReloadPackets(true);
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.LowHigh);
- }
- RackContents.ItemsSource = null;
- RackContents.ItemsSource = rackcontents;
- RackCount.Content = rackcontents.Count.ToString();
- }
- }
- else
- {
- var id = new Client<DeliveryItem>().Query(
- new Filter<DeliveryItem>(x => x.Barcode).IsEqualTo(code),
- new Columns<DeliveryItem>(x => x.ManufacturingPacketLink.ID)
- ).Rows.FirstOrDefault()?.Get<DeliveryItem, Guid>(x => x.ManufacturingPacketLink.ID);
- if (!id.HasValue)
- {
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FourLowShort);
- return;
- }
- var kanban = Kanbans.FirstOrDefault(x => string.Equals(x.ID, id.Value.ToString()));
- if (kanban == null)
- {
- // Error - packet not visible from this station
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FourLowShort);
- return;
- }
- var stage = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(id)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section))?.ToObject<ManufacturingPacketStage>();
- if (stage == null)
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FourHighShort);
- if (stage.Station == 0) AddPacketToCurrentWorkload(stage);
- if (kanban != CurrentKanban)
- {
- CurrentKanban = kanban;
- UpdateSelectedKanban(false);
- }
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.LowHigh);
- }
- }
- }
- }
- catch (Exception e)
- {
- if (scanner != null)
- scanner.Actions.SoundBeeper(BeepPattern.FourLowShort);
- }
- }
- private void LoadDrawing(Guid? id)
- {
- if (PDFEditor != null)
- {
- PDFEditor.Document = null;
- // Unload PDF Annotations
- PDFEditor = null;
- }
- else if (QAGrid != null)
- {
- Editor.Content = null;
- // Unload QA Answers
- QAGrid = null;
- }
- if (id.HasValue)
- {
- var pktid = CurrentKanban != null ? Guid.Parse(CurrentKanban.ID) : Guid.Empty;
- var row = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(pktid));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(pktid)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- var packet = row.ToObject<ManufacturingPacket>();
- if (id.Value == Guid.Empty)
- {
- QAGrid = new QAGrid();
- var qadata = stagerow != null ? stagerow.Get<ManufacturingPacketStage, string>(c => c.FormData) : "";
- var values = string.IsNullOrWhiteSpace(qadata)
- ? new Dictionary<Guid, object>()
- : Serialization.Deserialize<Dictionary<Guid, object>>(qadata);
- if (CurrentSection != null && row != null)
- {
- var genquestions = LoadQAQuestions(packet, true, false);
- QAGrid.LoadChecks("Global Checks for " + CurrentSection.Name, genquestions, values);
- //var specquestions = LoadQAQuestions(packet, false, true);
- //QAGrid.LoadChecks(String.Format("Specific Checks for {0} [{1}] template", packet.ManufacturingTemplateLink.Name, packet.ManufacturingTemplateLink.Code), specquestions, values);
- }
- QAGrid.OnChanged += QAGridChanged;
- Editor.Content = QAGrid;
- }
- else
- {
- PDFEditor = new PDFEditorControl();
- PDFEditor.LineColor = settings.LineColor;
- PDFEditor.TextSize = settings.FontSize;
- //PDFEditor.PrintAllowed = Security.IsAllowed<CanPrintFactoryFloorDrawings>();
- PDFEditor.SaveAllowed = Security.IsAllowed<CanSaveFactoryFloorDrawings>();
- var document = documents.FirstOrDefault(x => x.DocumentLink.ID.Equals(id));
- PDFEditor.Watermark = packet.WaterMark;
- PDFEditor.Document = document;
- PDFEditor.PDFSettingsChanged += PDFEditorSettingsChanged;
- Editor.Content = PDFEditor;
- }
- }
- }
- private void DoSelectRack(PanelAction obj)
- {
- var dlg = new MultiSelectDialog<Shipment>(
- null,
- new Columns<Shipment>(x => x.ID, x => x.Code, x => x.Description, x => x.BarCode),
- false
- );
- if (dlg.ShowDialog())
- {
- var id = dlg.IDs().FirstOrDefault();
- var barcode = dlg.Data().Rows.FirstOrDefault(r => r.Get<Shipment, Guid>(c => c.ID).Equals(id))?.Get<Shipment, string>(x => x.BarCode);
- ProcessCode(Scanners.FirstOrDefault(), barcode);
- }
- }
- private void DoCloseRack(PanelAction obj)
- {
- if (!string.IsNullOrWhiteSpace(rackbarcode))
- ProcessCode(Scanners.FirstOrDefault(), rackbarcode);
- }
- private void DoScanBarcode(PanelAction obj)
- {
- var dlg = new MultiSelectDialog<DeliveryItem>(
- new Filter<DeliveryItem>(x => x.DeliveredDate).IsEqualTo(DateTime.MinValue)
- .And(x => x.ManufacturingPacketLink).LinkValid(),
- new Columns<DeliveryItem>(x => x.ID, x => x.Barcode, x => x.Description),
- false
- );
- if (dlg.ShowDialog())
- {
- var id = dlg.IDs().FirstOrDefault();
- var barcode = dlg.Data().Rows.FirstOrDefault(r => r.Get<DeliveryItem, Guid>(c => c.ID).Equals(id))
- ?.Get<DeliveryItem, string>(x => x.Barcode);
- ProcessCode(Scanners.FirstOrDefault(), barcode);
- }
- }
- private void DoScanDeliveryItems(PanelAction obj)
- {
- new DeliveryBuilder(Guid.Empty, Guid.Empty).ShowDialog();
- }
- private void DoCreatePurchaseOrder(PanelAction obj)
- {
- //Guid section = CurrentSection != null ? CurrentSection.ID : CoreUtils.FullGuid;
- //var stages = Stages.Rows.Where(row => row.Get<ManufacturingPacketStage, Guid>(col => col.ManufacturingSectionLink.ID).Equals(section) && row.Get<ManufacturingPacketStage, int>(col => col.Station).Equals(CurrentStation));
- //var ids = stages.Select(row => row.Get<ManufacturingPacketStage, Guid>(col => col.ManufacturingPacketLink.ID)).ToArray();
- var ids = Kanbans.Where(x => !x.ColorKey.Equals(QA_COLOR)).Select(x => Guid.Parse(x.ID)).ToArray();
- var treatments = new Client<ManufacturingTreatment>().Query(new Filter<ManufacturingTreatment>(x => x.Packet.ID).InList(ids));
- var window = new ManufacturingTreatmentWindow(treatments);
- if (window.ShowDialog() != true)
- return;
- Progress.Show("Creating Purchase Order");
- var order = new PurchaseOrder();
- //Supplier supplier = new Client<Supplier>().Query(
- // new Filter<Supplier>(x => x.ID).IsEqualTo(window.SupplierID),
- // new Columns<Supplier>(x=>x.ID
- //).Rows.FirstOrDefault()?.ToObject<Supplier>());
- order.SupplierLink.ID = window.SupplierID;
- order.SupplierLink.Name = window.SupplierName; //supplier != null ? supplier.Name : "Unknown Supplier";
- order.Notes = string.Format("Materials Processing Request raised by {0} from Factory Floor", Employees[myID]);
- order.RaisedBy.ID = myID;
- order.IssuedBy.ID = myID;
- order.IssuedDate = DateTime.Today;
- order.DueDate = DateTime.Today.AddDays(7);
- new Client<PurchaseOrder>().Save(order, "Created Treatment Purchase Order");
- Progress.SetMessage("Creating Consignment");
- var consignment = new Consignment();
- consignment.Number = string.Format("MFG PO {0}", order.PONumber);
- consignment.Supplier.ID = order.SupplierLink.ID;
- consignment.EstimatedDispatchDate = order.IssuedDate;
- consignment.EstimatedWarehouseArrival = order.DueDate;
- consignment.Description = string.Format("{0} #{1} - {2}", CurrentSection.Name, CurrentStation,
- Employees.ContainsKey(myID) ? Employees[myID] : "(unknown)");
- new Client<Consignment>().Save(consignment, "Created by Factory Floor Purchase");
- Progress.SetMessage("Processing Order");
- var orderitems = new List<PurchaseOrderItem>();
- var packetupdates = new List<ManufacturingPacket>();
- var query = new MultiQuery();
- query.Add(
- new Filter<SupplierProduct>(x => x.Product.ID).IsEqualTo(window.ProductID).And(x => x.SupplierLink.ID)
- .IsEqualTo(window.SupplierID),
- new Columns<SupplierProduct>(x => x.Job.ID).Add(x => x.CostPrice).Add(x => x.Product.NettCost)
- );
- query.Add(
- new Filter<Product>(x => x.ID).IsEqualTo(window.ProductID),
- new Columns<Product>(x => x.NettCost)
- );
- query.Query();
- var supprods = query.Get<SupplierProduct>().Rows.Select(x => x.ToObject<SupplierProduct>()).ToArray();
- var supprice = supprods.FirstOrDefault(x => Equals(x.Job.ID, Guid.Empty));
- var prodprice = query.Get<Product>().Rows.FirstOrDefault()?.ToObject<Product>();
- var stdcost = supprice != null
- ? supprice.CostPrice
- : prodprice != null
- ? prodprice.NettCost
- : 0.0F;
- foreach (var row in window.Selected)
- {
- var treatment = row.ToObject<ManufacturingTreatment>();
- var packet = Packets.Rows.First(p => p.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(treatment.Packet.ID))
- .ToObject<ManufacturingPacket>();
- packetupdates.Add(packet);
- var item = new PurchaseOrderItem();
- item.PurchaseOrderLink.ID = order.ID;
- item.Job.ID = treatment.Packet.SetoutLink.JobLink.ID;
- item.Packet.ID = packet.ID;
- item.Consignment.ID = consignment.ID;
- item.Product.ID = window.ProductID;
- item.Qty = packet.BarcodeQty;
- item.Dimensions.Length = treatment.Parameter == 0.0F ? 1.0F : treatment.Parameter;
- var jobprice = supprods.FirstOrDefault(x => x.Job.ID.Equals(item.Job.ID));
- item.Cost = jobprice != null ? jobprice.CostPrice : stdcost;
- var description = new List<string>();
- description.Add(string.Format("{0} x {1} - {2}", packet.BarcodeQty, packet.Serial, packet.Title));
- var dimensions = new List<string>();
- if (packet.Height > 0.0F)
- dimensions.Add(string.Format("H:{0:F2}mm", packet.Height));
- if (packet.Width > 0.0F)
- dimensions.Add(string.Format("W:{0:F2}mm", packet.Width));
- if (packet.Length > 0.0F)
- dimensions.Add(string.Format("L:{0:F2}mm", packet.Length));
- dimensions.Add(string.Format("Param:{0:F4}", treatment.Parameter));
- if (dimensions.Any())
- description.Add(string.Format("Dimensions: {0}", string.Join(" ", dimensions)));
- item.Description = string.Join("\n", description);
- orderitems.Add(item);
- }
- new Client<PurchaseOrderItem>().Save(orderitems, "Created by Factory Floor Purchase");
- Progress.SetMessage("Updating Packets");
- foreach (var orderitem in orderitems)
- {
- var packet = packetupdates.FirstOrDefault(x => x.ID.Equals(orderitem.Packet.ID));
- if (packet != null)
- packet.OrderItem.ID = orderitem.ID;
- }
- new Client<ManufacturingPacket>().Save(packetupdates.Where(x => x.IsChanged()), "");
- Progress.SetMessage("Creating Delivery");
- var delivery = new Delivery();
- delivery.Date = DateTime.Today;
- delivery.Due = DateTime.Today;
- delivery.Employee.ID = myID;
- var sb = new StringBuilder();
- sb.Append("Serial # ");
- sb.AppendLine();
- if (Employees.ContainsKey(myID))
- sb.AppendLine();
- delivery.Notes = string.Format("Delivery of Items for processing to {0}\nOrder #{1} (raised on {2:dd MMM yy} by {3})\nItems: {4}",
- order.SupplierLink.Name,
- order.PONumber,
- delivery.Date,
- myName,
- string.Join(", ",
- orderitems.Select(x =>
- string.Format("{0}{1}", x.Description.Split('\n').FirstOrDefault(), x.Qty > 1 ? " (x" + x.Qty.ToString("F0") + ")" : "")))
- );
- new Client<Delivery>().Save(delivery, "Created by Factory Floor Purchase");
- Progress.Close();
- PrintDeliveryBarcode(delivery, order, consignment);
- PrintOrderItemBarcodes(delivery, order, consignment);
- SendPurchaseNotification(order.PONumber);
- MessageBox.Show("All Done");
- new DeliveryBuilder(delivery.ID, order.ID).ShowDialog();
- Refresh();
- }
- private void SendPurchaseNotification(string PONumber)
- {
- var updates = new List<Notification>();
- var roles = new Client<EmployeeRole>().Query(new Filter<EmployeeRole>(x => x.RoleLink.Code).IsEqualTo("PURCHASES"));
- foreach (var role in roles.Rows)
- {
- var notification = new Notification
- {
- Title = string.Format("Treatment PO #{0} has been raised", PONumber),
- Description = "The above Purchase Order has been created, and is ready to be checked and issued to the relevant supplier."
- };
- notification.Sender.ID = myID;
- notification.Employee.ID = role.Get<EmployeeRole, Guid>(x => x.EmployeeLink.ID);
- updates.Add(notification);
- }
- new Client<Notification>().Save(updates, "Sent Notification");
- }
- private void PrintDeliveryBarcode(Delivery delivery, PurchaseOrder order, Consignment consignment)
- {
- var model = new ManufacturingTreatmentDataModel(order, delivery, consignment);
- var templatename = "Print Treatment Delivery Bar Code";
- var sectionName = "Treatment Delivery Bar Code";
- var template = new Client<ReportTemplate>()
- .Load(
- new Filter<ReportTemplate>(x => x.Name).IsEqualTo(templatename)
- .And(x => x.DataModel).IsEqualTo(model.Name)
- .And(x => x.Section).IsEqualTo(sectionName)
- ).FirstOrDefault();
- if (template == null)
- {
- template = new ReportTemplate
- {
- DataModel = model.Name,
- Section = sectionName,
- Name = templatename
- };
- new Client<ReportTemplate>().Save(template, "Auto Created Report Template");
- }
- ReportUtils.PreviewReport(template, model, !Security.IsAllowed<CanDesignReports>(), Security.IsAllowed<CanDesignReports>());
- }
- private void PrintOrderItemBarcodes(Delivery delivery, PurchaseOrder order, Consignment consignment)
- {
- var model = new ManufacturingTreatmentDataModel(order, delivery, consignment);
- var templatename = "Print Treatment Item Bar Codes";
- var sectionName = "Treatment Item Bar Code";
- var template = new Client<ReportTemplate>()
- .Load(
- new Filter<ReportTemplate>(x => x.Name).IsEqualTo(templatename)
- .And(x => x.DataModel).IsEqualTo(model.Name)
- .And(x => x.Section).IsEqualTo(sectionName)
- ).FirstOrDefault();
- if (template == null)
- {
- template = new ReportTemplate
- {
- DataModel = model.Name,
- Section = sectionName,
- Name = templatename
- };
- new Client<ReportTemplate>().Save(template, "Auto Created Report Template");
- }
- ReportUtils.PreviewReport(template, model, !Security.IsAllowed<CanDesignReports>(), Security.IsAllowed<CanDesignReports>());
- }
- private CoreTable POItemTable(IEnumerable<PurchaseOrderItem> items)
- {
- var result = new CoreTable();
- result.LoadColumns(typeof(PurchaseOrderItem));
- result.LoadRows(items);
- return result;
- }
- private void DoSelectLostTime(PanelAction obj)
- {
- var chooser = new FactoryLostTimeChooser();
- if (chooser.ShowDialog() == true)
- {
- LostTime = chooser.SelectedLostTime;
- LostTimeDescription.Content = LostTime.Description;
- LostTimeActive.Visibility = Visibility.Visible;
- }
- }
- private void CancelLostTime_Click(object sender, RoutedEventArgs e)
- {
- LostTime = null;
- LostTimeActive.Visibility = Visibility.Collapsed;
- }
- //private void Current_DispatcherUnhandledException(object sender, DispatcherUnhandledExceptionEventArgs e)
- //{
- // MessageBox.Show("Exception!\n\n" + e.Exception.Message + "\n\n" + e.Exception.StackTrace);
- // e.Handled = true;
- //}
- private void Section_SelectionChanged(object sender, SelectionChangedEventArgs e)
- {
- if (!IsReady)
- return;
- CurrentSection = Sections[Section.SelectedIndex];
- //Kanban.Columns.Clear();
- //Kanban.Columns.Add(new KanbanColumn() { Title = CurrentSection, Categories = CurrentSection.ID.ToString() });
- //Kanban.Columns[0].AllowDrag = false;
- //Kanban.Columns[0].PreviewMouseWheel += CardBorder_PreviewMouseWheel;
- IsReady = false;
- Station.Items.Clear();
- for (var i = 1; i <= CurrentSection.Stations; i++)
- Station.Items.Add(string.Format("Station #{0}", i));
- IsReady = true;
- Station.SelectedIndex = 0;
- }
- private void Station_SelectionChanged(object sender, SelectionChangedEventArgs e)
- {
- if (!IsReady)
- return;
- SelectSectionAndStation(CurrentSection.ID, Station.SelectedIndex + 1);
- }
- private void SelectSectionAndStation(Guid section, int station)
- {
- CurrentKanban = null;
- CurrentStation = station;
- settings.Section = section;
- settings.Station = CurrentStation - 1;
- new LocalConfiguration<FactoryFloorLocalSettings>().Save(settings);
- DoRefresh(true);
- }
- private void LoadKanban()
- {
- using (new WaitCursor())
- {
- if (CurrentKanban == null)
- {
- ButtonStack.Children.Clear();
- LoadDrawing(null);
- }
- else if (true) // Kanban has changed - how do we figure this out
- {
- var packet = KanbanToPacket(CurrentKanban);
- //SetoutStage stage = packet.GetCurrentStage();
- var row = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(packet.ID)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- var station = row != null ? row.Get<ManufacturingPacketStage, int>(c => c.Station) : 0;
- var quality = row != null ? row.Get<ManufacturingPacketStage, QualityStatus>(c => c.QualityStatus) : QualityStatus.NotChecked;
- var percentage = row != null ? row.Get<ManufacturingPacketStage, double>(c => c.PercentageComplete) : 0.00F;
- var Pending = station == 0; //packet.StageLink.Station == 0;
- // Set the Proper Button Set for this type of Packet
- MfgRow.Height = Pending ? new GridLength(00) : new GridLength(50);
- foreach (var btn in FindVisualChildren<Button>(ButtonGrid))
- btn.IsEnabled = CurrentKanban != null;
- var idle = CompleteButton.Background;
- var current = new SolidColorBrush(Colors.SteelBlue);
- Update100Button.Background = percentage >= 100.0F ? current : idle;
- Update075Button.Background = percentage >= 75.0F ? current : idle;
- Update050Button.Background = percentage >= 50.0F ? current : idle;
- Update025Button.Background = percentage >= 25.0F ? current : idle;
- Update000Button.Background = percentage >= 00.0F ? current : idle;
- Button firstbutton = null;
- //LoadDrawing(Guid.Empty);
- ButtonStack.Children.Clear();
- // If we are quality checking, add the QA Check button
- if (!Pending)
- {
- var qabtn = new Button();
- qabtn.Content = "Quality Checks";
- qabtn.Tag = null;
- qabtn.Style = Resources["UnselectedButton"] as Style;
- qabtn.Click += ViewQualityChecks;
- ButtonStack.Children.Add(qabtn);
- if (packet.Drawing.IsValid())
- {
- var pdfbtn = new Button();
- pdfbtn.Content = packet.Drawing.FileName.ToLower();
- pdfbtn.Tag = packet.Drawing;
- pdfbtn.Style = Resources["UnselectedButton"] as Style;
- pdfbtn.Click += ViewDrawing;
- ButtonStack.Children.Add(pdfbtn);
- firstbutton = pdfbtn;
- }
- // List all available PDFs for this Setout
- documents = new Client<SetoutDocument>().Load(
- new Filter<SetoutDocument>(x => x.EntityLink.ID).IsEqualTo(CurrentKanban.SetoutID));
- foreach (var document in documents)
- if (document.DocumentLink != null && document.DocumentLink.FileName != null)
- if (document.DocumentLink.FileName.ToLower().EndsWith(".pdf") ||
- document.DocumentLink.FileName.ToLower().EndsWith(".png") ||
- document.DocumentLink.FileName.ToLower().EndsWith(".bmp") ||
- document.DocumentLink.FileName.ToLower().EndsWith(".jpg"))
- {
- var pdfbtn = new Button();
- pdfbtn.Content = document.DocumentLink.FileName.ToLower() +
- (!document.Superceded.IsEmpty() ? " (SUPERCEDED)" : "");
- pdfbtn.Tag = document.DocumentLink;
- pdfbtn.Style = Resources["UnselectedButton"] as Style;
- pdfbtn.Click += ViewDrawing;
- ButtonStack.Children.Add(pdfbtn);
- if (document.Superceded.IsEmpty())
- if ((PDFEditor != null && PDFEditor.Document.ID.Equals(document.ID)) || firstbutton == null)
- firstbutton = pdfbtn;
- }
- if (firstbutton == null)
- firstbutton = qabtn;
- }
- if (firstbutton != null)
- //SetCurrentButton(firstbutton);
- firstbutton.RaiseEvent(new RoutedEventArgs(ButtonBase.ClickEvent));
- else
- LoadDrawing(null);
- } // Kanban has not changed - do nothing
- }
- }
- private void SetCurrentButton(Button button)
- {
- if (_currentButton != null)
- _currentButton.Style = Resources["UnselectedButton"] as Style;
- _currentButton = button;
- button.Style = Resources["SelectedButton"] as Style;
- }
- private void SwimLaneSelected(object sender, MouseButtonEventArgs e)
- {
- }
- private void CardSelected(object sender, MouseButtonEventArgs e)
- {
- var border = (Border)sender;
- CurrentKanban = (ManufacturingKanban)border.Tag;
- UpdateSelectedKanban();
- }
- private bool CheckedPacketsChanged(Dictionary<Guid, Tuple<DateTime, DateTime>> lastCheckedPackets,
- Dictionary<Guid, Tuple<DateTime, DateTime>> newCheckedPackets)
- {
- if (lastCheckedPackets.Count != newCheckedPackets.Count)
- return true;
- foreach (var key in lastCheckedPackets.Keys)
- {
- if (!newCheckedPackets.ContainsKey(key))
- return true;
- if (!newCheckedPackets[key].Item1.Equals(lastCheckedPackets[key].Item1))
- return true;
- if (!newCheckedPackets[key].Item2.Equals(lastCheckedPackets[key].Item2))
- return true;
- }
- return false;
- }
- private void UpdateSelectedKanban(bool uncheckothers = true)
- {
- if (CurrentKanban != null)
- {
- var others = Kanbans.Where(x => x.Checked && x.Assignee != CurrentKanban.Assignee).ToArray();
- foreach (var other in others)
- other.Checked = false;
- others = Kanbans.Where(x => x.Checked).ToArray();
- if (others.Length == 1)
- others[0].Checked = false;
- others = Kanbans.Where(x => x.IsSelected).ToArray();
- foreach (var other in others)
- {
- other.IsSelected = false;
- var pkt = KanbanToPacket(other);
- if (pkt != null)
- //var stg = Stages.FirstOrDefault(x => x.ManufacturingPacketLink.ID.Equals(pkt.ID));
- other.SelectedColor = other.ColorKey;
- else
- other.SelectedColor = other.ColorKey;
- }
- CurrentKanban.Checked = true;
- CurrentKanban.IsSelected = true;
- CurrentKanban.SelectedColor = SELECTED_COLOR;
- }
- //UpdateTimeTracking();
- Kanban.ItemsSource = null;
- Kanban.ItemsSource = Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- LoadKanban();
- }
- private void CardChecked(object sender, RoutedEventArgs e)
- {
- //UpdateTimeTracking();
- try
- {
- var chk = sender as CheckBox;
- var border = (chk.Parent as Grid).Parent as Border;
- var kanban = border.Tag as ManufacturingKanban;
- kanban.Checked = chk.IsChecked == true;
- if (kanban.Checked)
- foreach (var other in Kanbans.Where(x => x.Assignee != kanban.Assignee))
- other.Checked = false;
- }
- catch (Exception err)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", err.Message, err.StackTrace));
- }
- //Kanban.ItemsSource = null;
- //Kanban.ItemsSource = Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- }
- private void CompleteButton_Click(object sender, RoutedEventArgs e)
- {
- var packets = new List<ManufacturingPacket>();
- foreach (var kanban in Kanbans.Where(x => x.Checked || x.IsSelected))
- {
- var packet = KanbanToPacket(kanban);
- if (packet.StageLink.SectionID != CurrentSection.ID)
- {
- MessageBox.Show("You cannot complete a distributed packet that is not yet progressed to your station!");
- return;
- }
- var qacomplete = true;
- var stage = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(packet.ID)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- if (stage != null)
- {
- var qadata = stage.Get<ManufacturingPacketStage, string>(c => c.FormData);
- var questions = LoadQAQuestions(packet, true, true);
- var answers = string.IsNullOrWhiteSpace(qadata)
- ? new Dictionary<Guid, object>()
- : Serialization.Deserialize<Dictionary<Guid, object>>(qadata);
- foreach (var question in questions)
- {
- var parameters = question.ParseParameters();
- var bAnswerRequired = question.Answer != QAAnswer.Comment &&
- (!parameters.ContainsKey("Default") || string.IsNullOrWhiteSpace(parameters["Default"]));
- if (bAnswerRequired && (!answers.ContainsKey(question.ID) || answers[question.ID] == null))
- {
- qacomplete = false;
- break;
- }
- }
- }
- if (!qacomplete)
- {
- MessageBox.Show("You must complete the required QA checks before completing these items!");
- return;
- }
- packets.Add(packet);
- }
- Progress.Show("Scanning Packets");
- //Filter<ManufacturingPacketStage> stgflt = new Filter<ManufacturingPacketStage>(x => x.ID).IsEqualTo(CoreUtils.FullGuid);
- //foreach (var pkt in packets)
- // stgflt = stgflt.Or(x => x.ManufacturingPacketLink.ID).IsEqualTo(pkt.ID);
- //ManufacturingPacketStage[] stgs = new Client<ManufacturingPacketStage>().Load(stgflt, new SortOrder<ManufacturingPacketStage>(x => x.Sequence));
- var stage_updates = new List<ManufacturingPacketStage>();
- for (var i = 0; i < packets.Count; i++)
- {
- var packet = packets[i];
- var stagerows = Stages.Rows.Where(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(packet.ID));
- var stages = stagerows.Select(r => r.ToObject<ManufacturingPacketStage>());
- //var stages = stgs.Where(x => x.ManufacturingPacketLink.ID.Equals(packet.ID));
- long sequence = 0;
- // Send the update to the server
- var stage = stages.FirstOrDefault(x => x.ID.Equals(packet.StageLink.ID));
- if (stage != null)
- {
- stage.Completed = DateTime.Now;
- stage.FormCompleted = DateTime.Now;
- stage.FormCompletedBy.ID = ClientFactory.UserGuid;
- stage.PercentageComplete = 100.0F;
- if (!stage_updates.Contains(stage))
- stage_updates.Add(stage);
- sequence = stage.Sequence;
- }
- // Also update the local copy (hacky hacky)
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.ID).Equals(packet.StageLink.ID));
- if (stagerow != null)
- {
- stagerow.Set<ManufacturingPacketStage, DateTime>(x => x.Completed, DateTime.Now);
- stagerow.Set<ManufacturingPacketStage, DateTime>(x => x.FormCompleted, DateTime.Now);
- stagerow.Set<ManufacturingPacketStage, Guid>(x => x.FormCompletedBy.ID, ClientFactory.UserGuid);
- stagerow.Set<ManufacturingPacketStage, double>(x => x.PercentageComplete, 100.0F);
- }
- // Update the pointer to the next stage
- // But only if it's at your station already
- // This takes into account distributed packets that may not be completed elsewhere
- if (packet.StageLink.SectionID == CurrentSection.ID)
- {
- stage = stages.Where(x => x.Sequence > sequence).FirstOrDefault();
- // If this is a distributed packet, then it may already have data allocated to it
- // We on;y want to reset the next stage if it's not distributed
- if (!packet.Distributed)
- if (stage != null)
- {
- stage.QualityStatus = QualityStatus.NotChecked;
- stage.QualityNotes = "";
- stage.Station = 0;
- stage.Started = DateTime.MinValue;
- stage.Completed = DateTime.MinValue;
- stage.PercentageComplete = 0.0F;
- if (!stage_updates.Contains(stage))
- stage_updates.Add(stage);
- }
- }
- packet.StageLink.ID = stage == null ? CoreUtils.FullGuid : stage.ID;
- packet.Issued = !packet.StageLink.IsValid() ? DateTime.MinValue : packet.Issued.IsEmpty() ? DateTime.Now : packet.Issued;
- packet.Completed = packet.StageLink.ID.Equals(CoreUtils.FullGuid)
- ? packet.Completed.IsEmpty() ? DateTime.Now : packet.Completed
- : DateTime.MinValue;
- }
- Progress.SetMessage("Progressing Items");
- new Client<ManufacturingPacketStage>().Save(stage_updates, "ManufacturingPacket Progressed from Factory Floor");
- new Client<ManufacturingPacket>().Save(packets, "ManufacturingPacket Progressed From Factory Floor");
- //UpdateTimeTracking();
- Heartbeat(new TimeSpan(0L));
- CurrentKanban = null;
- Refresh();
- Progress.Close();
- }
- private void UpdateButtonClick(object sender, RoutedEventArgs e)
- {
- Progress.Show("");
- double percent = 0.0F;
- if (double.TryParse(((Button)sender).Tag.ToString(), out percent))
- {
- var selected = new List<ManufacturingPacket>();
- var stages = new List<ManufacturingPacketStage>();
- foreach (var kanban in Kanbans.Where(x => x.Checked || x.IsSelected))
- {
- selected.Add(KanbanToPacket(kanban));
- var pktid = Guid.Parse(kanban.ID);
- var stagerows = Stages.Rows.Where(r =>
- r.Get<ManufacturingPacketStage, Guid>(c => c.SectionID).Equals(CurrentSection.ID) &&
- r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(pktid));
- stages.AddRange(stagerows.Select(r => r.ToObject<ManufacturingPacketStage>()));
- }
- var updates = new List<ManufacturingPacketStage>();
- foreach (var stage in stages)
- {
- var bChanged = false;
- if (stage.Started == DateTime.MinValue)
- {
- stage.Started = DateTime.Now;
- bChanged = true;
- }
- if (stage.PercentageComplete != percent)
- {
- stage.PercentageComplete = percent;
- bChanged = true;
- }
- if (stage.Station != -1 && stage.Station != CurrentStation)
- {
- stage.Station = CurrentStation;
- bChanged = true;
- }
- if (bChanged)
- updates.Add(stage);
- }
- new Client<ManufacturingPacketStage>().Save(updates, "Progress Updated from Factory Floor");
- DoRefresh(true);
- }
- Progress.Close();
- }
- private void BarcodesButton_Click(object sender, RoutedEventArgs e)
- {
- //List<ManufacturingPacket> updates = new List<ManufacturingPacket>();
- var checkedpackets =
- Packets.Rows.Where(p => Kanbans.Any(k => k.Checked && p.Get<ManufacturingPacket, Guid>(c => c.ID).ToString().Equals(k.ID)));
- if (!checkedpackets.Any())
- {
- MessageBox.Show("Please select a packet before continuing");
- return;
- }
- Progress.Show("");
- Filter<ManufacturingPacket> pktflt = null;
- foreach (var row in checkedpackets)
- pktflt = pktflt == null
- ? new Filter<ManufacturingPacket>(x => x.ID).IsEqualTo(row.Get<ManufacturingPacket, Guid>(c => c.ID))
- : pktflt.Or(x => x.ID).IsEqualTo(row.Get<ManufacturingPacket, Guid>(c => c.ID));
- var pkts = new Client<ManufacturingPacket>().Load(pktflt);
- foreach (var pkt in pkts)
- //var pkt = row.ToObject<ManufacturingPacket>();
- if (pkt.BarcodePrinted == DateTime.MinValue)
- pkt.BarcodePrinted = DateTime.Now;
- //updates.Add(pkt);
- //if (updates.Any())
- //{
- Progress.SetMessage("Creating Barcodes");
- new Client<ManufacturingPacket>().Save(pkts, "Delivery Barcodes created");
- //}
- Filter<DeliveryItem> filter = null;
- foreach (var row in checkedpackets)
- {
- var pktid = row.Get<ManufacturingPacket, Guid>(c => c.ID);
- if (filter == null)
- filter = new Filter<DeliveryItem>(x => x.ManufacturingPacketLink.ID).IsEqualTo(pktid);
- else
- filter = filter.Or(x => x.ManufacturingPacketLink.ID).IsEqualTo(pktid);
- }
- var dataenvironment = new Dictionary<Type, CoreTable>();
- var model = new DeliveryItemDataModel(filter);
- var Group = Packets.Rows.Select(r => r.Get<ManufacturingPacket, string>(c => c.Group)).FirstOrDefault();
- var BaseReportName = "Print Bar Codes";
- var sectionName = "Delivery Items";
- var repflt = new Filter<ReportTemplate>(x => x.Name).IsEqualTo(BaseReportName);
- var DesiredReportName = BaseReportName + (!string.IsNullOrWhiteSpace(Group) ? " - " + Group : "");
- if (DesiredReportName != BaseReportName)
- repflt = repflt.Or(x => x.Name).IsEqualTo(DesiredReportName);
- var repflt2 = new Filter<ReportTemplate>(x => x.DataModel).IsEqualTo(model.Name).And(x => x.Section).IsEqualTo(sectionName);
- repflt2.Ands.Add(repflt);
- var templates = new Client<ReportTemplate>().Load(repflt2);
- var report = templates.FirstOrDefault(x => x.Name == DesiredReportName);
- if (report == null)
- report = templates.FirstOrDefault(x => x.Name == BaseReportName);
- if (report == null)
- {
- Progress.Close();
- MessageBox.Show("Ready To Go -> [Print Bar Codes] report does not exist!");
- Refresh();
- }
- Progress.Close();
- ReportUtils.PreviewReport(report, model, false, Security.IsAllowed<CanDesignReports>());
- Refresh();
- }
- private void ViewDrawing(object sender, RoutedEventArgs e)
- {
- var button = (Button)sender;
- SetCurrentButton(button);
- var doc = button.Tag as IEntityLink;
- LoadDrawing(doc.ID);
- }
- private void Search_KeyUp(object sender, KeyEventArgs e)
- {
- SearchFilter = Search.Text;
- if (e.Key == Key.Enter || string.IsNullOrEmpty(Search.Text))
- {
- ClearAllSelections();
- ReloadPackets(true);
- }
- }
- //private void SwimlaneCheckBox_Checked(object sender, RoutedEventArgs e)
- //{
- // CheckBox chk = sender as CheckBox;
- // String tag = chk.Tag as String;
- // foreach (var packet in Kanbans)
- // packet.Checked = (packet.Assignee == tag) ? !packet.Checked : false;
- // Kanban.ItemsSource = null;
- // Kanban.ItemsSource = Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- //}
- //private void CardBorder_PreviewMouseWheel(object sender, MouseWheelEventArgs e)
- //{
- // e.Handled = true;
- // var eventArg = new MouseWheelEventArgs(e.MouseDevice, e.Timestamp, e.Delta);
- // eventArg.RoutedEvent = UIElement.MouseWheelEvent;
- // eventArg.Source = sender;
- // var tgts = FindVisualChildren<UIElement>(Kanban.Columns[0]);
- // foreach (var tgt in tgts)
- // tgt.RaiseEvent(eventArg);
- //}
- private void PacketMenu_Opened(object sender, RoutedEventArgs e)
- {
- var menu = sender as ContextMenu;
- var setcurrent = menu.Items[0] as MenuItem;
- var setpending = menu.Items[1] as MenuItem;
- var actionseparator = menu.Items[2] as Separator;
- var settrolley = menu.Items[3] as MenuItem;
- var cleartrolley = menu.Items[4] as MenuItem;
- var trolleyseparator = menu.Items[5] as Separator;
- var setpriority = menu.Items[6] as MenuItem;
- var clearpriority = menu.Items[7] as MenuItem;
- var editissues = menu.Items[8] as MenuItem;
- var sethold = menu.Items[9] as MenuItem;
- var clearhold = menu.Items[10] as MenuItem;
- var setdistributed = menu.Items[11] as MenuItem;
- var cleardistributed = menu.Items[12] as MenuItem;
- var distseparator = menu.Items[13] as Separator;
- var setshared = menu.Items[14] as MenuItem;
- var clearshared = menu.Items[15] as MenuItem;
- var movepacket = menu.Items[16] as MenuItem;
- var model = menu.Tag as ManufacturingKanban;
- if (!model.Checked)
- {
- foreach (var kanban in Kanbans.Where(x => x.Checked).ToArray())
- kanban.Checked = false;
- model.Checked = true;
- //Kanban.ItemsSource = null;
- //Kanban.ItemsSource = Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- }
- var checkedkanbans = Kanbans.Where(k => k.Checked).Select(x => Guid.Parse(x.ID));
- var checkedpackets = Packets.Rows.Where(r => checkedkanbans.Contains(r.Get<ManufacturingPacket, Guid>(c => c.ID)));
- var checkedstages = Stages.Rows.Where(r => checkedkanbans.Contains(r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID))
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- // Only if we right-click on a checked packet??
- if (checkedpackets.Any() && checkedstages.Any())
- {
- var iStation = checkedstages.First().Get<ManufacturingPacketStage, int>(c => c.Station);
- setcurrent.Visibility = iStation == 0 ? Visibility.Visible : Visibility.Collapsed;
- setpending.Visibility = iStation > 0 ? Visibility.Visible : Visibility.Collapsed;
- actionseparator.Visibility = Visibility.Collapsed;
- settrolley.Visibility = Visibility.Visible;
- cleartrolley.Visibility =
- checkedpackets.Select(r => r.Get<ManufacturingPacket, string>(x => x.Trolleys)).Any(x => !string.IsNullOrWhiteSpace(x))
- ? Visibility.Visible
- : Visibility.Collapsed;
- setpriority.Visibility = Visibility.Collapsed; // (packet != null) && packet.Priority ? Visibility.Collapsed : Visibility.Visible;
- clearpriority.Visibility = Visibility.Collapsed; // (packet != null) && packet.Priority ? Visibility.Visible : Visibility.Collapsed;
- editissues.Visibility = Visibility.Visible;
- sethold.Visibility =
- false //Security.IsAllowed<CanManagePacketHolds>() && checkedpackets.Any(r => !r.Get<ManufacturingPacket, bool>(c => c.OnHold))
- ? Visibility.Visible
- : Visibility.Collapsed;
- clearhold.Visibility =
- false //Security.IsAllowed<CanManagePacketHolds>() && checkedpackets.Any(r => r.Get<ManufacturingPacket, bool>(c => c.OnHold))
- ? Visibility.Visible
- : Visibility.Collapsed;
- setdistributed.Visibility = Security.IsAllowed<CanDistributePackets>() &&
- checkedpackets.Any(r => r.Get<ManufacturingPacket, bool>(c => c.Distributed) == false)
- ? Visibility.Visible
- : Visibility.Collapsed;
- cleardistributed.Visibility = Security.IsAllowed<CanDistributePackets>() &&
- checkedpackets.Any(r => r.Get<ManufacturingPacket, bool>(c => c.Distributed))
- ? Visibility.Visible
- : Visibility.Collapsed;
- distseparator.Visibility = setdistributed.Visibility == Visibility.Visible || cleardistributed.Visibility == Visibility.Visible
- ? Visibility.Visible
- : Visibility.Collapsed;
- setshared.Visibility = iStation > 0 ? Visibility.Visible : Visibility.Collapsed;
- clearshared.Visibility = iStation < 0 ? Visibility.Visible : Visibility.Collapsed;
- movepacket.Visibility = iStation > 0 ? Visibility.Visible : Visibility.Collapsed;
- setcurrent.Tag = checkedstages;
- setpending.Tag = checkedstages;
- setpriority.Tag = checkedpackets;
- clearpriority.Tag = checkedpackets;
- editissues.Tag = checkedpackets;
- sethold.Tag = checkedpackets;
- clearhold.Tag = checkedpackets;
- setdistributed.Tag = checkedpackets;
- cleardistributed.Tag = checkedpackets;
- setshared.Tag = checkedstages;
- clearshared.Tag = checkedstages;
- movepacket.Tag = checkedstages;
- if (movepacket.Visibility == Visibility.Visible)
- {
- movepacket.Items.Clear();
- foreach (var station in Station.Items)
- {
- var sub = new MenuItem { Header = station, Tag = checkedstages };
- sub.Click += MovePacketClick;
- movepacket.Items.Add(sub);
- sub.Visibility = movepacket.Items.Count == CurrentStation ? Visibility.Collapsed : Visibility.Visible;
- }
- }
- settrolley.Tag = Kanbans.Where(k => k.Checked);
- cleartrolley.Tag = Kanbans.Where(k => k.Checked);
- //if (Trolleys == null)
- //{
- // Trolleys = new Client<ManufacturingTrolley>().Query(
- // LookupFactory.DefineFilter<ManufacturingTrolley>(),
- // LookupFactory.DefineColumns<ManufacturingTrolley>(),
- // LookupFactory.DefineSort<ManufacturingTrolley>()
- // );
- //}
- //if (Trolleys.Rows.Any())
- //{
- // settrolley.Visibility = Visibility.Visible;
- // settrolley.Items.Clear();
- // foreach (var row in Trolleys.Rows)
- // {
- // MenuItem sub = new MenuItem() { Header = row.Get<ManufacturingTrolley,String>(x=>x.Code) + ": "+ row.Get<ManufacturingTrolley, String>(x => x.Description), Tag = row.Get<ManufacturingTrolley,Guid>(x=>x.ID) };
- // sub.Click += SetTrolleyClick;
- // settrolley.Items.Add(sub);
- // }
- //}
- //else
- // settrolley.Visibility = Visibility.Collapsed;
- }
- // Disable everything
- }
- private void SetPacketToTrolley(string trolley, params ManufacturingPacket[] packets)
- {
- var updates = new List<ManufacturingPacket>();
- foreach (var packet in packets)
- if (string.Equals(packet.Trolleys, trolley))
- {
- packet.Trolleys = trolley;
- updates.Add(packet);
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacket>().Save(updates, string.Format("Moved Packet to Trolley {0}", trolley), (o, e) => { });
- foreach (var update in updates)
- {
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(update.ID));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(update.ID)
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- //ManufacturingPacketStage stage = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(x => x.Parent.ID).Equals(update.ID))?.ToObject<ManufacturingPacketStage>();
- var kanban = Kanbans.FirstOrDefault(x => x.ID.Equals(update.ID.ToString()));
- LoadModel(kanban, pktrow, stagerow, true);
- }
- }
- }
- private void SetTrolleyClick(object sender, RoutedEventArgs e)
- {
- var kanbans = (sender as MenuItem).Tag as IEnumerable<ManufacturingKanban>;
- List<string> trolleyPrePopulate = new List<string>();
- foreach (ManufacturingKanban kanban in kanbans)
- {
- if (!string.IsNullOrWhiteSpace(kanban.Trolleys))
- {
- if (kanban.Trolleys.Contains(','))
- {
- var splitTrolleys = kanban.Trolleys.Split(',');
- foreach (string s in splitTrolleys)
- {
- if (!trolleyPrePopulate.Contains(s))
- {
- trolleyPrePopulate.Add(s);
- }
- }
- }
- else
- {
- if (!trolleyPrePopulate.Contains(kanban.Trolleys))
- {
- trolleyPrePopulate.Add(kanban.Trolleys);
- }
- }
- }
- }
- var dlg = new MultiSelectWindow(typeof(ManufacturingTrolley), new Guid[] { }, trolleyPrePopulate);
- if (dlg.ShowDialog() == true)
- using (new WaitCursor())
- {
- var trolleys = new List<string>();
- foreach (ManufacturingTrolley value in dlg.Values)
- trolleys.Add(value.Code);
- var updates = new List<ManufacturingPacket>();
- foreach (var kanban in kanbans)
- {
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(Guid.Parse(kanban.ID)));
- var stagerow = Stages.Rows.FirstOrDefault(r =>
- r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(Guid.Parse(kanban.ID))
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID).Equals(settings.Section));
- var packet = pktrow.ToObject<ManufacturingPacket>();
- packet.Trolleys = string.Join(",", trolleys);
- updates.Add(packet);
- pktrow.Set<ManufacturingPacket, string>(x => x.Trolleys, packet.Trolleys);
- LoadModel(kanban, pktrow, stagerow, true);
- }
- if (updates.Any())
- {
- new Client<ManufacturingPacket>().Save(updates, "Set Trolley to " + (sender as MenuItem).Header, (objects, error) => { });
- var src = Kanban.ItemsSource;
- Kanban.ItemsSource = null;
- Kanban.ItemsSource = src;
- }
- }
- //Refresh();
- }
- private void ClearTrolleyClick(object sender, RoutedEventArgs e)
- {
- var kanbans = (sender as MenuItem).Tag as IEnumerable<ManufacturingKanban>;
- using (new WaitCursor())
- {
- var updates = new List<ManufacturingPacket>();
- foreach (var kanban in kanbans)
- {
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(Guid.Parse(kanban.ID)));
- var stagerow = Stages.Rows.FirstOrDefault(r =>
- r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(Guid.Parse(kanban.ID))
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- var packet = pktrow.ToObject<ManufacturingPacket>();
- packet.Trolleys = "";
- updates.Add(packet);
- pktrow.Set<ManufacturingPacket, string>(x => x.Trolleys, packet.Trolleys);
- LoadModel(kanban, pktrow, stagerow, true);
- }
- if (updates.Any())
- {
- new Client<ManufacturingPacket>().Save(updates, "Removed From Trolley", (objects, error) => { });
- var src = Kanban.ItemsSource;
- Kanban.ItemsSource = null;
- Kanban.ItemsSource = src;
- }
- }
- }
- private void SetCurrent_Click(object sender, RoutedEventArgs e)
- {
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- var stages = rows.Select(x => x.ToObject<ManufacturingPacketStage>()).ToArray();
- AddPacketToCurrentWorkload(stages);
- CurrentKanban = Kanbans.FirstOrDefault(x => x.ID.Equals(stages.First().Parent.ID.ToString()));
- UpdateSelectedKanban(false);
- }
- private void AddPacketToCurrentWorkload(params ManufacturingPacketStage[] stages)
- {
- var updates = new List<ManufacturingPacketStage>();
- foreach (var stage in stages)
- if (stage.Station == 0)
- {
- stage.Station = CurrentStation;
- stage.Started = DateTime.Now;
- updates.Add(stage);
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacketStage>().Save(updates, string.Format("Moved Packet to Station {0}", CurrentStation), (o, e) => { });
- foreach (var update in updates)
- {
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(update.Parent.ID));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(x => x.ID).Equals(update.ID));
- Stages.LoadRow(stagerow, update);
- var kanban = Kanbans.FirstOrDefault(x => x.ID.Equals(update.Parent.ID.ToString()));
- LoadModel(kanban, pktrow, stagerow, true);
- }
- }
- }
- private void SetPending_Click(object sender, RoutedEventArgs e)
- {
- var updates = new List<ManufacturingPacketStage>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- foreach (var row in rows)
- {
- var stage = row.ToObject<ManufacturingPacketStage>();
- if (stage.Station != 0)
- {
- stage.Station = 0;
- stage.Started = DateTime.MinValue;
- updates.Add(stage);
- }
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacketStage>().Save(updates, string.Format("Removed Packet from Station {0}", CurrentStation));
- foreach (var update in updates)
- {
- var pktrow = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(update.Parent.ID));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(x => x.ID).Equals(update.ID));
- Stages.LoadRow(stagerow, update);
- var kanban = Kanbans.FirstOrDefault(x => x.ID.Equals(update.Parent.ID.ToString()));
- LoadModel(kanban, pktrow, stagerow, true);
- }
- CurrentKanban = Kanbans.FirstOrDefault(x => x.ID.Equals(updates.First().Parent.ID.ToString()));
- UpdateSelectedKanban();
- }
- }
- private void UpdateFlag(object sender, string property, bool value)
- {
- var updates = new List<ManufacturingPacket>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- foreach (var row in rows)
- {
- var packet = row.ToObject<ManufacturingPacket>();
- CoreUtils.SetPropertyValue(packet, property, value);
- updates.Add(packet);
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacket>().Save(updates, property + " Flag " + (value ? "Set" : "Cleared"));
- Refresh();
- }
- }
- private void SetPriority_Click(object sender, RoutedEventArgs e)
- {
- UpdateFlag(sender, "Priority", true);
- }
- private void ClearPriority_Click(object sender, RoutedEventArgs e)
- {
- UpdateFlag(sender, "Priority", false);
- }
- private void EditIssues_Click(object sender, RoutedEventArgs e)
- {
- var updates = new List<ManufacturingPacket>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- var pkts = rows.Select(x => x.ToObject<ManufacturingPacket>()).ToArray();
- if (new DynamicIssuesEditor(pkts, true).ShowDialog() == true)
- {
- Progress.ShowModal("Updating Issues", progress => { new Client<ManufacturingPacket>().Save(pkts, "Updated Issues"); });
- Refresh();
- }
- // String[] issues = rows.Select(r => r.Get<ManufacturingPacket, String>(c => c.Issues)).Distinct().ToArray();
- // if (issues.Length > 1)
- // {
- // if (MessageBox.Show(
- // "Multiple Issues found! If you continue, these may be lost.\n\nAre you sure you wish to continue?",
- // "Multiple Issues",
- // MessageBoxButton.YesNo) != MessageBoxResult.Yes)
- // return;
- // }
- //
- // string issue = issues.Length > 0 ? issues.First() : "";
- // if (!TextBoxDialog.Execute("Edit Issues", ref issue))
- // return;
- //
- // foreach (var row in rows)
- // {
- // ManufacturingPacket packet = row.ToObject<ManufacturingPacket>();
- // packet.Issues = issue;
- // updates.Add(packet);
- // }
- // if (updates.Any())
- // {
- // using (new WaitCursor())
- // {
- // new Client<ManufacturingPacket>().Save(updates, "Updated Issues");
- // Refresh();
- // }
- // }
- }
- private void SetHold_Click(object sender, RoutedEventArgs e)
- {
- if (MessageBox.Show(
- "Are you sure you wish to set this packet on hold?",
- "Set Hold",
- MessageBoxButton.YesNo) != MessageBoxResult.Yes)
- return;
- UpdateFlag(sender, "OnHold", true);
- }
- private void ClearHold_Click(object sender, RoutedEventArgs e)
- {
- if (MessageBox.Show(
- "Are you sure you wish to release this packet from hold?",
- "Set Hold",
- MessageBoxButton.YesNo) != MessageBoxResult.Yes)
- return;
- UpdateFlag(sender, "OnHold", false);
- }
- private void SetDistributed_Click(object sender, RoutedEventArgs e)
- {
- UpdateFlag(sender, "Distributed", true);
- }
- private void ClearDistributed_Click(object sender, RoutedEventArgs e)
- {
- UpdateFlag(sender, "Distributed", false);
- }
- private void SetShared_Click(object sender, RoutedEventArgs e)
- {
- var updates = new List<ManufacturingPacketStage>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- foreach (var row in rows)
- {
- var stage = row.ToObject<ManufacturingPacketStage>();
- if (stage.Station > 0)
- {
- stage.Station = -1;
- updates.Add(stage);
- }
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacketStage>().Save(updates, "Set Packet as Shared");
- Refresh();
- }
- }
- private void ClearShared_Click(object sender, RoutedEventArgs e)
- {
- var updates = new List<ManufacturingPacketStage>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- foreach (var row in rows)
- {
- var stage = row.ToObject<ManufacturingPacketStage>();
- if (stage.Station == -1)
- {
- stage.Station = CurrentStation;
- updates.Add(stage);
- }
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacketStage>().Save(updates, "Cleared Shared flag from Packet");
- Refresh();
- }
- }
- private void MovePacketClick(object sender, RoutedEventArgs e)
- {
- var item = sender as MenuItem;
- var station = (item.Parent as MenuItem).Items.IndexOf(item) + 1;
- var updates = new List<ManufacturingPacketStage>();
- var rows = (sender as MenuItem).Tag as IEnumerable<CoreRow>;
- foreach (var row in rows)
- {
- var stage = row.ToObject<ManufacturingPacketStage>();
- stage.Station = station;
- updates.Add(stage);
- }
- if (updates.Any())
- using (new WaitCursor())
- {
- new Client<ManufacturingPacketStage>().Save(updates, "Moved Packet to " + item.Header);
- Refresh();
- }
- }
- public void PDFEditorSettingsChanged(object sender, string linecolor, int fontsize)
- {
- settings.LineColor = linecolor;
- settings.FontSize = fontsize;
- new LocalConfiguration<FactoryFloorLocalSettings>().Save(settings);
- }
- #region Employee Stuff
- private Dictionary<Guid, string> Employees = new() { { Guid.Empty, "" } };
- private Guid myID = Guid.Empty;
- private string myName = "";
- #endregion
- #region ManufacturingPacket Stuff
- //FactorySetup settings = new GlobalConfiguration<FactorySetup>().Load();
- //private Dictionary<Guid, Tuple<String,int>> Sections = new Dictionary<Guid, Tuple<String,int>>();
- private ManufacturingFactory[] Factories; // new ManufacturingFactory[] { };
- private ManufacturingSection[] Sections; // new ManufacturingSection[] { };
- private ManufacturingTrolley[] Trolleys; // new ManufacturingTrolley[] { };
- private CoreTable TemplateStages;
- //private ManufacturingTemplateStage[] TemplateStages = null;
- private CoreTable Questions;
- //private IList<CoreRow> AllStages = new CoreRow[] { };
- private CoreTable Packets;
- private CoreTable Stages;
- private ManufacturingSection CurrentSection;
- private int CurrentStation;
- private readonly bool PendingVisible = true;
- private ManufacturingLostTime LostTime;
- #endregion
- #region Stuff to Do with Kanbans
- public ObservableCollection<ManufacturingKanban> Kanbans { get; set; }
- private string CurrentKanbanID = "";
- private ManufacturingKanban CurrentKanban
- {
- get { return Kanbans.FirstOrDefault(x => x.ID == CurrentKanbanID); }
- set => CurrentKanbanID = value != null ? value.ID : "";
- }
- private string SearchFilter = "";
- //Border LastCard = null;
- //Border[] CheckedPackets
- //{
- // get {
- // List<Border> packets = new List<Border>();
- // var cards = Kanban.Columns[0].Cards.Where(x => ((ManufacturingKanban)x.Content).Checked == true);
- // foreach (var card in cards)
- // {
- // var prop = card.GetType().GetProperty("TemplateChild", BindingFlags.NonPublic | BindingFlags.Instance);
- // var val = prop.GetValue(card) as DependencyObject;
- // var border = FindVisualChildren<Border>(val).FirstOrDefault();
- // packets.Add(border);
- // }
- // return packets.ToArray();
- // }
- //}
- private void ClearAllSelections()
- {
- foreach (var kanban in Kanbans.Where(x => x.Checked))
- kanban.Checked = false;
- CurrentKanban = null;
- //var cards = Kanban.Columns[0].Cards.Where(x => ((ManufacturingKanban)x.Content).Checked == true).ToArray();
- //foreach (var card in cards)
- // ((ManufacturingKanban)card.Content).Checked = false;
- //CurrentKanban = null;
- UpdateSelectedKanban();
- }
- private ManufacturingKanban GetKanban(Border border)
- {
- return border.Tag as ManufacturingKanban;
- }
- //private Border GetBorder(ManufacturingKanban kanban)
- //{
- // var card = Kanban.Columns[0].Cards.FirstOrDefault(x => ((ManufacturingKanban)x.Content) == kanban);
- // var prop = card.GetType().GetProperty("TemplateChild", BindingFlags.NonPublic | BindingFlags.Instance);
- // var val = prop.GetValue(card) as DependencyObject;
- // return FindVisualChildren<Border>(val).FirstOrDefault();
- //}
- //private void CheckKanban(Border card, bool ischecked)
- //{
- // var chk = card.FindName("IsChecked") as CheckBox;
- // chk.IsChecked = ischecked;
- // card.ApplyTemplate();
- //}
- private void SelectKanban(Border card, bool isselected)
- {
- var img = card.FindName("IsCurrent") as Image;
- img.Source = isselected ? starred : null;
- }
- private ManufacturingPacket KanbanToPacket(ManufacturingKanban kanban)
- {
- if (Packets == null)
- return null;
- var row = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(Guid.Parse(kanban.ID)));
- if (row == null)
- return null;
- return row.ToObject<ManufacturingPacket>();
- }
- #endregion
- #region Shipping Rack Stuff
- private CoreTable Shipments;
- private CoreTable DeliveryItems;
- private readonly ObservableList<DeliveryItem> rackcontents = new();
- private Guid rackid = Guid.Empty;
- private string rackbarcode = "";
- #endregion
- #region Refresh / Reload
- private string GetQualityStatus(QualityStatus status)
- {
- if (status == QualityStatus.Passed)
- return "PASSED";
- if (status == QualityStatus.Skipped)
- return "SKIPPED";
- if (status == QualityStatus.PassedWithIssues)
- return "ISSUES";
- if (status == QualityStatus.Failed)
- return "FAILED";
- return "QA";
- }
- private BitmapImage GetBarCode(CoreRow row)
- {
- var type = row.Get<ManufacturingPacket, BarcodeType>(c => c.BarcodeType);
- if (!row.Get<ManufacturingPacket, DateTime>(c => c.BarcodePrinted).IsEmpty())
- return type == BarcodeType.Grouped ? grouped : barcode;
- if (type == BarcodeType.None)
- return disabled;
- return null;
- }
- private void CreateKanban(CoreRow pktrow, CoreRow stagerow, bool IsChecked)
- {
- var id = pktrow.Get<ManufacturingPacket, Guid>(c => c.ID);
- //var stagerow = Stages.Rows.FirstOrDefault(r=>r.Get<ManufacturingPacketStage,Guid>(c=>c.Parent.ID).Equals(id));
- if (stagerow == null)
- return;
- var station = stagerow.Get<ManufacturingPacketStage, int>(c => c.Station);
- //var stage = stagerow.ToObject<ManufacturingPacketStage>();
- if ((PendingVisible && station.Equals(0)) || station.Equals(-1) || station.Equals(CurrentStation))
- {
- var model = new ManufacturingKanban();
- LoadModel(model, pktrow, stagerow, IsChecked);
- Kanbans.Add(model);
- }
- }
- private void LoadModel(ManufacturingKanban model, CoreRow packet, CoreRow stage, bool IsChecked)
- {
- var station = stage.Get<ManufacturingPacketStage, int>(c => c.Station);
- var Pending = station == 0;
- var quality = stage.Get<ManufacturingPacketStage, QualityStatus>(c => c.QualityStatus);
- var percentage = stage.Get<ManufacturingPacketStage, double>(c => c.PercentageComplete);
- var packetid = packet.Get<ManufacturingPacket, Guid>(c => c.ID);
- var title = packet.Get<ManufacturingPacket, string>(c => c.Title);
- var watermark = packet.Get<ManufacturingPacket, string>(c => c.WaterMark);
- var issues = packet.Get<ManufacturingPacket, string>(c => c.Issues);
- var trolleys = packet.Get<ManufacturingPacket, string>(c => c.Trolleys);
- var serial = packet.Get<ManufacturingPacket, string>(c => c.Serial);
- var quantity = packet.Get<ManufacturingPacket, int>(c => c.Quantity);
- var barcodes = packet.Get<ManufacturingPacket, int>(c => c.BarcodeQty);
- var setoutnumber = packet.Get<ManufacturingPacket, string>(c => c.SetoutLink.Number);
- var jobname = packet.Get<ManufacturingPacket, string>(c => c.SetoutLink.JobLink.Name);
- var duedate = packet.Get<ManufacturingPacket, DateTime>(c => c.DueDate);
- var location = packet.Get<ManufacturingPacket, string>(c => c.Location);
- var setoutlocation = packet.Get<ManufacturingPacket, string>(c => c.SetoutLink.Location);
- var suppliercode = packet.Get<ManufacturingPacket, string>(c => c.OrderItem.PurchaseOrderLink.SupplierLink.Code);
- var ponumber = packet.Get<ManufacturingPacket, string>(c => c.OrderItem.PurchaseOrderLink.PONumber);
- var receiveddate = packet.Get<ManufacturingPacket, DateTime>(c => c.OrderItem.ReceivedDate);
- var receivedreference = packet.Get<ManufacturingPacket, string>(c => c.OrderItem.ReceivedReference);
- var priority = packet.Get<ManufacturingPacket, bool>(c => c.Priority);
- var estimateddate = packet.Get<ManufacturingPacket, DateTime>(c => c.EstimatedDate);
- var distributed = packet.Get<ManufacturingPacket, bool>(c => c.Distributed);
- var packetsection = packet.Get<ManufacturingPacket, string>(c => c.StageLink.Section);
- var groupid = packet.Get<ManufacturingPacket, Guid>(c => c.SetoutLink.Group.ID);
- model.TemplateID = packet.Get<ManufacturingPacket, Guid>(c => c.ManufacturingTemplateLink.ID);
- model.ID = packetid.ToString();
- model.Title = string.Format(
- "{0}: {1}{2}",
- serial,
- quantity != barcodes ? string.Format("{0} x ", quantity) : "",
- title
- );
- if (!string.IsNullOrWhiteSpace(watermark))
- model.Title = "[" + watermark + "] " + model.Title;
- model.Quantity = barcodes;
- model.JobName = string.Format("{0}: {1}", setoutnumber, jobname);
- model.DueDate = duedate;
- model.GroupID = groupid;
- var descrip = new List<string>
- {
- string.IsNullOrEmpty(location) ? setoutlocation : location
- };
- if (packet.IsEntityLinkValid<ManufacturingPacket, PurchaseOrderItemLink>(x => x.OrderItem))
- descrip.Add(string.Format("{0} ({1}) RCVD {2:dd MMM yy} {3}",
- suppliercode,
- ponumber,
- receiveddate,
- string.IsNullOrWhiteSpace(receivedreference) ? "" : ": " + receivedreference
- ));
- model.Description = string.Join("\n", descrip);
- model.Image = GetBarCode(packet);
- //model.IsCurrent = packet.ID.ToString() == CurrentKanbanID ? starred : null;
- model.IsSelected = packet.Get<ManufacturingPacket, Guid>(c => c.ID).ToString() == CurrentKanbanID;
- model.Tags = priority
- ? new[] { "PRIORITY" }
- : new string[] { };
- model.Category = CurrentSection != null
- ? CurrentSection.ID.ToString()
- : ""; // packet.StageLink.SectionID.ToString();
- model.ColorKey = packet.IsEntityLinkValid<ManufacturingPacket, PurchaseOrderItemLink>(x => x.OrderItem)
- ? TREATED_COLOR
- : priority
- ? PRIORITY_COLOR
- : !Pending
- ? GetColor(duedate.IsEmpty()
- ? DateTime.Today
- : duedate, estimateddate.IsEmpty()
- ? DateTime.Today
- : estimateddate)
- : QA_COLOR;
- model.SelectedColor = packet.Get<ManufacturingPacket, Guid>(c => c.ID).ToString() == CurrentKanbanID
- ? SELECTED_COLOR
- : model.ColorKey;
- model.SharedColor = station.Equals(-1)
- ? SHARED_COLOR
- : model.ColorKey;
- model.Checked = IsChecked;
- model.SetoutID = packet.Get<ManufacturingPacket, Guid>(c => c.SetoutLink.ID);
- model.Assignee = Pending
- ? "Not Yet Started"
- : "Current Workload";
- model.Status = !Entity.IsEntityLinkValid<ManufacturingPacket, ManufacturingPacketStageLink>(x => x.StageLink, packet)
- ? " "
- : Pending
- ? "PENDING"
- : string.Format("{0:F0}%", percentage);
- try
- {
- model.Flags = distributed
- ? !packet.Get<ManufacturingPacket, Guid>(c => c.StageLink.SectionID).Equals(CurrentSection.ID)
- ? string.IsNullOrEmpty(packetsection)
- ? ""
- : packetsection.ToUpper().Trim()
- : "DISTRIB"
- : "";
- }
- catch (Exception e)
- {
- Logger.Send(LogType.Error, "", string.Format("*** Unknown Error: {0}\n{1}", e.Message, e.StackTrace));
- }
- model.Issues = issues;
- model.IssuesImage = string.IsNullOrWhiteSpace(issues)
- ? null
- : speechbubble;
- model.Trolleys = trolleys;
-
- }
- private string GetColor(DateTime duedate, DateTime estdate)
- {
- var color = NOTYETDUE_COLOR;
- if (duedate < estdate)
- color = OVERDUE_COLOR;
- else if (duedate < estdate.AddDays(7))
- color = NEARLYDUE_COLOR;
- return color;
- }
- private void ReloadPackets(bool reloaddata)
- {
- using var profiler = new Profiler(true);
- using (new WaitCursor())
- {
- if (reloaddata)
- {
- var sectionid = CurrentSection != null ? CurrentSection.ID : CoreUtils.FullGuid;
- var stageflt = new Filter<ManufacturingPacketStage>(x => x.Completed).IsEqualTo(DateTime.MinValue)
- .Or(x => x.ManufacturingSectionLink.ID).IsEqualTo(CurrentSection.ID);
- stageflt.Ands.Add(
- new Filter<ManufacturingPacketStage>(x => x.Parent.StageLink.SectionID).IsEqualTo(sectionid)
- .Or(x => x.Parent.Distributed).IsEqualTo(true)
- );
- var stageQuery = new KeyedQueryDef<ManufacturingPacketStage>(
- stageflt,
- new Columns<ManufacturingPacketStage>(x => x.ID)
- .Add(x => x.Parent.ID)
- .Add(x => x.Station)
- .Add(x => x.QualityStatus)
- .Add(x => x.PercentageComplete)
- .Add(x => x.Time)
- .Add(x => x.Started)
- .Add(x => x.FormData)
- .Add(x => x.Completed)
- .Add(x => x.FormCompleted)
- .Add(x => x.FormCompletedBy.ID)
- .Add(x => x.Sequence)
- .Add(x => x.QualityNotes)
- .Add(x => x.SectionID)
- .Add(x => x.ManufacturingSectionLink.ID));
- var pktfilter = new Filter<ManufacturingPacket>(x => x.Completed).IsEqualTo(DateTime.MinValue)
- .And(x => x.Archived).IsEqualTo(DateTime.MinValue)
- .And(x => x.OnHold).IsEqualTo(false)
- .And(new Filter<ManufacturingPacket>(x => x.OrderItem).NotLinkValid().Or(x => x.OrderItem.ReceivedDate)
- .IsNotEqualTo(DateTime.MinValue))
- .And(new Filter<ManufacturingPacket>(x => x.StageLink.SectionID).IsEqualTo(sectionid).Or(x => x.Distributed).IsEqualTo(true));
- if (!string.IsNullOrWhiteSpace(SearchFilter))
- pktfilter = pktfilter.TextSearch(
- SearchFilter,
- x => x.SetoutLink.JobLink.JobNumber,
- x => x.SetoutLink.JobLink.Name,
- x => x.SetoutLink.Number,
- x => x.SetoutLink.Location,
- //x => x.SetoutLink.Reference,
- x => x.Title,
- x => x.Serial,
- x => x.Trolleys,
- x => x.Location
- );
- var pktcolumns = new Columns<ManufacturingPacket>(x => x.ID)
- .Add(x => x.Serial)
- .Add(x => x.Title)
- .Add(x => x.Quantity)
- .Add(x => x.BarcodeQty)
- .Add(x => x.SetoutLink.ID)
- .Add(x => x.SetoutLink.Number)
- .Add(x => x.SetoutLink.JobLink.JobNumber)
- .Add(x => x.SetoutLink.JobLink.Name)
- .Add(x => x.SetoutLink.Group.ID)
- .Add(x => x.DueDate)
- .Add(x => x.SetoutLink.Location)
- //.Add(x => x.SetoutLink.Reference)
- .Add(x => x.Priority)
- .Add(x => x.EstimatedDate)
- .Add(x => x.Distributed)
- .Add(x => x.StageLink.ID)
- .Add(x => x.StageLink.SectionID)
- .Add(x => x.StageLink.Section)
- .Add(x => x.StageLink.Deleted)
- .Add(x => x.BarcodePrinted)
- .Add(x => x.BarcodeType)
- .Add(x => x.ManufacturingTemplateLink.ID)
- .Add(x => x.ManufacturingTemplateLink.Name)
- .Add(x => x.ManufacturingTemplateLink.Code)
- //.Add(x => x.CustomAttributes)
- .Add(x => x.Trolleys)
- .Add(x => x.Location)
- .Add(x => x.Group)
- .Add(x => x.Height)
- .Add(x => x.Width)
- .Add(x => x.Length)
- .Add(x => x.OrderItem.ID)
- .Add(x => x.OrderItem.Deleted)
- .Add(x => x.OrderItem.PurchaseOrderLink.SupplierLink.Code)
- .Add(x => x.OrderItem.PurchaseOrderLink.PONumber)
- .Add(x => x.OrderItem.Consignment.EstimatedWarehouseArrival)
- .Add(x => x.OrderItem.ReceivedReference)
- //.Add(x => x.Zone.Code)
- //.Add(x => x.Level.Code)
- .Add(x => x.OrderItem.ReceivedDate)
- .Add(x => x.WaterMark)
- .Add(x => x.Issues)
- .Add(x => x.OnHold)
- .Add(DatabaseSchema.Properties(typeof(ManufacturingPacket))
- .Where(x => x is CustomProperty)
- .Select(x => x.Name).ToArray()
- );
- var pktQuery = new KeyedQueryDef<ManufacturingPacket>(
- pktfilter,
- pktcolumns,
- new SortOrder<ManufacturingPacket>(x => x.Priority, SortDirection.Descending)
- .ThenBy(x => x.SetoutLink.Number));
- var results = Client.QueryMultiple(
- stageQuery,
- pktQuery,
- new KeyedQueryDef<DeliveryItem>(
- new Filter<DeliveryItem>(x => x.DeliveredDate).IsEqualTo(DateTime.MinValue)
- .And(x => x.ManufacturingPacketLink).LinkValid(),
- new Columns<DeliveryItem>(
- x => x.ID,
- x => x.Barcode,
- x => x.ManufacturingPacketLink.ID,
- x => x.ManufacturingPacketLink.Serial,
- x => x.Description,
- x => x.ShipmentLink.ID)));
- Stages = results.Get<ManufacturingPacketStage>();
- Packets = results.Get<ManufacturingPacket>();
- DeliveryItems = results.Get<DeliveryItem>();
- }
- var checks = Kanbans.Where(x => x.Checked).Select(x => x.ID).ToArray();
- Kanbans.Clear();
- var stages = Stages.Rows
- .Select(x => new Tuple<Guid, Guid>(
- x.Get<ManufacturingPacketStage, Guid>(x => x.Parent.ID),
- x.Get<ManufacturingPacketStage, Guid>(x => x.ManufacturingSectionLink.ID)
- )).ToList();
- foreach (var pktrow in Packets.Rows)
- {
- var id = pktrow.Get<ManufacturingPacket, Guid>(c => c.ID);
- var distributed = pktrow.Get<ManufacturingPacket, bool>(c => c.Distributed);
- var stageIndex = stages.FindIndex(x => x.Item1 == id && x.Item2 == settings.Section);
- var stageRow = stageIndex >= 0 ? Stages.Rows[stageIndex] : null;
- //this was commented out previously - leading to the distributed packet issue. Uncommented and tested to work by Nick. Was there a reason for commenting this out?
- bool bOK = true;
- if (distributed)
- bOK = stageRow?.Get<ManufacturingPacketStage, DateTime>(c => c.Completed).IsEmpty() == true;
- if (bOK)
- {
- CreateKanban(pktrow, stageRow!, checks.Contains(id.ToString()));
- }
- }
- var sorted = Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- if (CurrentKanban != null && !Kanbans.Contains(CurrentKanban))
- CurrentKanban = sorted.FirstOrDefault();
- Kanban.ItemsSource = null;
- Kanban.ItemsSource =
- sorted; //Kanbans.OrderBy(x => x.Assignee).ThenByDescending(x => x.Tags.Length).ThenBy(x => x.DueDate).ThenBy(x => x.JobName);
- UpdateSelectedKanban();
- }
- }
- private void DoRefresh(bool reloaddata)
- {
- if (!IsReady || Sections == null || !Sections.Any())
- return;
- ReloadPackets(reloaddata);
- //LoadKanban();
- }
- public void Refresh()
- {
- DoRefresh(true);
- }
- #endregion
- #region QAChecks
- private IEnumerable<QAQuestion> LoadQAQuestions(ManufacturingPacket packet, bool section, bool template)
- {
- if (Questions == null)
- Questions = new Client<QAQuestion>().Query();
- if (TemplateStages == null)
- TemplateStages = new Client<ManufacturingTemplateStage>().Query();
- var tstage = TemplateStages.Rows.FirstOrDefault(r =>
- r.Get<ManufacturingTemplateStage, Guid>(c => c.Template.ID).Equals(packet.ManufacturingTemplateLink.ID) &&
- r.Get<ManufacturingTemplateStage, Guid>(c => c.Section.ID).Equals(CurrentSection.ID));
- IEnumerable<CoreRow> rows = null;
- if (section && !template)
- rows = Questions.Rows.Where(r => r.Get<QAQuestion, Guid>(c => c.QAForm.ID).Equals(CurrentSection.QAForm.ID));
- if (!section && template)
- rows = Questions.Rows.Where(r =>
- r.Get<QAQuestion, Guid>(c => c.QAForm.ID).Equals(tstage.Get<ManufacturingTemplateStage, Guid>(x => x.QAForm.ID)));
- if (section && template)
- rows = Questions.Rows.Where(r =>
- r.Get<QAQuestion, Guid>(c => c.QAForm.ID).Equals(CurrentSection.QAForm.ID) || r.Get<QAQuestion, Guid>(c => c.QAForm.ID)
- .Equals(tstage.Get<ManufacturingTemplateStage, Guid>(x => x.QAForm.ID)));
- var result = rows.Where(r => r.Get<QAQuestion, bool>(c => c.QAForm.Active).Equals(true)).Select(r => r.ToObject<QAQuestion>());
- return result;
- }
- private void ViewQualityChecks(object sender, RoutedEventArgs e)
- {
- SetCurrentButton(sender as Button);
- LoadDrawing(Guid.Empty);
- }
- private void QAGridChanged(object sender, Dictionary<Guid, object> values)
- {
- SaveQAData(values);
- }
- private void SaveQAData(Dictionary<Guid, object> values)
- {
- var updates = new List<ManufacturingPacketStage>();
- var cks = Kanbans.Where(x => x.Checked);
- foreach (var ck in cks)
- {
- //var row = Packets.Rows.FirstOrDefault(r => r.Get<ManufacturingPacket, Guid>(c => c.ID).Equals(ck.ID));
- var stagerow = Stages.Rows.FirstOrDefault(r => r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(Guid.Parse(ck.ID))
- && r.Get<ManufacturingPacketStage, Guid>(c => c.ManufacturingSectionLink.ID)
- .Equals(settings.Section));
- if (stagerow != null)
- {
- var stage = stagerow.ToObject<ManufacturingPacketStage>();
- stage.Form.ID = CurrentSection.QAForm.ID;
- stage.FormData = Serialization.Serialize(values);
- stagerow.Set<ManufacturingPacketStage, string>(x => x.FormData, stage.FormData);
- updates.Add(stage);
- }
- }
- if (updates.Any())
- Task.Run(() => { new Client<ManufacturingPacketStage>().Save(updates, "", (o, e) => { }); });
- }
- private void UpdateQuality(QualityStatus status, string note = null)
- {
- var selected = new List<ManufacturingPacket>();
- var stages = new List<ManufacturingPacketStage>();
- foreach (var kanban in Kanbans.Where(x => x.Checked || x.IsSelected))
- {
- selected.Add(KanbanToPacket(kanban));
- var pktid = Guid.Parse(kanban.ID);
- var stagerows = Stages.Rows.Where(r =>
- r.Get<ManufacturingPacketStage, Guid>(c => c.SectionID).Equals(CurrentSection.ID) &&
- r.Get<ManufacturingPacketStage, Guid>(c => c.Parent.ID).Equals(pktid));
- stages.AddRange(stagerows.Select(r => r.ToObject<ManufacturingPacketStage>()));
- }
- if (note == null)
- {
- var form = new NotesForm(Employees) { Caption = "Please detail the quality issues identified with these item(s)" };
- if (form.ShowDialog() != true) return;
- note = form.Text;
- if (form.EmployeeID != Guid.Empty)
- {
- var task = new Kanban();
- task.DueDate = DateTime.Today;
- task.Category = "Open";
- task.EmployeeLink.ID = form.EmployeeID;
- task.ManagerLink.ID = myID;
- task.Title = "QA Issues : " + CurrentSection.Factory.Name + ": " + CurrentSection.Name;
- //task.JobLink.ID = packet.JobLink.ID;
- var details = new List<string>();
- details.Add(form.Text);
- details.Add("");
- details.Add("The following packets are affected by this issue:");
- foreach (var sel in selected)
- details.Add(string.Format("- {0}: {1} ({2})", sel.SetoutLink.Number, sel.Title,
- string.IsNullOrEmpty(sel.Location) ? sel.SetoutLink.Location : sel.Location));
- task.Notes = new[] { string.Join("\n", details) };
- new Client<Kanban>().Save(task, "Created task from Factory Floor");
- note = note + "\n" + "** Task Created for " + task.EmployeeLink.Name;
- }
- }
- foreach (var stage in stages)
- {
- stage.Station = 0;
- stage.QualityStatus = status;
- if (!string.IsNullOrWhiteSpace(note))
- {
- if (!string.IsNullOrWhiteSpace(stage.QualityNotes))
- stage.QualityNotes = string.Format("{0}\n\n{1}", stage.QualityNotes, note);
- else
- stage.QualityNotes = note;
- }
- }
- Progress.Show("");
- new Client<ManufacturingPacketStage>().Save(stages, note);
- DoRefresh(true);
- Progress.Close();
- }
- #endregion
- private void RequestMaterials_Click(object sender, RoutedEventArgs e)
- {
- }
- }
- }
|