public function executeSetstatus(sfWebRequest $request)
 {
     $producttype = MyModel::fetchOne("Producttype", array('id' => $request->getParameter("id")));
     $producttype->setStatus($request->getParameter("color"));
     $producttype->save();
     $this->redirect($request->getReferer());
 }
 protected function executeBatchCreateproducttype(sfWebRequest $request)
 {
     $producttypedata = $request->getParameter('producttype');
     $producttype_name = $producttypedata["name"];
     $ids = $request->getParameter('ids');
     //search for producttype of given name
     $producttype = MyModel::fetchOne("Producttype", array('name' => '"' . $producttype_name . '"'));
     //if not found,
     if (!$producttype) {
         //create new product type
         $producttype = new Producttype();
         $producttype["name"] = $producttype_name;
         $producttype["parent_id"] = 1;
         $producttype->calcPath();
     }
     $producttype_id = $producttype->getId();
     //set products to producttype
     $records = Doctrine_Query::create()->from('Product')->whereIn('id', $ids)->execute();
     foreach ($records as $record) {
         $record->setProducttypeId($producttype_id);
         //$record->setName(str_replace("Pressure Tank","Tank",$record->getName()));
         $record->save();
     }
     $this->redirect($request->getReferer());
 }