PHP Wizards - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=38393.0&return_msg=38393.52"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=38393.1">1–10</a>…<a href="lmessages.php?webtag=DEFAULT&msg=38393.31">31–40</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.41">41–50</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.51">51–60</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.61">61–70</a>…<a href="lmessages.php?webtag=DEFAULT&msg=38393.101">101</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=38393.52">PHP Wizards</a> </h3> <div id="messages" data-navigation="38393_52_101_10"> <a name="a38393_52"></a><div class="message" id="message_38393_52"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:36</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 13:39"></span></span> <span class="message_count">52 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.52">38393.52</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.50">38393.50</a></div> <div class="message_body"> Yes, of course, (because that's how my imaginary SQL database has been configured to react).<br /> <br /> (It's been possible to do triggers with databases for <em>years</em>, long before Rails came along. Probably even before Ruby too.)<br /> <br /> <br /> It's a function (stored procedure), just like your User.findByEmail one. It's automatically generated by another one of those triggers - every time a table is created or altered - so it's faster than doing dynamic lookups with Method Missing.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.52&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.52"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_53"></a><div class="message" id="message_38393_53"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:39</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 20 Apr 2011 14:00"></span></span> <span class="message_count">53 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.53">38393.53</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.51">38393.51</a></div> <div class="message_body"> If it's a quick complicated one... I'm supposed to be finishing something off at the moment, but keep getting distracted by that dastardly Rails fan. <span class="emoticon e_angry" title=":@"><span class="e__">:@</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.53&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.53"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_54"></a><div class="message" id="message_38393_54"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time">20 Apr 2011 13:40</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 13:42"></span></span> <span class="message_count">54 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.54">38393.54</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_52" target="_self">38393.52</a></div> <div class="message_body"> Well now, that's interesting.<br /> <br /> I'd best not get too involved in this as I really don't know all that much <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.54&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.54"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_55"></a><div class="message" id="message_38393_55"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:46</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 13:47"></span></span> <span class="message_count">55 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.55">38393.55</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_54" target="_self">38393.54</a></div> <div class="message_body"> The difference is, nobody has actually created a popular framework for all this stuff (well, not that I'm aware of), but the ability to do it is there.<br /> <br /> Very little (if any) of the stuff that Rails (or others) is new - it's all been possible for decades, but either computers were too slow, or it just didn't get used in mainstream until someone actually shouted about it.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.55&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.55"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_56"></a><div class="message" id="message_38393_56"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time">20 Apr 2011 13:48</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 13:50"></span></span> <span class="message_count">56 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.56">38393.56</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_55" target="_self">38393.55</a></div> <div class="message_body"> Hmm. Why's nobody made a popular framework for it? Is that sort of thing possible in SQL? Man I really don't know much about server things <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.56&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.56"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_57"></a><div class="message" id="message_38393_57"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:56</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 13:57"></span></span> <span class="message_count">57 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.57">38393.57</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_56" target="_self">38393.56</a></div> <div class="message_body"> Well it's not pure SQL at that point, it's getting into database-specific programming languages.<br /> <br /> And I guess, especially compared to more general programming languages, they're a bit crappy - they're static typing, still needs some form of front-end to be useful, and stuff.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.57&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.57"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_58"></a><div class="message" id="message_38393_58"> <div class="message_header"> <div class="message_from"> From: Ken (SHIELDSIT)<span class="message_time">20 Apr 2011 14:01</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 14:01"></span></span> <span class="message_count">58 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.58">38393.58</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_53" target="_self">38393.53</a></div> <div class="message_body"> I don't think it's going to be quick, so I'll wait to post it.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.58&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.58"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_59"></a><div class="message" id="message_38393_59"> <div class="message_header"> <div class="message_from"> From: Ken (SHIELDSIT)<span class="message_time">20 Apr 2011 14:29</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 16:18"></span></span> <span class="message_count">59 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.59">38393.59</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_58" target="_self">38393.58</a></div> <div class="message_body"> <p>OK I've attached a screen shot of the current report and my code. Here is what I need to do, and fucked if I know if I can do it.</p> <p> </p> <p>In the screen shot you can see that everything in the description field is Red Oak except one (which is White Oak). This can change to anything.</p> <p> </p> <p>For example we could have a batch of Cherry and then one Hard Maple in the batch.</p> <p> </p> <p>So what I need to somehow do is get a majority of the type of wood it is and ignore the minority. Pretty complicated....</p></div> <div class="message_attachments"> <span>Attachments:</span> <ul> <li><span class="image attach"></span><a href="get_attachment.php?webtag=DEFAULT&hash=6ce21cec4a13632fb08fdbc089fb0491&filename=batch.cfm" target="_blank">batch.cfm</a></li> <li><span class="image attach"></span><a href="get_attachment.php?webtag=DEFAULT&hash=5132ef7abae463d8dc9260e2e5d912ef&filename=Capture.PNG" target="_blank">Capture.PNG</a></li> </ul> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.59&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.59"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_60"></a><div class="message" id="message_38393_60"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 16:45</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 20 Apr 2011 16:57"></span></span> <span class="message_count">60 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.60">38393.60</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_59" target="_self">38393.59</a></div> <div class="message_body"> I'm still busy, but want a quick break, so anyway...<br /> <br /> <div class="quotetext" id="code-CFML"><b>CFML code:</b></div><pre class="code"> <cfset WoodTypes = [] /> <cfloop query="batch_report3"> <cfset WoodName = extractWoodName(Description) /> <cfif StructKeyExists(WoodTypes,WoodName)> <cfset WoodTypes[WoodName]++ /> <cfelse> <cfset WoodTypes[WoodName] = 0 /> </cfif> </cfloop>  <cfset MaxCount = 0 /> <cfset MaxType = "" /> <cfloop item="CurType" collection=#WoodTypes#> <cfif WoodTypes[CurType] GT MaxCount > <cfset MaxCount = WoodTypes[CurType] /> <cfset MaxType = CurType /> </cfif> </cfloop> <cfoutput> <p>Most common wood type is "<b>#MaxType#</b>".</p> </cfoutput>  <cffunction name="extractWoodName" returntype="string" output="false" > <cfargument name="Text" type="string" required /> <cfset var Name = rereplace(Arguments.Text,'^\d/\d x RW','') /> <cfset Name = rereplace(Arguments.Text,'(?:prime|\da?)? (?:common|boards|unselected|blocking) green') /> <cfreturn Trim(Name) /> </cffunction></pre><br /> <br /> If one of the many crazy columns has just the wood name on its own, you don't need the extractWoodName bit.<br /> <br /> I didn't test that, so there might be bugs in it, but hopefully not.<br /> <br /> <br /> Oh, and that only returns one maximum, so if there's like 5 Cherry, 5 Hard Maple, 2 White Oak, it'll say "cherry" OR "hard maple", but not both.<br /> Don't know if that's good enough, or if you do need to cater for that?<br /> <br /> <br /> <br /> If I wasn't busy, I'd suggest a billion ways to make your code look nicer, but I will say just two things:<br /> <br /> <em>TABS ARE YOUR FRIEND!</em><br /> Identing blocks makes things MUCH easier to read.<br /> <small>(Although using <em>eight</em> space for it, like Firefox is doing above, is a tad annoying.)</small><br /> <br /> Also, you don't need lots of those #s - they basically only need to be used when outputting HTML/etc (i.e. inside cfoutput), or when using a variable in a string (i.e. inside "quotes"), but generally not in cfset tags.<div class="edit_text">EDITED: 20 Apr 2011 17:22 by BOUGHTONP</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.60&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.60"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_61"></a><div class="message" id="message_38393_61"> <div class="message_header"> <div class="message_from"> From: Ken (SHIELDSIT)<span class="message_time">20 Apr 2011 16:59</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 17:13"></span></span> <span class="message_count">61 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.61">38393.61</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.52#a38393_60" target="_self">38393.60</a></div> <div class="message_body"> <p>Yeah there is no doubt my code isn't nice.</p> <p> </p> <p>I think I've found the easiest way. There is a product id table that seems to have the types in some kind of unique code. I'll take that approach.</p> <p> </p> <p>Thanks man!</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.61&return_msg=38393.52" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.61"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="38393.62" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>