DBIx-Web

 view release on metacpan or  search on metacpan

examples/cgi-bin/cmdb.cgi  view on Meta::CPAN

				#	if (0 && !$r->{-a_sg}) { # bg highlight
				#		$r->{-a_sg} ={};
				#		my $h =$_[0]->recSel(
				#		-table=>'hdesk'
				#		,-data=>['idrm','status']
				#		,-group=>['idrm','status']
				#		,-where=>"status IN('new','draft','appr-do','scheduled','do','progress','rollback','delay','edit','appr-ok','appr-no') AND (idrm IS NOT NULL AND idrm<>'')");
				#		while(my $t=$h->fetchrow_hashref()) {
				#			$r->{-a_sg}->{$t->{idrm}} =''
				#				if !$r->{-a_sg}->{$t->{idrm}};
				#			$r->{-a_sg}->{$t->{idrm}} .=' ' .$t->{status}
				#		}
				#	}
				#	elsif ($r->{votimej} && $r->{utime} && $r->{status}
				#	&& ($r->{status} =~/^(?:draft|do|progress|rollback|delay|edit)/)
				#	&& ($r->{utime} lt substr($r->{votimej},-length($r->{utime})))
				#		) {
				#		$h =1;
				#	}
					$r->{-a_st} =$_[0]->strtime() if !$r->{-a_st};
					($v =~/^(?:ok)$/
					? '' 
					: $v 
					&& ($v=~/^(?:new|draft|appr-do|scheduled|do|progress|rollback|delay|edit|appr-ok|appr-no)$/)
					&& $r->{etime}
					&& ($r->{-a_st} gt $r->{etime})
					? 'color: red; font-weight: bold;'
					: 'color: brown; font-weight: bold')
					.($v
					&& ($v =~/^(?:do|progress|rollback|delay|edit)$/)
					&& $r->{-a_sg} && !$r->{-a_sg}->{$r->{id}}
					? '; background-color: yellow'
					: '')}
			}, ''
		,{-fld=>'stime'
			,-flg=>'euq'
			,-lbl=>'Start', -cmt=>'Start time of record described by'
			,-lbl_ru=>'Íà÷àëî', -cmt_ru=>'Äàòà è âðåìÿ íà÷àëà îïèñûâàåìîãî çàïèñüþ'
			,-inp=>{-maxlength=>20, -id=>'stime'}
			,-fdprop=>'nowrap=true'
			,-ldstyle=>$w->{-a_cmdbh_fsvrlds}
			,-ldprop=>'nowrap=true'
			,-lsthtml=>sub{/(?::00|\s00:00:00|:\d\d)$/ ? $` : $_}
			#,-inphtml=>sub{'$_'
			#		.($_[2] =~/[eq]/
			#		?$_[0]->htmlSubmitSpl(-id=>'stime_b')
			#		: '')}
			 }, ''
		,{-fld=>'etime'
			,-flg=>'euq'
			,-lbl=>'End', -cmt=>'End time of record described by'
			,-lbl_ru=>'Çàâåðø', -cmt_ru=>'Äàòà è âðåìÿ çàâåðøåíèÿ îïèñûâàåìîãî çàïèñüþ'
			,-inp=>{-maxlength=>20, -id=>'etime'}
			,-fdprop=>'nowrap=true'
			,-ldstyle=>$w->{-a_cmdbh_fsvrlds}
			,-ldprop=>'nowrap=true'
			,-lsthtml=>sub{/(?::00|\s00:00:00|:\d\d)$/ ? $` : $_}
			#,-inphtml=>sub{'$_'
			#		.($_[2] =~/[eq]/
			#		?$_[0]->htmlSubmitSpl(-id=>'etime_b') ."\n"
			#		.'<link rel="stylesheet" type="text/css" media="all" href="/jscalendar/calendar-win2k-1.css" />'
			#		.'<script type="text/javascript" src="/jscalendar/calendar.js"></script>'
			#		.'<script type="text/javascript" src="/jscalendar/lang/calendar-en.js"></script>'
			#		.'<script type="text/javascript" src="/jscalendar/calendar-setup.js"></script>'
			#		.'<script type="text/javascript">'
			#		.'Calendar.setup({'
			#		.'inputField: "stime"'
			#		.',ifFormat: "%Y-%m-%d %H:%M"'
			#		.',showsTime: true'
			#		.',timeFormat: "24"'
			#		.',button: "stime_b"'
			#		.'});'
			#		.'Calendar.setup({'
			#		.'inputField: "etime"'
			#		.',ifFormat: "%Y-%m-%d %H:%M"'
			#		.',showsTime: true'
			#		.',timeFormat: "24"'
			#		.',button: "etime_b"'
			#		.'});'
			#		.'</script>'
			#		: '')}
			 }
		,{-fld=>'object'
			,-flg=>'euq'
			,-cmt=>'Object (computer, device) of record described by'
			,-cmt_ru=>'Óíèêàëüíîå èìÿ îáúåêòà çàïèñè - êîìïüþòåðà èëè óñòðîéñòâà, ñîãëàñíî DNS'
			# ,-ddlb =>sub{$_[0]->cgiQueryFv('','object')}
			,-ddlb =>sub{$_[0]->recUnion(
					 $_[0]->cgiQueryFv('','object'
						# ,{-qkey=>{'record'=>'solution'}}
						)
					,$_[0]->recSel(-table=>'cmdbm',-data=>['name'],-key=>{'record'=>'computer'},-order=>'name')
					)}
			,-form=>'hdesk'
			,-inp=>{-maxlength=>60}
			,-fnhref=>sub{
				$_
			#	? $_[0]->urlCmd('',-form=>'cmdbm',-key=>{'name'=>$_},-cmd=>'recRead')
				? $_[0]->urlCmd('',-wikn=>$_,-wikq=>join('.', map {$_ ? $_ : ()} 'object',$_[3]->{record},$_[3]->{rectype}),-cmd=>'recRead')
				: $_[2] =~/e/
			#	? $_[0]->urlCmd('',-form=>'hdeskc',-cmd=>'recList', -frmLsc=>'object')
				? $_[0]->urlCmd('',-form=>'cmdbmn',-key=>{'record'=>'computer'},-cmd=>'recList')
				: ''}
			,-fvhref=>sub{
				$_
				? $_[0]->urlCmd('',-form=>'hdesk',-cmd=>'recList'
					,-qwhere=>'hdesk.object=' .$_[0]->dbiQuote($_)
					.' OR hdesk.subject LIKE ' .$_[0]->dbiQuote("%$_%"))
				: $_[2] =~/[eq]/
				? $_[0]->urlCmd('',-form=>'hdeskc',-cmd=>'recList', -frmLsc=>'object')
				: ''}
			},''
		,{-fld=>'application'
			,-flg=>'euq'
			,-lbl=>'Application', -cmt=>'Application or Resource (system, service, application) related to Record/Object'
			,-lbl_ru=>'Ïðèëîæåíèå', -cmt_ru=>'Ðåñóðñ èëè ïðèëîæåíèå (ñèñòåìà, êîìïîíåíò, ñåðâèñ, ïðèëîæåíèå), ê êîòîðîìó îòíîñèòñÿ çàïèñü, â ôîðìàòå \'ñèñòåìà/ïîäñèñòåìà/...\''
			# ,-ddlb =>sub{$_[0]->cgiQueryFv('','application')}
			,-ddlb =>sub{$_[0]->hreverse($_[0]->recUnion(
					 $_[0]->cgiQueryFv('','application'
						# ,{-qkey=>{'record'=>'solution'}}
						)
					,$_[0]->recSel(-table=>'cmdbm',-data=>['name'],-key=>{'record'=>'service'},-order=>'name')
					))}
			,-form=>'hdesk'



( run in 1.862 second using v1.01-cache-2.11-cpan-39bf76dae61 )